Cloudera Community
ipandis
user rank
Cloudera Employee
My Accepted Solutions
Show All

Re: Backend 6:Memory Limit Exceeded" in impala 2 (...

by Cloudera Employee in Support Questions
‎12-18-2014 10:24 AM
1 Kudo
‎12-18-2014 10:24 AM
1 Kudo
Hi Nagendra, I replied to you over email. We are trying to understand and fix the 'Memory Limit Exceeded' errors. Can you please disable the partitioned_hash_join and partitioned_aggregation, by restarting Impala with those options "--enable_partitioned_aggregation=false --enable_partitioned_hash_join=false" and let me know if the queries run successfully? Regards, -Ippokratis. ... View more

Re: Backend 6:Memory Limit Exceeded" in impala 2 (...

by Cloudera Employee in Support Questions
‎11-26-2014 09:48 AM
‎11-26-2014 09:48 AM
Hi Nagendra,   Can you please send me (ipandis@cloudera) and Dimitris (dtsirogiannis@cloudera) a direct email with the entire profile log (impala log.INFO) in both configurations, the one that fails when mem_limit < 14GB and the one that succeeds? We would like to understand why this is happenning, especially whether there is data skew. Also, can you please try to run compute stats again on the tables that are missing stats (e.g. mst_location), and send us the logs, if compute stats fails?   Regards, -Ippokratis.   ... View more
Contact Me
Online
Offline
Last Visited
‎12-18-2014 01:44 PM
Community Statistics
Member Since ‎11-26-2014 09:42 AM
Last Visited ‎12-18-2014 01:44 PM
Posts 2
Kudos received 1