Changing the table distribution policy in Greenplum

posted Apr 28, 2017, 4:17 PM 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