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

物化视图创建报错

Asked Feb 28 Modified Jan 1, 0001
Viewed 159
mtmv 2.1

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

edited Jan 1, 0001
5
asked Feb 28
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

image.png
还有这个也不能用

edited Jan 1, 1970
5
answered Feb 28

创建物化视图的时候得指定个 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
Related Questions
Doris 2.1.5 内表 异步物化视图数据问题
1 answers
doris报错被截断 doris版本2.1.6
1 answers
异步物化视图刷新时会锁表吗
1 answers
使用jdbc创建物化视图的时候,报错Encountered: BUILD
1 answers
异步物化视图某一时刻RreshState为fail,对最终数据正确性是否有影响
1 answers
2.1.8 版本 异步物化视图 ALTER MATERIALIZED VIEW 后报错 unknown table ...
4 answers

Terms of service Privacy policy

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