Trouble with ClickHouse json
Databases3 posts from 1 person2d active+22 posts in the last 7 days, 0 the 7 days before (rising)Unverified
Posts per day
The posts behind it
3, newest first`json.^a` throws `BAD_ARGUMENTS`: sub-object type inherits root `SKIP` rules### Describe what's wrong - Reading a sub-object (`json.^p`) or combined (`json.@p`) subcolumn of a valid JSON column fails. - Trigger: a `JSON` column with `SKIP`/`SKIP REGEXP` whose rule matches a typed path once prefix is stripped. - Expected the subcolumn to read normally;...ClickHouse/ClickHouse · clickgapaiOpen ↗RowBinary `JSON(SKIP p)` insert drops `p_1` and keeps `p.*`: no `.` boundary### Describe what's wrong - Binary `JSON` input applies `SKIP` paths as bare string prefixes, so stored data differs from `JSONEachRow` inserts of the same document. - Trigger: `RowBinary` insert with default `input_format_binary_read_json_as_string=0` into `JSON(SKIP path, SKIP...ClickHouse/ClickHouse · clickgapaiOpen ↗Hashing a deeply nested `Dynamic`/`JSON` value crashes the server with SIGSEGV### Describe what's wrong - `sipHash64`, `cityHash64`, `xxHash64` and `murmurHash3_64` over a deeply nested `Dynamic`/`JSON` value exhaust the stack and crash the server. - Trigger: hash a `Dynamic` value with thousands of nested `Object` levels, e.g. built via...ClickHouse/ClickHouse · clickgapaiOpen ↗
Companies and products named
About this problem
Evidence
3 posts from 1 person in 1 place, about 2 a week over 11 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts about ClickHouse with no known issue, sharing the word "json". First post Oct 5, 2026, latest Oct 15, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other ClickHouse problems
ClickHouse upgrades break working setupsClickHouse costs outgrow the value it givesClickHouse users keep filing bugsTrouble with ClickHouse columnTrouble with ClickHouse rowsExperiments on ClickHouse are hard to reproduce and trackTrouble with ClickHouse joinTrouble with ClickHouse nameTrouble with ClickHouse readClickHouse error messages are crypticTrouble with ClickHouse constantTrouble with ClickHouse slower
History
steady to rising
Trouble with ClickHouse json (3 posts)