Distributed ClickHouse: How a Query Becomes a Scatter-Gather Across Shards
How ClickHouse Distributed tables send query pieces to shards, merge results on a coordinator, and fail in ways a single-node MergeTree never will.
3 min read
Engineering at scale
3 articles · 8 min of reading
How ClickHouse Distributed tables send query pieces to shards, merge results on a coordinator, and fail in ways a single-node MergeTree never will.
How ClickHouse's MergeTree family stores data in immutable parts and merges them in the background, which is why inserts are fast and mutations are not.
MergeTree local execution versus elastic warehouses: when you want ClickHouse's latency, and when you want Snowflake/BigQuery's isolation.