how to define a table with more than 1 partition column.
It is said that Vertica supports up to 1024 partitions per table; however, they recommend between 10 and 20 partitions for optimal performance .
but when i define a table with partition by clause having 2 columns i am getting the error .
CREATE TABLE vmart.mytest_table
fiscal_year int not null ,
fiscal_month int not null
)SEGMENTED BY hash(Rslr_Store_Id) ALL NODES KSAFE 1
Partition by HASH (fiscal_year )
Partition by HASH(fiscal_month)
ERROR 4856: Syntax error at or near "Partition" at character 336
LINE 13: Partition by HASH(fiscal_month)
Could you please say how to define partitons in this case