Changing the table distribution policy in Greenplum

posted May 2, 2013, 7:04 AM by Sachchida Ojha
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);
Comments