Hello,
I need to change Partition on table in Vertica 5.1.
According to manual in Vertica 6, it can be done like:
alter table event PARTITION BY ((((date_part('year', event at timezone 'UTC') * 10000) + (date_part('month', event at timezone 'UTC') * 100)) + date_part('day', event at timezone 'UTC'))) REORGANIZE;
but I'm getting an error:
Error: [Vertica][VJDBC](100081) ERROR: syntax error at or near "PARTITION"
SQLState: HY000
ErrorCode: 100081
Dors Vertica 5.1 have different syntax for changing partitions?
thank you for advice
Change PARTITION in Vertica 5.1
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Change PARTITION in Vertica 5.1
I do not believe you could add partitioning on a table after it was created before version 6.