FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask

Question

I am new to Hadoop, and trying to run some join queries on Hive. I created two tables (table1 and table2). I executed a Join query but getting the following error message:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask

However, when I run this query in the Hive UI, the query gets executed, and I get correct results. Can some one help here in explaining what may be wrong?

Answer 1

I just added the following before running my query and it worked.

SET hive.auto.convert.join=false;

Answer 2

Just put this command before Query:

SET hive.auto.convert.join=false;

It definitely works!