TL;DR


The narrative that "ClickHouse can't do JOINs" is outdated by four years and 50+ merged PRs. From 2022 to 2026, ClickHouse's join subsystem was rebuilt from the ground up, and the evidence is in the commit history.


We analyzed 50+ GitHub pull requests, official ClickHouse changelogs, and release blogs to trace the full evolution of JOIN...