Hi, can you please provide some assistance on converting PromQL to Clickhouse query? My Clickhouse queries are not returning any data. For start I would like to receive CPU usage for all hosts in a table:

100 * (1 - (avg by(host_name) (irate(system_cpu_time{state="idle"}[5m]))))

But this does not returning anything:

SELECT

host_name,

100 * (1 - avg(system_cpu_time_idle) / avg(system_cpu_time_total)) AS idle_cpu_percentage

FROM

signoz_metrics.time_serie_v2

WHERE

datetime >= now() - INTERVAL 5 MINUTE

GROUP BY

host_name

This message was deleted.

This message was deleted.

This message was deleted.

This message was deleted.

This message was deleted.

This message was deleted.

This message was deleted.

This message was deleted.

I'm getting some issues trying to run Query Service locally since updating to v0.72 OSS version, running locally with compiled version (not via Docker). Get the following error:

{"level":"\u001b[31mFATAL\u001b[0m","timestamp":"2025-02-18T15:53:09.362Z","caller":"query-service/main.go:98","msg":"Failed to create signoz struct","error":"cannot access web directory: stat /etc/signoz/web: no such file or directory","stacktrace":"main.go:98\nruntime.main\n\t/opt/homebrew/Cellar/go/1.23.1/libexec/src/runtime/proc.go:272"}