flex table to devide into partitions

maksmaks Community Edition User

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

  • sahil_kumarsahil_kumar Vertica Employee Employee

    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