直接使用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,暂时解决该问题。后续遇到问题再持续优化

Impala-shell 查询异常 - ERROR: AnalysisException: Failed to evaluate expr: 1_Memory

 

解决该问题同时,HUE之前查询Hive和Impala异常,也变得同时正常了(问题持续跟踪)