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

物化视图创建报错

Asked Feb 28, 2025 Modified Jan 1, 0001
Viewed 240
mtmv 2.1

image.png
去掉字段定义可以成功,但是我看官方文档上是支持定义字段的

edited Jan 1, 0001
5
asked Feb 28, 2025
3 Answers

https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-statements/table-and-view/async-materialized-view/CREATE-ASYNC-MATERIALIZED-VIEW?_highlight=create&_highlight=async 参考这个语法文档,仅支持定义column name和comment

edited Jan 1, 1970
zhangdong281
answered Feb 28, 2025

image.png
还有这个也不能用

edited Jan 1, 1970
5
answered Feb 28, 2025

创建物化视图的时候得指定个 enable_nondeterministic_function 物化视图定义 SQL 是否允许包含 nondeterministic 函数,比如 current_date(), now(), random() 等,如果 是 true, 允许包含,否则不允许包含,默认不允许包含。

https://doris.apache.org/zh-CN/docs/sql-manual/sql-statements/table-and-view/async-materialized-view/CREATE-ASYNC-MATERIALIZED-VIEW/

edited Jan 1, 1970
seawinde116
answered Feb 28, 2025
Related Questions
使用doris物化视图做数仓分层,哪种策略好
1 answers
mysqldump导出库的表结构会报物化视图不支持的问题,怎么解决
1 answers
在doris 3.1.4 版本通过pycharm64登录,建异步物化视图报错,[S1009] Statement,executeQuery( cannot issue statements that do not produce result sets.
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 中文技术论坛.