v.20.3New Feature

Added MOVE PARTITION Command for ALTER TABLE

Added MOVE PARTITION command for ALTER TABLE #4729 #6168 (Guillaume Tassery)
Introduced the MOVE PARTITION command as part of the ALTER TABLE statement in ClickHouse.

Why it matters

This feature enables users to move individual partitions from one table to another within the same database or cluster, simplifying partition management and facilitating more flexible data organization and maintenance.

How to use it

Use the ALTER TABLE statement with the MOVE PARTITION clause to specify the partition to move and the target table. For example:

ALTER TABLE source_table MOVE PARTITION partition_expr TO TABLE target_table;