Doris报错:You can change the limit by session variable exec_mem_limit
- 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.
- 执行下面命令查看 exec_mem_limit 内存是2147483648字节
show variables like “exec_mem_limit”;
- 通过下面命令修改exec_mem_limit 内存
SET GLOBAL exec_mem_limit = 8589934592;
- 然后重启FE生效
还没有评论,来说两句吧...