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);