skip to Main Content

JSON array to rows in ClickHouse

What query would transpose the following JSON value to multiple rows. Examples with nested JSON objects are sparse. [{"a":{"b":"val", "c":1}},{"a":{"b":"val", "c":4}}] Tried combinations of JSONExtract but having difficulty with nested object

VIEW QUESTION

Clickhouse cannot login in 8123 – Ubuntu

have a problem with authorization in clickhouse, my os Ubuntu 18.04. I can connect with clickhouse-client. clickhouse-client --user=dev --password=dev123 <jemalloc>: Number of CPUs detected is not deterministic. Per-CPU arena disabled. ClickHouse client version 22.8.5.29 (official build). Connecting to localhost:9000 as…

VIEW QUESTION

Azure – Clickhouse server can't connect to Zookeeper

I am running Clickhouse server on a Azure VM and trying to create a table using ReplicatedMergeTree engine (following this guide: https://medium.com/@merticariug/distributed-clickhouse-configuration-d412c211687c). I have zookeeper running on another Azure VM in the same subnet. CREATE TABLE shard.test ( id Int64,…

VIEW QUESTION
Back To Top
Search