【已解决】helm 安装 2.1.1 创建物化视图报错

Viewed 76

使用官方文档上的 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

1 Answers

这里图片看不到,可以加微信Faith_xzc来看看,我会把最新的状态同步到论坛
【问题状态】已处理
【问题处理】开源版本webui的问题,这里已经不维护了。
可以考虑使用manager中的webui(需要selectdb版本,free download);
或者直接在clietn端执行。