Set mapred.child.java.opts=-Xmx2048M

Today, the developer ran the hive task and reported an error:

Query ID = gsadmin_20171113143046_07c2e5ee-c0e3-4624-8947-538e410bbc2b

Total jobs = 1

Launching Job 1 out of 1

Number of reduce tasks not specified. Estimated from input data size: 1009

In order to change the average load for a reducer (in bytes):

Set hive.exec.reducers.bytes.per.reducer=

In order to limit the maximum number of reducers:

Set hive.exec.reducers.max=

In order to set a constant number of reducers:

Set mapreduce.job.reduces=

Starting Job = job_1510045652060_3118, Tracking URL = http://TS-HELIUM-002:8088/proxy/application_1510045652060_3118/

Kill Command = / var/gs/hadoop/bin/hadoop job-kill job_1510045652060_3118

Hadoop job information for Stage-1: number of mappers: 31175; number of reducers: 1009

2017-11-13 14 31 14 929 Stage-1 map = 0%, reduce = 0%

2017-11-13 14 31V 36729 Stage-1 map = 57%, reduce = 0%

2017-11-13 14 31V 37790 Stage-1 map = 100%, reduce = 100%

Ended Job = job_1510045652060_3118 with errors

Examining task ID: task_1510045652060_3118_m_000097 (and more) from job

Task with the most failures (4):

-

Task ID:

Task_1510045652060_3118_m_000014

URL:

Http://TS-HELIUM-002:8088/taskdetails.jsp?jobid=job_1510045652060_3118&tipid=task_1510045652060_3118_m_000014

-

Diagnostic Messages for this Task:

Error: Java heap space

Container killed by the ApplicationMaster.

Container killed on request. Exit code is 143

Container exited with a non-zero exit code 143

Check mapred.child.java.opts=200M. The default value for online viewing is 200m.

Gsadmin@TS-DEP-TASK01:~$ hive

Logging initialized using configuration in file:/var/gs/conf/hive/hive-log4j.properties

Hive > set mapred.child.java.opts

Mapred.child.java.opts=-Xmx200m

Solution:

Execute hive > set mapred.child.java.opts=-Xmx2048M after logging in to hive

Then execute the corresponding sql