mysql> select * from default_catalog.information_schema.task_runs where task_name=‘mv-10576’ order by CREATE_TIME\G
*************************** 1. row ***************************
QUERY_ID: a28aeb45-f70e-11ee-9cab-063109a842f6
TASK_NAME: mv-10576
CREATE_TIME: 2024-04-10 15:47:52
FINISH_TIME: 2024-04-10 15:49:36
STATE: FAILED
DATABASE: live
DEFINITION: insert overwrite view_name_2
SELECT paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
.stat_date
, paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
.event_kv_jsonb
[‘fristGrade’] AS event_kv_jsonb['fristGrade']
, bitmap_union(bitmap_hash(paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
.visitor_id
)) AS bitmap_union(bitmap_hash(visitor_id))
, count(paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
.visitor_id
) AS count(visitor_id)
FROM paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
GROUP BY paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
.stat_date
, paimon
.live
.paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060
.event_kv_jsonb
[‘fristGrade’]
EXPIRE_TIME: 2024-04-11 15:47:52
ERROR_CODE: -1
ERROR_MESSAGE: Refresh materialized view view_name_2 failed after retrying 1 times, error-msg : Memory of default_mv_wg exceed limit. Pipeline Backend: kube-starrocks-cn-47.kube-starrocks-cn-search.starrocks.svc.cluster.local, fragment: a28aeb45-f70e-11ee-9cab-063109a842fa Used: 20038976808, Limit: 20038599415. Mem usage has exceed the limit of the resource group [default_mv_wg]. You can change the limit by modifying [mem_limit] of this group
PROGRESS: 100%
EXTRA_MESSAGE: {“forceRefresh”:false,“mvPartitionsToRefresh”:[“p20240326_20240327”,“p20240325_20240326”],“refBasePartitionsToRefreshMap”:{“paimon_dwd_aplus_pub_log_event_expo_1d_tenant1_project47532305069060”:[“p20240325”,“p20240326”]},“basePartitionsToRefreshMap”:{}}
使用SHOW RESOURCE GROUP default_mv_wg,找不到这个 麻烦问下 这个默认的物化视图资源池怎么改呢?