没有做限制，手动set过内存大小，还是一样啊
mysql> set exec_mem_limit = 21475978320;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.task_runs order by CREATE_TIME desc limit 1;
+--------------------------------------+--------------+---------------------+---------------------+--------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
| QUERY_ID | TASK_NAME | CREATE_TIME | FINISH_TIME | STATE | DATABASE | DEFINITION | EXPIRE_TIME | ERROR_CODE | ERROR_MESSAGE | PROGRESS |
+--------------------------------------+--------------+---------------------+---------------------+--------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
| 3e7ae15c-b5e6-11ee-8c5d-b4055dfc9e39 | mv-112163979 | 2024-01-18 17:44:59 | 2024-01-18 17:45:11 | FAILED | ads_hy_guanxing | insert overwrite ads_guanxing_day_org_pro_sptm_sal_ds_view SELECT `ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`tm_product_no`, `ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`partition_day` AS `period_sdate`, sum(`ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`sal_qty`) AS `current_sal_qty`, sum(`ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`sal_amt`) AS `current_sal_amt`, sum(`ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`collect_num`) AS `current_mockdata_num`
FROM `ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`
GROUP BY `ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`tm_product_no`, `ads_hy_guanxing`.`ads_guanxing_day_org_pro_sptm_sal_ds`.`partition_day` | 2024-01-19 17:44:59 | -1 | com.starrocks.sql.common.DmlException: Memory of Query3e7ae15c-b5e6-11ee-8c5d-b4055dfc9e39 exceed limit. Pipeline Backend: 10.250.84.30, fragment: 3e7ae15c-b5e6-11ee-8c5d-b4055dfc9e42 Used: 4295665550, Limit: 4294967296. Mem usage has exceed the limit of single query, You can change the limit by set session variable exec_mem_limit or query_mem_limit. | 100% |
+--------------------------------------+--------------+---------------------+---------------------+--------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
1 row in set (0.01 sec)