partition by cannot be used in create table as ...?

jiahe1224

https://drive.google.com/file/d/1JvCew42AGOFfS3V602WVWP1Nx11JQxql/view?usp=share_link

SYNTAX ERROR[4856][42601]

Bryan_H

CREATE TABLE AS SELECT allows segmentation but not partition. You can add partition later with ALTER TABLE x PARTITION BY partition-clause REORGANIZE.

https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/SQLReferenceManual/Statements/CREATETABLE.htm