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