Doris 4.0.4 物化视图异常问题反馈

Viewed 11

1、Doris4.0.2升级到Doris4.0.4,物化视图 SHOW CREATE MATERIALIZED 语句报错(查询没问题)
ba755a39b681e3ac16e53d85a9e44f05.png

2、Doris4.0.4 有数据后建不了视图了,报错另一张表没有分区,把数据truncate清空后又可以创建了,然后再导入数据进去刷新,视图也有数据了。

报错信息:
[HY000][1105] errCode = 2, detailMessage = Unable to find a suitable base table for partitioning, the fail reason is partition column is not in group by or window partition by, [related base table is not partition table, the table is main_push_store_product, Unsupported plan operate in track partition, the invalid plan node is LogicalGenerate, column to check use invalid implicit expression, invalid expression is cast(period_sdate#0 as DATETIMEV2(0))]

0 Answers