Impala-shell 查询异常 - ERROR: AnalysisException: Failed to evaluate expr: 1
程序员文章站
2022-03-05 14:32:42
...
直接使用impala-shell 进行最近本查询,异常
[test:21000] default> select * from tbName limit 1;
Query: select * from vt_article limit 1
Query submitted at: 2018-09-14 13:43:10 (Coordinator: http://fwqzx002:25000)
ERROR: AnalysisException: Failed to evaluate expr: 1
CAUSED BY: InternalException: Memory limit exceeded: Error occurred on backend fwqzx002.zh:22000 by fragment 0:0
Memory left in process limit: -20.50 MB
Query(6e4c10181bd18783:2f78ae8300000000): Total=0 Peak=0
<unnamed>: Total=0 Peak=0Process: memory limit exceeded. Limit=256.00 MB Total=276.50 MB Peak=303.70 MB
Buffer Pool: Free Buffers: Total=0
Buffer Pool: Clean Pages: Total=0
Buffer Pool: Unused Reservation: Total=0
TCMalloc Overhead: Total=19.19 MB
RequestPool=fe-eval-exprs: Total=0 Peak=0
Query(6e4c10181bd18783:2f78ae8300000000): Total=0 Peak=0
RequestPool=root.zhonghong: Total=0 Peak=57.00 KB
Untracked Memory: Total=257.31 MB
处理方案:
之前这个值设置为256M,修改为0,暂时解决该问题。后续遇到问题再持续优化
解决该问题同时,HUE之前查询Hive和Impala异常,也变得同时正常了(问题持续跟踪)
上一篇: hyperloglog的java版使用
下一篇: 排列组合