Data and AI struggles

ClickHouse error messages are cryptic

Dev tooling4 posts from 2 people3d active+00 posts in the last 7 days, 0 the 7 days before (fading)

Posts per day

Posts per day4 posts, Sep 23 to Oct 21

The posts behind it

4, newest first
GitHub issuesOct 6 2 weeks ago`FETCH PARTITION` of a patch partition applies another table's updates### Describe what's wrong - `FETCH PARTITION ID 'patch-...'` from another table plus `ATTACH PARTITION ID` is accepted and the fetched patch rewrites rows of the destination.** - `t_dst` row `id = 1` holds `v = 100`; after fetching and attaching `t_src`'s patch for `UPDATE t_src...ClickHouse/ClickHouse · clickgapaiOpen ↗GitHub issuesOct 5 2 weeks agoParallel replicas return a wrong count() for a primary-key range predicate: the exact-count optimization's granules are dropped from the result**Company or project name:** - **Describe what's wrong** `SELECT count() FROM t WHERE ` with task-based parallel replicas returns only the rows of the granules the predicate matches partially, silently dropping the count of every granule it matches fully, when no local-replica...ClickHouse/ClickHouse · zlareb1Open ↗GitHub issuesOct 5 2 weeks agoPlain MergeTree silently and permanently loses a column's data when a partition is detached before RENAME COLUMN and re-attached after it### Describe what's wrong On a plain `MergeTree` table, a partition detached before an `ALTER TABLE ... RENAME COLUMN` and re-attached after it silently loses the renamed column's data: `ATTACH PARTITION` succeeds with no error and the renamed column reads its default for every...ClickHouse/ClickHouse · zlareb1Open ↗GitHub issuesSep 23 4 weeks agoText index on `FixedString` with `String`-returning preprocessor drops all rows### Describe what's wrong - Queries with `equals`, `IN`, `has`, `hasAny` and `mapContainsKey` prune every granule and return nothing. - Triggered by a text index on a `FixedString(N)` column with a preprocessor like `CAST(s, 'String')` and a term-preserving tokenizer. - Expected...ClickHouse/ClickHouse · clickgapaiOpen ↗

Companies and products named

About this problem

Evidence

4 posts from 2 people in 1 place, about 2 a week over 14 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub, Text.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts that state a pain and match the "errors-unclear" rule about ClickHouse. First post Sep 23, 2026, latest Oct 6, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

History

MomentumOct 13, 2026steady to fading
MomentumOct 12, 2026rising to steady
AddedOct 9, 2026ClickHouse error messages are cryptic (4 posts)