We tried using ClickHouse as a remote storage for Prometheus.

[lyl2008dsg]

We tried using ClickHouse as a remote storage for Prometheus.
Gauge 、Histogram and so on are satisfied，hower what should Counter of prometheus do?
It expected to provide functions like MySQL lag() or lead() ?
e.g http://www.silota.com/docs/recipes/sql-mom-growth-rate.html

I tried to store metrics with Nested, and expected Calculated Growth Rate.

CREATE TABLE IF NOT EXISTS app_metrics(
   partition Date DEFAULT toDate(timestamp),
   timestamp DateTime DEFAULT now(),
   instance_id String,
   metric String,
   tags Nested
   (
     key String,
     value String
   ),
   value Float64
  ) ENGINE = MergeTree(partition, (timestamp, metric), 8192);