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:

Answers

  • Partition by virtual column is not allowed and it gives this error message.
    Can you share DDL of your table?

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.