Clickhouse 24.08 JSON Support

[patrizok]

Environment

• clickhouse-connect version:0.7.19
• Python version: 3.12.5
• Operating system: Docker - Ubuntu
• ClickHouse Server version: 24.8.4.13

Code example

import clickhouse_connect

client = clickhouse_connect.get_client(host='x.x.x.x', username='xxx', password='xxx')

result = client.query('''SELECT
    json.type.name,
    count() AS count
FROM events
GROUP BY ALL
ORDER BY count DESC
LIMIT 10
''')
res = result.result_rows
pass

Problem:

clickhouse_connect does not support new features released 24.8 You can get detailed information from here: https://clickhouse.com/blog/clickhouse-release-24-08

Thanks