0: jdbc:hive2://localhost:10000/default> set hive.tez.container.size=1024;
No rows affected (0.027 seconds) 0: jdbc:hive2://localhost:10000/default> set hive.execution.engine; +---------------------------+ | set | +---------------------------+ | hive.execution.engine=mr | +---------------------------+ 1 row selected (0.048 seconds) 0: jdbc:hive2://localhost:10000/default> set mapreduce.map.memory.mb=1024; No rows affected (0.032 seconds) 0: jdbc:hive2://localhost:10000/default> set mapreduce.map.java.opts=-Xmx1024m; No rows affected (0.01 seconds) 0: jdbc:hive2://localhost:10000/default> set mapreduce.reduce.memory.mb=1024; No rows affected (0.014 seconds) 0: jdbc:hive2://localhost:10000/default> set mapreduce.reduce.java.opts=-Xmx1024m; No rows affected (0.015 seconds) 0: jdbc:hive2://localhost:10000/default> select job,count(*) as dd from ppl group by job limit 10; Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=2) Sorry my test VM has 2gb Ram only. So I set all the above memory size to 1GB. But it still gets the same error. please help. thanks. On Tue, Mar 29, 2022 at 8:32 PM Pau Tallada <tall...@pic.es> wrote: > I assume you have to increase container size (if using tez/yarn) > > Missatge de Bitfox <bit...@bitfox.top> del dia dt., 29 de març 2022 a les > 14:30: > >> My hive run out of memory even for a small query: >> >> 2022-03-29T20:26:51,440 WARN [Thread-1329] mapred.LocalJobRunner: >> job_local300585280_0011 >> >> java.lang.Exception: java.lang.OutOfMemoryError: Java heap space >> >> at >> org.apache.hadoop.mapred.LocalJobRunner$Job.runTasks(LocalJobRunner.java:492) >> ~[hadoop-mapreduce-client-common-3.3.2.jar:?] >> >> at >> org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:552) >> ~[hadoop-mapreduce-client-common-3.3.2.jar:?] >> >> Caused by: java.lang.OutOfMemoryError: Java heap space >> >> >> >> hadoop-3.3.2 >> >> hive-3.1.2 >> >> java version "1.8.0_321" >> >> >> >> How to fix this? thanks. >> >> >> >> > > -- > ---------------------------------- > Pau Tallada Crespí > Departament de Serveis > Port d'Informació Científica (PIC) > Tel: +34 93 170 2729 > ---------------------------------- > >