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 189
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
什么时候doris出一个物化视图编排的管理工具
物化视图创建失败,unable to find a suitable base table for partition
异步物化视图不能透明改写
2 answers
3.1版本创建paimon的异步物化视图,按分区刷新不行
1 answers
Doris2.0物化视图使用疑问
1 answers
【2.1.6】异步物化视图临时分区
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 中文技术论坛.