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
