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