开启了中间表落盘还是报错Memory of exceed limit

[yuanzhangjun]

【StarRocks版本】3.1.3 存算分离
【集群规模】例如：3fe（1 follower+2observer）+4be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡， 16C128G 10Gb/s
使用hive catalog glue作为元数据
资源组配置
create resource group hql_hive_readonly
to
(user=‘readonly’,role=‘read_catalog_only’, query_type in (‘select’))
with (
‘cpu_core_limit’ = ‘4’,
‘mem_limit’ = ‘80%’,
‘type’ = ‘normal’
);
并发至下多个sql
并开启了中间表落盘，
java.sql.SQLSyntaxErrorException: Memory of hql_hive_readonly exceed limit. try consume:5242880 Used: 71079794668, Limit: 77847834908. Mem usage has exceed the limit of the resource group [hql_hive_readonly]. You can change the limit by modifying [mem_limit] of this group
开启了中间表落盘，还是报错了，这个是为什么？

[Liang]

方便贴下SQL和执行计划吗