Hive Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

[#1]

I am trying to run an insert statement in hive but it returns me this error:

Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

The same insert runs perfect through impala. What exactly is this error ?

[#2]

@drgenious can you share more details on the query executed and log details to check further? this error can happen for multiple reasons like data type, memory etc. it does not show the real reason. attach the trace along with other details requested.