The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Partition by TIMESTAMPTZ field. How?
Hello, I'm trying to re-partition some table using week number counting from some day: my_fact table contains a field called time_stamp of type TIMESTAMPTZ Unfortunately, re-partition doesn't work, and I'm getting the error: MyDB=> ALTER TABLE my_fact PARTITION BY MOD(TIMESTAMPDIFF('day', time_stamp::TIMESTAMP, TIMESTAMP '2013-09-23'), 156) REORGANIZE; NOTICE 4954: The new partitioning scheme will produce 12 partitions ROLLBACK 2552: Cannot use meta function or non-deterministic function in PARTITION BY expression What cast of time_stamp field can be done to make it deterministic? Thanks! Michael