Company
Date Published
Author
Dale McDiarmid
Word count
1974
Language
English
Hacker News points
None

Summary

The new version 2.0 of the Grafana ClickHouse plugin offers several significant improvements, including a major change in query parsing that should help resolve common issues with ad-hoc filters. The plugin now supports using HTTP as the transport protocol and enhanced support for ClickHouse data types, such as JSON. Additionally, the plugin has been rewritten to use the `additional_table_filters` feature, which allows any filter to be sent with a query as part of the SETTINGS, making it easier to inject filters into queries. The plugin also adds support for rendering JSON columns in charts and improves handling of ClickHouse types within the plugin. Changes have also been made to variables, including the use of `__conditionalAll` to optimize IN conditions. However, this release includes some breaking changes, such as the removal of the AST parser, which may require users to manually optimize certain queries or upgrade their ClickHouse version.