为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述
【背景】做过哪些操作?
【业务影响】
【是否存算分离】
【StarRocks版本】2.5.12
【集群规模】例如:3fe(1 follower+2observer)+5be(fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
创建物化视图时出现resolve partition column failed
语句如下
CREATE MATERIALIZED VIEW test.lyh_test_view
(user_id
, event
, time
, dt
, flag
)
PARTITION BY (dt
)
DISTRIBUTED BY HASH(event
)
REFRESH ASYNC EVERY(INTERVAL 5 MINUTE)
PROPERTIES (
“replication_num” = “3”,
“storage_medium” = “HDD”
) AS
SELECT t1
.user_id
, t1
.event
, t1
.time
, t1
.dt
, last_value(t1
.a2
) OVER (PARTITION BY t1
.user_id
ORDER BY t1
.time
ASC ) AS flag
FROM (SELECT event_p1_test
.user_id
, event_p1_test
.event
, event_p1_test
.time
, event_p1_test
.dt
, if(((unix_timestamp(event_p1_test
.time
)) - (unix_timestamp(lag(event_p1_test
.time
, 1, NULL) OVER (PARTITION BY event_p1_test
.user_id
ORDER BY event_p1_test
.time
ASC )))) <= 5, NULL, uuid()) AS a2
FROM test
.event_p1_test
WHERE event_p1_test
.event
IN (’$AppStart’, ‘element_expose’)) t1;