为了更快的定位您的问题,请提供以下信息,谢谢
【详述】
用下面的语句创建物化视图:
CREATE MATERIALIZED VIEW mv_table
DISTRIBUTED BY HASH(ar, ba, mid)
REFRESH ASYNC
PARTITION BY date_trunc(“day”, dt)
AS
SELECT
T.common->‘ar’ AS ar,
T.common->‘ba’ AS ba,
T.common->‘mid’ AS mid,
T. dt,
AR.value->‘params’ AS params,
AR.value->‘ts’ AS ts
FROM
tb_table AS T,
LATERAL JSON_EACH(action_list) AR
WHERE
T.common IS NOT NULL AND T.action_list IS NOT NULL
;
结果:
[Err] 1064 - Getting analyzing error at line 4, column 13. Detail message: Resolve partition column failed:null.
【背景】创建物化视图
【业务影响】
【是否存算分离】是
【StarRocks版本】例如:3.2