New Contributor
Posts: 2
Registered: ‎07-23-2018

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?