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