Can’t DISTRIBUTE BY in psql GreenPlum

I am trying to create a table on a RHEL5 machine running GreenPlum (Postgres) server.

The table I am trying to create needs to have a “DISTRIBUTE BY” clause with a few of the columns as its predicate.

Without the “distribute by” the whole command works well creating the table, but when I add it I get the following syntax error:

ERROR: syntax error at or near “DISTRIBUTED”

I looked at this post (DISTRIBUTE BY notices in Greenplum) as well but could not find a solution.

The query structure is:

Create table (columns) DISTRIBUTED BY (columns);


Source: syntax

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.