直接使用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 MBBuffer Pool: Free Buffers: Total=0Buffer Pool: Clean Pages: Total=0Buffer Pool: Unused Reservation: Total=0TCMalloc Overhead: Total=19.19 MBRequestPool=fe-eval-exprs: Total=0 Peak=0Query(6e4c10181bd18783:2f78ae8300000000): Total=0 Peak=0RequestPool=root.zhonghong: Total=0 Peak=57.00 KBUntracked Memory: Total=257.31 MB

處理方案：

之前這個值設置為256M，修改為0，暫時解決該問題。后續遇到問題再持續優化

?

解決該問題同時，HUE之前查詢Hive和Impala異常，也變得同時正常了（問題持續跟蹤）

總結

以上是生活随笔為你收集整理的Impala-shell 查询异常 - ERROR: AnalysisException: Failed to evaluate expr: 1的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。