Problemsby IbisTrouble with ClickHouse join
Databases4 posts from 3 people3d active+11 post in the last 7 days, 1 the 7 days before (steady)
Posts per day
The posts behind it
4, newest first`*Cluster` workers now ignore automatic mode: MV JOIN on forwarded INSERT fails### Describe what's wrong - With `automatic_parallel_replicas_mode = 1`, an INSERT SELECT that goes through a cluster table function now throws LOGICAL_ERROR if the target has an MV that JOINs a MergeTree table.** - Error: the statement below. - Trigger:...ClickHouse/ClickHouse · clickgapai1 reactionsOpen ↗Explicit grace_hash now spills at max_bytes_ratio_before_external_join = 0.5 although the build side fits in memory: TPC-H Q9 56% slower since #119335### Company or project name ClickHouse (internal nightly benchmark: TPC-H SF100 over Iceberg) ### Describe the situation After #117356 (re-landed in #119335), `grace_hash` spills on `max_bytes_before_external_join` / `max_bytes_ratio_before_external_join` instead of...ClickHouse/ClickHouse · alexbakharew1 repliesOpen ↗ARRAY JOIN in an IN subquery splits the GROUP BY key: wrong ROLLUP row### Describe what's wrong - A grouping key containing an `IN` subquery with `ARRAY JOIN` is treated as two different expressions. - Triggered by `GROUP BY ... WITH ROLLUP` (also `CUBE`, `GROUPING SETS`, `TOTALS`) on such a key, with default settings. - The super-aggregate row...ClickHouse/ClickHouse · clickgapaiOpen ↗Analyzer: UNKNOWN_IDENTIFIER when alias resolution fails and analyzer_compatibility_join_using_top_level_identifier=1### Company or project name _No response_ ### Describe what's wrong Query fails ### Does it reproduce on the most recent release? Yes ### How to reproduce https://fiddle.clickhouse.com/b2e6cc5e-ca13-4946-be77-0b8ce95a1a4e ### Expected behavior _No response_ ### Error message...ClickHouse/ClickHouse · novikdOpen ↗
Companies and products named
About this problem
Evidence
4 posts from 3 people in 1 place, about 1 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 about ClickHouse with no known issue, sharing the word "join". First post Sep 22, 2026, latest Oct 15, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other ClickHouse problems
ClickHouse upgrades break working setupsTrouble with ClickHouse jsonClickHouse 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 nameTrouble with ClickHouse readClickHouse error messages are crypticTrouble with ClickHouse constantTrouble with ClickHouse slower
History
rising to steady
Trouble with ClickHouse join (4 posts)