We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


flex table to devide into partitions — Vertica Forum

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