How do you merge partitions in Greenplum?
Go to Solution.
There is no DDL to merge partitions.
Let's say you want to merge partiton (10-20) and (20-30), one workaround is :
1. Create a table A
2. Insert into A from the 2 partitions.
3. Drop 2 partitions
4. Add one partition (10-30)
5. Exchange partition (10-30) with the table A