mpippins
1 Nickel

Merge partitions?

Jump to solution

How do you merge partitions in Greenplum?

Tags (3)
0 Kudos
1 Reply
Highlighted
ViadeaZhu
1 Nickel

Re: Merge partitions?

Jump to solution

Hello,

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

Thanks,

Viadea

0 Kudos