ExecQueryFInstances rpc query_id=07468d01ae874b96:21bd91fe00000000 failed: Memory limit exceeded: Query 07468d01ae874b96:21bd91fe00000000 could not start because the backend Impala daemon is over its memory limit Error occurred on backend slave011:22000 Memory left in process limit: -1.92 MB Process: memory limit exceeded. Limit=256.00 MB Total=257.92 MB Peak=262.94 MB Buffer Pool: Free Buffers: Total=0 Buffer Pool: Clean Pages: Total=0 Buffer Pool: Unused Reservation: Total=0 Control Service Queue: Limit=50.00 MB Total=0 Peak=18.63 KB Data Stream Service Queue: Limit=12.80 MB Total=0 Peak=17.24 KB Data Stream Manager Early RPCs: Total=0 Peak=0 TCMalloc Overhead: Total=44.72 MB RequestPool=root.hue: Total=11.90 KB Peak=672.33 KB Query(aa4be963edbec9df:c23b1bef00000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=218.00 B Total=218.00 B Peak=304.44 KB Query(2549842ada12dc29:af7a285e00000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=218.00 B Total=218.00 B Peak=304.44 KB Query(f641de9a9899f986:b86c7e5300000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=0 Total=0 Peak=270.00 KB Query(2c4661fdcacc8c9a:3eb1b2c800000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=312.00 B Total=312.00 B Peak=304.44 KB Query(1b449df4837ab898:fa7a0c6b00000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=5.58 KB Total=5.58 KB Peak=312.44 KB Query(4e4e78ec2311ad39:614f986300000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=5.58 KB Total=5.58 KB Peak=312.44 KB Query(e64665defc982c98:cfa9f28000000000): Reservation=0 ReservationLimit=204.80 MB OtherMemory=0 Total=0 Peak=660.44 KB Query(2941ef63706c711a:0615931800000000): Total=0 Peak=0 Query(8b4f00628fab6038:09146a6300000000): Total=0 Peak=0 Query(07468d01ae874b96:21bd91fe00000000): Total=0 Peak=0 RequestPool=root.default: Total=0 Peak=5.27 MB RequestPool=fe-eval-exprs: Total=0 Peak=0 Untracked Memory: Total=213.19 MB
原因:
Memory Limit Exceeded(内存超限)
解决:
修改impala配置参数:mem_limit
增大内存限制