异步物化视图执行超过内存限制,如何修改呢

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,找不到这个 麻烦问下 这个默认的物化视图资源池怎么改呢?

单独执行SHOW RESOURCE GROUP就可以看到这个资源组了。
default_mv_wg 资源组是系统资源组,得改BE的动态参数。
参数分别是
default_mv_resource_group_cpu_limit
default_mv_resource_group_memory_limit
default_mv_resource_group_concurrency_limit
default_mv_resource_group_spill_mem_limit_threshold
更改命令如下
curl -XPOST http://BE_IP:BE_HTTP_PORT/api/update_config?default_mv_resource_group_memory_limit=0.4
这个是把内存调整到整体的40%
官网里面有写