v.21.6New Feature

Added ALTER TABLE ... FETCH PART for Single Part Retrieval

Official CH changelog text
Added ALTER TABLE ... FETCH PART ... query. It's similar to FETCH PARTITION, but fetches only one part. #22706 (turbo jason).
Added the ALTER TABLE ... FETCH PART ... query to ClickHouse, allowing users to fetch a single part from a replicated table.

Why it matters

This feature provides a more granular control over data replication by enabling the fetching of a specific data part instead of entire partitions. It helps optimize bandwidth and speed when only one part needs to be synchronized or repaired.

How to use it

Use the ALTER TABLE <table_name> FETCH PART <part_name> query to fetch a single part from a replica. This can be executed on replicated tables to selectively retrieve the specified part.

Related resources

PreviousNext