V2.1.6创建物化视图报错

Viewed 49
mtmv 2.1

问题描述

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

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

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

演示步骤

image.png

2 Answers

执行这个再测试看看

set GLOBAL  enable_fallback_to_original_planner=FALSE;

set GLOBAL enable_nereids_planner=TRUE;
黄海军@SelectDB5128

image.png

1
Related Questions
【2.1.6】异步物化视图临时分区
1 answers
Doris2.0物化视图使用疑问
1 answers
selectdb 从哪个版本开始支持 异步物化视图？
1 answers
异步物化视图刷新失败，提示“errCode = 2, detailMessage = (10.56.88.77)[CANCELLED]failed to open DeltaWriter 90250840: not enough streams 1/2”
2 answers
异步物化视图，storage_medium 属性设置后未生效
1 answers
物化视图刷新任务失败，失败原因提示“errCode = 2, detailMessage = (10.74.107.1)[CANCELLED]sync filter size meet error”
1 answers