Doris报错：You can change the limit by session variable exec_mem_limit

1. Doris查询时报以下错误，翻译以下应该是内存溢出

errCode = 2, detailMessage = Memory exceed limit. New partitioned Aggregation in spill Backend: ip, fragment: 19530b73ae33475a-9fd4089caca411c3 Used: 2525366160, Limit: -1. You can change the limit by session variable exec_mem_limit.

2. 执行下面命令查看 exec_mem_limit 内存是2147483648字节

show variables like “exec_mem_limit”;

3. 通过下面命令修改exec_mem_limit 内存

SET GLOBAL exec_mem_limit = 8589934592;

4. 然后重启FE生效