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 214
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
doris2.1.11使用外部目录,用catalog的数据创建异步视图,没有数据,需要强制手动刷新才行
1 answers
创建异步物化视图视图后发现无法命中
2 answers
paimon  分区物化视图使用分区上卷创建失败
1 answers

Terms of service Privacy policy

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