[pkg/translator/skywalking] update semconv to latest

[codeboten]

Component(s)

pkg/translator/skywalking

Describe the issue you're reporting

While removing old imports of semantic conventions (#44794) I realized that this component is still dependent on an outdated semantic conventions package

opentelemetry-collector-contrib/pkg/translator/skywalking/skywalkingproto_to_traces.go

Lines 34 to 40 in d517003

	var otSpanTagsMapping = map[string]string{
	"url": string(conventions.HTTPURLKey),
	"status_code": string(conventions.HTTPStatusCodeKey),
	"db.type": string(conventions.DBSystemKey),
	"db.instance": string(conventions.DBNameKey),
	"mq.broker": string(conventions.NetPeerNameKey),
	}

This should be updated to unblock moving to newer semantic conventions.

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Pinging code owners:

• pkg/translator/skywalking: @JaredTan95

See Adding Labels via Comments if you do not have permissions to add labels yourself.