Query pool memory exceed error

[user9]

Starrocks version:3.5.4

部署模式：hdfs存算分离模式

问题场景：通过hive catalog 执行语句

SELECT
	a.pid，b.N_TD_VB_XXXXXXXFANGSUM3
from(
	select
		pid 
	from
		dw.XXXXXXX_yx_data 
	)a
left join 
(
	select
		entryid，max(
					case when field_name = ‘XXXXXXXFANGSUM3’ then field_value end
				) as XXXXXXXFANGSUM3
	from
		dm.XXXXXXX_decision_data

	where 
		etl_dt >= '2022-11-01'
	group by entryid 
) b 
on a.pid = b.entryid

异常和内存信息：