6 ms·
What does your schema for metrics look like? Using materialised views? I am particularly interested in storing metrics with labels(key/val pairs) Eg, Prometheus
by ankitnayan 4y ago
What does your schema for metrics look like? Using materialised views? I am particularly interested in storing metrics with labels(key/val pairs) Eg, Prometheus metrics. You can't flatten them out into columns due to high dimensionality(can need millions of columns). Do you store the labels in an array?
- datalopers 4y agoNot the person you're replying to, but you can see how SigNoz did it here [1] Essentially you add: keys Array(String), values Array(String) and write the pairs accordingly. https://github.com/SigNoz/signoz/blob/develop/deploy/docker-swarm/clickhouse-setup/docker-entrypoint-initdb.d/init-db.sql https://github.com/SigNoz/signoz/blob/develop/deploy/docker-...