Open jpsfs opened 3 months ago
Thanks for the report @jpsfs Do you see any logs or errors from ClickHouse as this query fails?
Thank you for the follow-up @lmangani ! Only normal ClickHouse logs, the query itself doesn't seem to fail on ClickHouse and if I try to execute it manually it succeeds quite fast.
I forgot to mention that this was tested in the latest version (released today) as well as in the previous two versions.
If the database is smaller (less data) the query succeeds on qryn as well.
Best, José
@jpsfs do you have an error message: "timeout" in Grafana when you request histogram_quantile(0.50, ....)
?
Yes, as qryn crashes and the request in grafana gets a timeout.
Best,
On Fri, Jun 14, 2024, 11:14 akvlad @.***> wrote:
@jpsfs https://github.com/jpsfs do you have an error message: "timeout" in Grafana when you request histogram_quantile(0.50, ....) ?
— Reply to this email directly, view it on GitHub https://github.com/metrico/qryn/issues/516#issuecomment-2167708398, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAH6GOOGWMVIJITDP7MGT5TZHK67VAVCNFSM6AAAAABJJF65TCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNRXG4YDQMZZHA . You are receiving this because you were mentioned.Message ID: @.***>
@jpsfs could you please retest using the latest release and provide any feedback?
EXPERIMENTAL_PROMQL_OPTIMIZE==1
Hello @jpsfs . 3.2.24 version is released.
sum
and rate
functions were optimized using clickhouse functions.Please set the env var EXPERIMENTAL_PROMQL_OPTIMIZE=1 before usage.
Please share the user experience of using sum
and rate
functions (like in your histogram_quantile....
request) so we can decide if the further optimizations are worth to be done.
Hi!
I'm facing an issue while using PromQL through qryn.
The query is the following:
It translates to this ClickHouse query:
And after a few seconds it crashes with the following error:
Running this query directly in ClickHouse, it returns in around 150ms, with a total size of 50MiB. Any pointers on what I should do to overcome this?
Best, José