Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
flex table to devide into partitions
Hello, I have flex table mytable. I want to divide the table into partitions by date (there is time field with type Timestamp in the table). I use the following command:
ALTER TABLE mytable
PARTITION BY ((time)::date) GROUP BY (date_trunc('day', (time)::date)) REORGANIZE;
But I get error: ROLLBACK 5371: User defined function not allowed: MapLookup
Why is that?
Tagged:
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Partition by virtual column is not allowed and it gives this error message.
Can you share DDL of your table?