Support HTTP-protocol Clickhouse DSNs in the traces/metrics exporters

[ELLIOTTCABLE]

It looks like the logs exporter already supports this … although I haven't personally tried it:

signoz-otel-collector/exporter/clickhouselogsexporter/config.go

Line 32 in 49769fd

// For http protocol reference: [mailru/go-clickhouse/#dsn](https://github.com/mailru/go-clickhouse/#dsn).

Context: We're running into issues deploying SigNoz, due to being unable to balance the ingestion across a Clickhouse cluster. Most of our infrastructure uses NginX proxies fairly pervasively to balance/proxy/tunnel between various services and regions; and almost everything interacting with our large Clickhouse clusters goes through NginX proxies.

We'd like to use that same pattern with the SigNoz ingestor: multiple Clickhouse shards, backing (ideally, see #156) multiple signoz-otel-collectors, receiving OTLP (over HTTP) from NginX proxies living on each individual service/server/box.