paimon  分区物化视图使用分区上卷创建失败

Viewed 5

paimon表以天粒度dt分区。
创建物化视图时使用分区上卷到以月分区

CREATE MATERIALIZED VIEW partition_mv
BUILD IMMEDIATE REFRESH AUTO ON SCHEDULE EVERY 1 DAY
DUPLICATE KEY(prod_ops_gen_device_gen_device_id)
PARTITION BY (date_trunc(`dt`, 'month'))
DISTRIBUTED BY RANDOM BUCKETS 10
AS xxx

报错:

errCode = 2, detailMessage = date_trunc only support range partition

现在是不支持吗

0 Answers