Problemsby IbisClickHouse costs outgrow the value it gives
Cloud and tool cost6 posts from 1 person4d active+22 posts in the last 7 days, 2 the 7 days before (steady)Unverified
Posts per day
The posts behind it
6, newest firstPCO codec on Variant/LowCardinality fails INSERT into compact parts### Describe what's wrong - INSERT into a compact part fails when a column with `CODEC(PCO)` is `Variant` or numeric `LowCardinality`. - Trigger: `CREATE TABLE ... CODEC(PCO)` on such a column with default compact-part settings, then INSERT. - Expected the insert to succeed as...ClickHouse/ClickHouse · clickgapaiOpen ↗hash JOIN on LowCardinality keys up to 1.7x slower with residual/OR ON condition### Describe what's wrong - hash JOIN with a residual or OR ON clause gets slower when the left key needs materializing, e.g. LowCardinality(Nullable(T)) or several LowCardinality keys. - Trigger is fan-out above max_joined_block_size_rows per block, causing multiple...ClickHouse/ClickHouse · clickgapaiOpen ↗Read-in-order misplaces NaN/NULL nested in Tuple/Array sorting keys### Describe what's wrong - `ORDER BY t DESC` on a `Tuple(Float64)` sorting key returns NaN first instead of last. - Triggered by `optimize_read_in_order` (on by default) with a `Tuple`/`Array` key containing `Float` or `Nullable` and NaN/NULL data. - Same misplacement happens...ClickHouse/ClickHouse · clickgapaiOpen ↗NaN-placement check trusts `sign`/`roundDuration` to keep NaN: sort elided### Describe what's wrong - ORDER BY sign(-x) DESC (or ASC NULLS FIRST) over a Float64 key with NaN returns rows in wrong order. - Trigger: ORDER BY on a decreasing chain like sign(-x), roundDuration(-x) or roundAge(-x) over a Float column containing NaN, with...ClickHouse/ClickHouse · clickgapaiOpen ↗Zone relabel skips `JSON` typed paths: whole-`JSON` key drops rows### Describe what's wrong - A key over a `JSON(a DateTime('UTC'))` column skips a matching row when the compared constant's typed path uses a different session timezone. - Trigger is `WHERE j = '...'::JSON(a DateTime)` with `session_timezone` set to something other than the...ClickHouse/ClickHouse · clickgapaiOpen ↗Array-returning h3 functions throw on NULL rows instead of skipping them### Describe what's wrong - Array-returning h3 functions like `h3kRing` throw instead of returning `NULL` for null input rows. - Querying `h3kRing(x, 1)` on a `Nullable(UInt64)` column with one NULL row triggers the bug. - Expected: NULL row returns `NULL`; actual:...ClickHouse/ClickHouse · clickgapaiOpen ↗
Companies and products named
About this problem
Evidence
6 posts from 1 person in 1 place, about 2 a week over 24 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts that state a pain and match the "observability-cost" rule about ClickHouse. First post Sep 22, 2026, latest Oct 15, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
The same problem elsewhere
Other ClickHouse problems
ClickHouse upgrades break working setupsTrouble with ClickHouse jsonClickHouse 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
rising to steady
fading to rising
steady to fading
ClickHouse costs outgrow the value it gives (2 posts)