使用官方文档上的 demo 创建物化视图报错https://doris.apache.org/zh-CN/docs/query-acceleration/async-materialized-view/#%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9CREATE MATERIALIZED VIEW mv1
BUILD DEFERRED REFRESH AUTO ON MANUAL
partition by(l_shipdate)
DISTRIBUTED BY RANDOM BUCKETS 2
PROPERTIES ('replication_num' = '1')
AS
select l_shipdate, o_orderdate, l_partkey, l_suppkey, sum(o_totalprice) as sum_total
from lineitem
left join orders on lineitem.l_orderkey = orders.o_orderkey and l_shipdate = o_orderdate
group by
l_shipdate,
o_orderdate,
l_partkey,
l_suppkey;
Execution failed: Error 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
