v.20.8Improvement

Fetch Partitions from Different ZooKeeper Clusters in ClickHouse

Official CH changelog text
Now it's possible to fetch partitions from clusters that use different ZooKeeper: ALTER TABLE table_name FETCH PARTITION partition_expr FROM 'zk-name:/path-in-zookeeper'. It's useful for shipping data to new clusters. #14155 (Amos Bird).
Enabled fetching partitions from clusters that use different ZooKeeper instances using the ALTER TABLE FETCH PARTITION command with a ZooKeeper path specification.

Why it matters

This feature solves the problem of shipping data between clusters that rely on different ZooKeeper setups by allowing partition data to be fetched directly from specified ZooKeeper instances. It facilitates easier data migration and synchronization across distinct ClickHouse clusters.

How to use it

Use the following syntax to fetch a partition from a remote cluster with a different ZooKeeper:

ALTER TABLE table_name FETCH PARTITION partition_expr FROM 'zk-name:/path-in-zookeeper'

Replace table_name with the target table, partition_expr with the partition to fetch, and specify the ZooKeeper cluster and path accordingly.

Related resources

PreviousNext