Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error insert into Hive table (Execution Error, return code 2)


Error insert into Hive table (Execution Error, return code 2)


Can anyone help me?

I upload the CSV files into HDFS and then throw them in the Hive as:


create temporary external table test
uid INT
row format delimited fields terminated by '|' 
stored as textfile 
location '/my_files/test';


insert into table my_table partition(name, md) select dt, uid, name, md from test;

if the files are small then everything is fine, but if the size is large the process falls on the insert with an error:


Error during job, getting debugging information ...
Examining task ID: task_1522750657070_0091_m_000001 (and more) from job job_1522750657070_0091
Examining task ID: task_1522750657070_0091_r_000001 (and more) from job job_1522750657070_0091

Task with the most failures (4):
Task ID:

Diagnostic Messages for this Task:

FAILED: Execution Error, return code 2 from

in the YARN logs I see the following:


WARN [main] org.apache.hadoop.mapred.YarnChild: Exception running child: Call From to hadoop- failed on connection exception: Connection refused; For more details see:


all other messages INFO only 


is this the cause of the insert error?
what else can I look to solve the problem?


I met the mention that the error code 2 is a memory problem ... Is it so?

Don't have an account?
Coming from Hortonworks? Activate your account here