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 195
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
paimon外表catalog没法创建异步物化视图 Only support creating asynchronous materialized views in internal catalog
1 answers
什么时候doris出一个物化视图编排的管理工具
2 answers
物化视图创建失败,unable to find a suitable base table for partition
1 answers
异步物化视图不能透明改写
2 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 中文技术论坛.