Distributed Clause

Description

Used to declare the Greenplum Database distribution policy for the table.

Click here to navigate to the Greenplum documentation page for this syntax.

The Distributed clause is not applicable in Snowflake

Grammar Syntax

[ DISTRIBUTED BY (column [opclass], [ ... ] ) 
| DISTRIBUTED RANDOMLY 
| DISTRIBUTED REPLICATED ]

Sample Source Patterns

Greenplum

CREATE TEMPORARY TABLE temp_CINS (
   alt_cd6 varchar(30) NULL,
)
DISTRIBUTED BY (alt_cd6);


CREATE TABLE table1 (
	col1 varchar(30)
)
DISTRIBUTED RANDOMLY;

CREATE TABLE table2 (
	col1 varchar(30)
)
DISTRIBUTED REPLICATED;

Snowflake

CREATE TEMPORARY TABLE PUBLIC.temp_CINS (
	alt_cd6 varchar(30) NULL
)
-- ** MSC-WARNING - MSC-GP0000 - DISTRIBUTED CLAUSE NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--DISTRIBUTED BY (alt_cd6)
                        ;

CREATE TABLE PUBLIC.table1 (
	col1 varchar(30)
)
-- ** MSC-WARNING - MSC-GP0000 - DISTRIBUTED CLAUSE NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--DISTRIBUTED RANDOMLY
                    ;

CREATE TABLE PUBLIC.table2 (
	col1 varchar(30)
)
-- ** MSC-WARNING - MSC-GP0000 - DISTRIBUTED CLAUSE NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--DISTRIBUTED REPLICATED
                      ;

Related EWIs

1. MSC-GP0000: Data storage is automatically handled by Snowflake