Retrieving ClickHouse Metrics for AIOps Algorithm

TLDR happy_potato wants to retrieve specific ClickHouse metrics for an AIOps algorithm. Ankit inquired about the use case and company involvement, but the issue remains unresolved.

Photo of happy_potato
happy_potato
Wed, 15 Mar 2023 13:07:33 UTC

Hi, do you know how to get the value of "Service -> Overview Metrics -> Latency, Rate(ops/s), Error Percentage" with SQL search in ClickHouse?

Photo of Ankit
Ankit
Wed, 15 Mar 2023 13:42:12 UTC

what's the use case?

Photo of happy_potato
happy_potato
Thu, 16 Mar 2023 02:55:42 UTC

The use case is: As a AIOPS algorithm engineer, I want to apply my algorithm to Latency, Rate(ops/s) and Error Percentage, so that operator can detect the anomaly instead of the static threshold.

Photo of Ankit
Ankit
Thu, 16 Mar 2023 10:53:05 UTC

hmm.. I get it. Which company do you work for? Or are you going to contribute back to OSS on this?