---
title: "Introducing multi-stage distributed query execution in ClickHouse Cloud"
url: https://daily.dev/posts/introducing-multi-stage-distributed-query-execution-in-clickhouse-cloud-ldgxuaqfc
source_url: https://clickhouse.com/blog/multi-stage-distributed-query-execution-clickhouse-cloud
type: article
source: "ClickHouse"
published: 2026-05-27T11:48:12.843Z
updated: 2026-05-27T11:53:41.395Z
tags: ["distributed-systems", "clickhouse"]
reading_time: 16
upvotes: 2
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Introducing multi-stage distributed query execution in ClickHouse Cloud

**[ClickHouse](https://daily.dev/sources/clickhouse)** · 16 min read · 2 upvotes · 0 comments

## Summary

ClickHouse Cloud introduces multi-stage distributed query execution, a new execution model that repartitions intermediate data between query stages using exchange operators (Shuffle, Broadcast, Gather, Scatter). This removes two key bottlenecks in the previous parallel replicas model: every node having to build a full right-side hash table for joins, and high-cardinality aggregations being bottlenecked on a single coordinator. The system uses streaming TCP-based exchanges by default, with a persisted mode writing to shared object storage for fault tolerance. TPC-H SF100 benchmarks on 8 nodes show near-linear scaling for scan-heavy queries (7.4× for Q01) and 2–4.5× speedups for multi-join queries, with a 2.1× total improvement. The feature is currently experimental and available via private preview in ClickHouse Cloud. A cost-based optimizer is planned to further improve plan selection.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://clickhouse.com/blog/multi-stage-distributed-query-execution-clickhouse-cloud>

## Similar posts on daily.dev

- [ClickHouse Cloudにマルチステージ分散クエリ実行を導入](https://daily.dev/posts/clickhouse-cloud--fmltmsx72) · ClickHouse · 0 upvotes · 0 comments
- [TPC-H for less than a cent: ClickHouse Cloud vs. Snowflake, Databricks, BigQuery, and Redshift](https://daily.dev/posts/tpc-h-for-less-than-a-cent-clickhouse-cloud-vs-snowflake-databricks-bigquery-and-redshift-7g58szban) · ClickHouse · 0 upvotes · 0 comments
- [Index sharding in ClickHouse Cloud: Petabyte-scale data needs petabyte-scale indexing](https://daily.dev/posts/index-sharding-in-clickhouse-cloud-petabyte-scale-data-needs-petabyte-scale-indexing-m9incx91i) · ClickHouse · 1 upvotes · 0 comments

---

Tags: [#distributed-systems](https://daily.dev/tags/distributed-systems), [#clickhouse](https://daily.dev/tags/clickhouse)

[View this post on daily.dev](https://daily.dev/posts/introducing-multi-stage-distributed-query-execution-in-clickhouse-cloud-ldgxuaqfc)