The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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