Change PARTITION in Vertica 5.1

Moderator: NorbertKrupa

Post Reply
Duje
Newbie
Newbie
Posts: 7
Joined: Thu Aug 09, 2012 9:51 am

Change PARTITION in Vertica 5.1

Post by Duje » Fri Nov 30, 2012 9:42 am

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

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Change PARTITION in Vertica 5.1

Post by jpcavanaugh » Fri Nov 30, 2012 1:30 pm

I do not believe you could add partitioning on a table after it was created before version 6.

Post Reply

Return to “Vertica Database Development”