Skip to main content
Question

flex table to devide into partitions

  • May 25, 2020
  • 1 reply
  • 4 views

maks
Forum|alt.badge.img+1
  • Participating Frequently

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?

1 reply

sahil_kumar
Forum|alt.badge.img
  • Participating Frequently
  • May 25, 2020

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