Apache Doris 中文技术论坛
Questions Tags Users Badges

【已解决】Doris 2.1.0 创建异步物化视图,提示 Unable to find a suitable base table for partitioning

Asked Mar 15, 2024 Modified Mar 25, 2024
Viewed 181
mtmv 2.1

基础表
动态分区,分区字段:time_stamp,格式:%Y-%m-%d %H:%i:%s

物化视图
异步物化视图,按天分区,分区字段:to_date(time_stamp)

image.png

edited Mar 25, 2024
____7
asked Mar 15, 2024
2 Answers

可以看下这个 https://ask.selectdb.com/questions/D138/yi-jie-jue-2-1-0-ban-ben-yi-bu-wu-hua-shi-tu-shi-yong-fen-qu-shi-bai 同类问题,应该是有一些约束没有满足,检查一下基表的建表语句。

edited Jan 1, 1970
滴滴哒哒299
answered Mar 15, 2024

后续会支持基表的分区字段允许null的情况

edited Jan 1, 1970
zhangdong281
answered Mar 25, 2024
Related Questions
异步物化视图刷新失败,提示“errCode = 2, detailMessage = (10.56.88.77)[CANCELLED]failed to open DeltaWriter 90250840: not enough streams 1/2”
异步物化视图,storage_medium 属性设置后未生效
1 answers
物化视图刷新任务失败,失败原因提示“errCode = 2, detailMessage = (10.74.107.1)[CANCELLED]sync filter size meet error”
1 answers
Doris 2.1.5 内表 异步物化视图数据问题
1 answers
doris报错被截断 doris版本2.1.6
1 answers
使用jdbc创建物化视图的时候,报错Encountered: BUILD
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.