ClickHouse legacy setups slow everything down
2 posts from 2 people2d activeFading, +0 this weekunverified
Posts per day
The posts behind it
`group_by_use_nulls` key copy skips AND rewrite: `NOT_FOUND_COLUMN_IN_BLOCK`
...`group_by_use_nulls = 1` and a key the AND rewrite changes fail; they worked on 26.3. Workaround: `optimize_redundant_comparisons = 0`. ### Does it reproduce on most recent release? Confirmed on `master`; not checked on a release. ### How to reproduce [▶ Run on ClickHouse...
Rewrite `replxx`
Replxx is a very good library (compared to `readline`, `libedit`, and `linenoise`). It allowed us to implement proper syntax highlighting and autocomplete. It originated from ArangoDB, which is currently abandoned. Over time, we accumulated a very large number of patches....
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 24 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub.
Frustration Frustration 3 of 3· Seen on GitHub issues
How it was grouped
Posts that state a pain and match the "tech-debt" rule about ClickHouse. First post Oct 22, 2026, latest Nov 14, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
The same problem elsewhere
Legacy systems and tech debt slow everything down
8 posts from 8 people on Reddit, GitHub issues, Hacker News.
GitHub legacy setups slow everything down
2 posts from 2 people on GitHub issues. Unverified.
Apache Superset legacy setups slow everything down
2 posts from 2 people on GitHub issues. Unverified.
Other ClickHouse problems
ClickHouse upgrades break working setups
37 posts from 21 people on GitHub issues.
ClickHouse users keep filing bugs
Top post: "Tighten seccomp policy for optional kernel interfaces", one of 22 posts from 10 people on GitHub issues.
Trouble with ClickHouse column
Top post: "Top-K reads with a `minmax` index on the sort column: read the granules with the best bounds first", one of 17 posts from 10 people on GitHub issues.
ClickHouse costs outgrow the value it gives
11 posts from 3 people on GitHub issues.
Experiments on ClickHouse are hard to reproduce and track
11 posts from 2 people on GitHub issues.
Trouble with ClickHouse table
Top post: "`SYSTEM RESTORE REPLICA` on a second replica over-bumps the table `metadata` znode version; every later", one of 9 posts from 5 people on GitHub issues.
Trouble with ClickHouse join
Top post: "JOIN runtime filter pruning drops rows for CAST(UInt8 AS Bool) probe key", one of 7 posts from 5 people on GitHub issues.
Trouble with ClickHouse read
Top post: "Bucketed `Map` serialization loses the key order in Compact parts written with", one of 6 posts from 6 people on GitHub issues.
ClickHouse error messages are cryptic
6 posts from 3 people on GitHub issues.
Trouble with ClickHouse tables
Top post: "Paimon: resolve columns by field id, so tables with renamed or re-added columns are readable", one of 5 posts from 4 people on GitHub issues.
Trouble with ClickHouse default
Top post: "`merge('', regexp)` still resolves against the shard's default database", one of 5 posts from 4 people on GitHub issues.
Trouble with ClickHouse index
Top post: "Text index: exact hasPhrase on Array columns with a position increment gap", one of 4 posts from 2 people on GitHub issues.
History