The advice in this thread is out of date: memory usage for joins and aggregations has been improved a lot in CDH5.5. Your issue is something different since the query doesn't have a join or group by (aggregation) in it. The first step to understand this better is to look at the impalad logs: there is usually some information in there about why the memory limit was exceeded and what operators were consuming memory.
... View more
Hi Zhifeng, I apologize for the late response. Impala currently only supports SELECTS and INSERTS in HBase tables. Unfortunately, all the other features you mention are not supported. Regards, Dimitris
... View more
