The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Not able to create partitions
Hi All, Have an integer field in my table which contains the epoch. I want to partition the table based on this time. I am trying to include both year and month in the partition identifier using : PARTITION BY EXTRACT(year FROM TO_TIMESTAMP(event_time))*100 + EXTRACT(month FROM TO_TIMESTAMP(event_time)); Vertica gives me an error saying ERROR 2552: Cannot use meta function or non-deterministic function in PARTITION BY expression Aren't TO_TIMESTAMP and EXTRACT both immutable functions ? Cheers, RAvi