CREATE 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 1: …v1 BUILD DEFERRED REFRESH AUTO ON MANUAL partition by(… ^ Encountered: AUTO Expected 这个需要怎么处理