创建异步物化视图报错

Viewed 73

Version : doris-2.1.4-rc02

报错信息:

Execution failed: Error Failed to execute sql: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 2: BUILD IMMEDIATE REFRESH AUTO ON SCHEDULE EVERY 1 hour ^ Encountered: BUILD Expected

创建语句:

CREATE MATERIALIZED VIEW game_catagory_type_view
BUILD IMMEDIATE REFRESH AUTO ON SCHEDULE EVERY 1 hour
DISTRIBUTED BY RANDOM BUCKETS 1
PROPERTIES ('replication_num' = '1')
AS
select game_category_id, game_type_id, category.name as category_name, category.`key` as category_key, types.name as types_name, types.`key` as types_key from (select game_category_id, game_type_id from games
group by game_category_id, game_type_id) AS g
inner join game_categories category on category.id = g.game_category_id
inner join game_types types on g.game_type_id = types.id
order by game_category_id
2 Answers

嗯,webui
刚刚用命令行试了一下,可以正常创建

你是在什么工具上创建的物化视图?webui吗