java.lang.RuntimeException: java.io.FileNotFoundException: HIVE_PLAN

[Eric Djatsa <dj...@gmail.com>]

Hi, I configured an Hadoop cloud with Hadoop 0.20.2-cdh3u0.
I extracted some tables from an Oracle DB with sqoop + OraOOp plugin an
distributed the data on my nodes. I am using Hive (hive-0.7.0-cdh3u0 )
to perform some analysis on my data.
However I am encountering an issue that I can't figure out how to
solve :
Before I was trying simple queries with Hive and it was working
correctly, then I tried a more complex query with a JOIN
an I get and error.

This is the query I execute :
hive > select r1_record.id,r1_data.fa_type from r1_record JOIN
r1_data
ON (r1_record.id=r1_data.id) ;

I get the following output :
Starting Job = job_201105161109_0001, Tracking URL = ....
Kill Command = .... -kill job_201105161109_0001
2011-05-16 11:23:21,999 Stage-1 map = 0%,  reduce = 0%
2011-05-16 11:23:48,148 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201105161109_0001 with errors
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
In the logs of my jobTracker it says :
java.lang.RuntimeException: java.io.FileNotFoundException:
HIVE_PLANf0ff0b6e-dd82-4962-9678-1f689f1c8ee0 (No such file or
directory)

I found that this issue (java.io.FileNotFoundException:
HIVE_PLAN) had already been reported at :
https://issues.apache.org/jira/browse/HIVE-1019

I tried applying the patches listed there but I get this errors :
patching file ql/src/java/org/apache/hadoop/hive/ql/exec/
Utilities.java
Hunk #1 FAILED at 123.
Hunk #2 FAILED at 189.
Hunk #3 FAILED at 214.
3 out of 3 hunks FAILED -- saving rejects to file ql/src/java/org/
apache/hadoop/hive/ql/exec/Utilities.java.rej
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
CombineHiveRecordReader.java
Hunk #2 succeeded at 47 (offset 6 lines).
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
CombineHiveInputFormat.java
Hunk #1 succeeded at 18 with fuzz 1.
Hunk #2 succeeded at 36 with fuzz 2 (offset 7 lines).
Hunk #3 FAILED at 59.
Hunk #4 succeeded at 191 (offset 114 lines).
Hunk #5 FAILED at 207.
2 out of 5 hunks FAILED -- saving rejects to file ql/src/java/org/
apache/hadoop/hive/ql/io/CombineHiveInputFormat.java.rej
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
HiveInputFormat.java
Hunk #2 FAILED at 62.
Hunk #3 succeeded at 97 (offset 3 lines).
1 out of 3 hunks FAILED -- saving rejects to file ql/src/java/org/
apache/hadoop/hive/ql/io/HiveInputFormat.java.rej
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
CombineHiveInputSplit.java
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
HiveInputSplit.java
patching file ql/src/java/org/apache/hadoop/hive/ql/exec/
Utilities.java
Hunk #1 FAILED at 123.
Hunk #2 FAILED at 189.
Hunk #3 FAILED at 214.
3 out of 3 hunks FAILED -- saving rejects to file ql/src/java/org/
apache/hadoop/hive/ql/exec/Utilities.java.rej
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
CombineHiveRecordReader.java
Reversed (or previously applied) patch detected!  Assume -R? [n] y
Hunk #2 succeeded at 47 (offset 6 lines).
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
CombineHiveInputFormat.java
Reversed (or previously applied) patch detected!  Assume -R? [n] y
Hunk #1 succeeded at 18 with fuzz 1.
Hunk #2 succeeded at 38 with fuzz 2 (offset 7 lines).
Hunk #3 FAILED at 62.
Hunk #4 succeeded at 558 (offset 296 lines).
Hunk #5 FAILED at 574.
2 out of 5 hunks FAILED -- saving rejects to file ql/src/java/org/
apache/hadoop/hive/ql/io/CombineHiveInputFormat.java.rej
patching file ql/src/java/org/apache/hadoop/hive/ql/io/
HiveInputFormat.java
Reversed (or previously applied) patch detected!  Assume -R? [n] y
Hunk #2 FAILED at 64.
......
.......

The patching fails ( may be those patches
are already applied to hive-0.7.0-cdh3u0 ? ) I tried again an I get
the same error in Hive.
Thanks for your concern,
Best Regards
Ed