欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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

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

 

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

相关标签: impala