The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Cannot use meta function or non-deterministic function in PARTITION BY expression

Hi all,

 

I want to create table, partitioned by days of month. I've tried alter table MY_TABLE_NAME partition by extract(DAY from starttime)::INT reorganize; but had ROLLBACK 2552:  Cannot use meta function or non-deterministic function in PARTITION BY expression. What is the problem? Thanks!
 

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.