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

V2.1.6创建物化视图报错

Asked Mar 6 Modified Jan 1, 0001
Viewed 46
mtmv 2.1

问题描述

按照官网样例创建同步/异步物化视图,都提示同样的错误
image.png

[S1009] Statement.executeQuery() cannot issue statements that do not produce result sets.

SET enable_nereids_planner = true;优化器开启与否都是这样的错误。

演示步骤

image.png

edited Jan 1, 0001
1
asked Mar 6
2 Answers

执行这个再测试看看

set GLOBAL  enable_fallback_to_original_planner=FALSE;

set GLOBAL enable_nereids_planner=TRUE;
edited Jan 1, 1970
黄海军@SelectDB4948
answered Mar 7

image.png

edited Jan 1, 1970
1
answered Mar 7
Related Questions
异步物化视图刷新失败,提示“errCode = 2, detailMessage = (10.56.88.77)[CANCELLED]failed to open DeltaWriter 90250840: not enough streams 1/2”
异步物化视图,storage_medium 属性设置后未生效
1 answers
物化视图刷新任务失败,失败原因提示“errCode = 2, detailMessage = (10.74.107.1)[CANCELLED]sync filter size meet error”
1 answers
Doris 2.1.5 内表 异步物化视图数据问题
1 answers
doris报错被截断 doris版本2.1.6
1 answers
使用jdbc创建物化视图的时候,报错Encountered: BUILD
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 中文技术论坛.