memory limit error in impala

This is for Hadoop eco system like HDFS, Map reduce, Hive, Hbase, Pig, sqoop,sqoop2, Avro, solr, hcatalog, impala, Oozie, Zoo Keeper and Hadoop distribution like Cloudera, Hortonwork etc.
forum_admin
Site Admin
Posts: 185
Joined: Wed Jul 16, 2014 9:22 pm
Contact:

memory limit error in impala

Postby forum_admin » Sun Dec 17, 2017 11:25 pm

I got memory limit error in impala in cloudera.

impala>select * from table limit 20000;
ERROR:
Fetching results ran into the following error(s):
Memory limit exceeded


forum_admin
Site Admin
Posts: 185
Joined: Wed Jul 16, 2014 9:22 pm
Contact:

Re: memory limit error in impala

Postby forum_admin » Sun Dec 17, 2017 11:29 pm

it is common error for impala when your query use intensive memory task. You can increase the mem_limit parameter in CM.

generally set mem_limit for impala around 50% of memory capacity, if you use impala for analysis.


Return to “Hadoop and Big Data”

Who is online

Users browsing this forum: No registered users and 1 guest