创建物化视图失败

Viewed 31
2.1

版本2.1.4
基表

CREATE TABLE `t1` (
  `k1` LARGEINT NOT NULL,
  `k2` DATE NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
DISTRIBUTED BY RANDOM BUCKETS 2

物化视图

CREATE MATERIALIZED VIEW mv1
BUILD DEFERRED REFRESH AUTO ON MANUAL
partition by(`k2`)
DISTRIBUTED BY RANDOM BUCKETS 2
PROPERTIES (
'replication_num' = '1',
'partition_sync_limit'='1',
'partition_sync_time_unit'='DAY'
)
AS
SELECT * FROM t1;

错误信息

Failed to execute sql: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 2:
    BUILD DEFERRED REFRESH AUTO ON MANUAL
    ^
Encountered: BUILD
Expected
wangdi29
1 Answers

应该是没开启新优化器导致的：

查看是否开启新优化器：show variables like "experimental_enable_nereids_planner";

全局打开新优化器：set global experimental_enable_nereids_planner = true;

阿渊@SelectDB6385