v.20.3New Feature
Added MOVE PARTITION Command for ALTER TABLE
AddedMOVE PARTITIONcommand forALTER TABLE#4729 #6168 (Guillaume Tassery)
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 theALTER 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;