Changing the table distribution policy in Greenplum

Post date: May 02, 2013 2:4:27 PM

ALTER TABLE sales SET DISTRIBUTED BY (customer_id); 

ALTER TABLE sales SET DISTRIBUTED RANDOMLY;

re-distribution table data after changing the distribution policy.

ALTER TABLE sales SET WITH (REORGANIZE=TRUE);