grafana + clickhouse模板变量使用all

wwwasw

于 2024-08-06 11:42:43 发布

阅读量461

点赞数 2

CC 4.0 BY-SA版权

文章标签： grafana clickhouse

本文链接：https://blog.youkuaiyun.com/wwwasw/article/details/140951604

在使用dashboard的模板变量时，选择all时，如下clickhouse查询语句查询，无法解析正确执行：

SELECT orderId,OrderJsonStr FROM xdatabase."xxxx_table" WHERE   ( createTime  >= $__fromTime AND createTime <= $__toTime )  AND orderId IN (${orderId}) ORDER BY orderId DESC LIMIT 300

优化为：

SELECT orderId,OrderJsonStr FROM xdatabase."xxxx_table" WHERE   ( createTime  >= $__fromTime AND createTime <= $__toTime )  AND $__conditionalAll(orderId IN (${orderId:singlequote}), $orderId) ORDER BY orderId DESC LIMIT 300

可正常执行，选择all时语句变为 1=1

参考

ClickHouse Plugin for Grafana - 2.0 Release