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

物化视图创建报错

Asked Feb 28, 2025 Modified Jan 1, 0001
Viewed 180
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
服务器如何配置才比较合理?
1 answers
Doris4.0.2版本,集群部署模式3台主机,不稳定,经常报错。insert报failed to write enough replicas 0/1 for tablet,select查询也报错
1 answers
doris2.1.11使用外部目录,用catalog的数据创建异步视图,没有数据,需要强制手动刷新才行
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 中文技术论坛.