ERROR: can't set the distribution policy when reorganizing a leaf partion of a partitioned table

Products

• VMware Tanzu Greenplum

Issue/Introduction

In GPDB version 6.0~6.7, you will get this error when you reorganize just a leaf table of a partitioned table. 

For example:

gpadmin=# create table test_partition (trans_id int, date text, amount decimal(9,2), region text) distributed by (trans_id) gpadmin-# partition by range(date) 
gpadmin-# (partition p2011 start (date '2011-01-01'::text) end (date '2012-01-01'::text), 
gpadmin(# partition p2012 start (date '2012-01-01'::text) end (date '2013-01-01'::text)); NOTICE: CREATE TABLE will create partition "test_partition_1_prt_p2011" for table "test_partition" NOTICE: CREATE TABLE will create partition "test_partition_1_prt_p2012" for table "test_partition" CREATE TABLE Time: 74.447 ms 

gpadmin=# alter table test_partition_1_prt_p2011 set with (reorganize=true) distributed by (trans_id); 
ERROR: can't set the distribution policy of "test_partition_1_prt_p2011" HINT: Distribution policy can be set for an entire partitioned table, not for one of its leaf parts or an interior branch. Time: 12.080 ms

Environment

Product Version: 6.4

Resolution

This issue has been fixed in GPDB 6.8.