Altinity / clickhouse-grafana

Altinity Grafana datasource plugin for ClickHouse®
MIT License
726 stars 121 forks source link

fixing Complex types in Labels for Logs Details visualization #673

Closed Slach closed 1 day ago

Slach commented 4 days ago

fix #672

Slach commented 1 day ago

adhoc filters from details doesn't work ;(

image image

filters works but got error on clickhouse level image

doesn't work

SELECT *
FROM default.test_logs_with_complex_labels
WHERE (_time >= toDateTime64(1732609375, 3)) AND (_time <= toDateTime64(1732782175, 3)) AND (_map = '{"map_key0":"map_value0"}')
FORMAT JSON

works with different signle quotes serialization

SELECT *
FROM default.test_logs_with_complex_labels
WHERE (_time >= toDateTime64(1732609375, 3)) AND (_time <= toDateTime64(1732782175, 3)) AND (_map = '{\'map_key0\':\'map_value0\'}')
FORMAT JSON

but this is clickhouse specific serialization, i don't know how to properly implement it for all clickhouse related invariants

Slach commented 1 day ago

image image

Slach commented 1 day ago

will fix it as separate issue, i can't propose good solution now ;( https://github.com/Altinity/clickhouse-grafana/issues/678