Hi Y'all, I can connect to hive just fine. I can select rows just fine, but anything that appears to require map/reduce crashes consistently. Anyone know of a fix or workaround for this?
I'm using these: hive-0.11.0-bin hadoop-2.0.0-mr1-cdh4.2.0 hive> select count(*) from lookout_analytics.xfm_countries; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapred.reduce.tasks=<number> Starting Job = job_201306101539_0199, Tracking URL = http://sf1r005s034:50030/jobdetails.jsp?jobid=job_201306101539_0199 Kill Command = /Users/brothrock/hadoop/bin/hadoop job -kill job_201306101539_0199 Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1 2013-06-13 10:37:42,051 Stage-1 map = 0%, reduce = 0% 2013-06-13 10:38:10,126 Stage-1 map = 100%, reduce = 100% Ended Job = job_201306101539_0199 with errors Error during job, obtaining debugging information... Job Tracking URL: http://sf1r005s034:50030/jobdetails.jsp?jobid=job_201306101539_0199 Examining task ID: task_201306101539_0199_m_000002 (and more) from job job_201306101539_0199 Unable to retrieve URL for Hadoop Task logs. Unable to find job tracker info port. Task with the most failures(4): ----- Task ID: task_201306101539_0199_m_000000 ----- Diagnostic Messages for this Task: java.lang.RuntimeException: java.lang.NullPointerException at org.apache.hadoop.hive.ql.exec.Utilities.getMapRedWork(Utilities.java:230) at org.apache.hadoop.hive.ql.io.HiveInputFormat.init(HiveInputFormat.java:255) at org.apache.hadoop.hive.ql.io.HiveInputFormat.pushProjectionsAndFilters(HiveInputFormat.java:381) at org.apache.hadoop.hive.ql.io.HiveInputFormat.pushProjectionsAndFilters(HiveInputFormat.java:374) at org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getRecordReader(CombineHiveInputFormat.java:540) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:394) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332) at org.apache.hadoop.mapred.Child$4.run(Child.java:268) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) at org.apache.hadoop.mapred.Child.main(Child.java:262) Caused by: java.lang.NullPointerException at org.ap FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask MapReduce Jobs Launched: Job 0: Map: 1 Reduce: 1 HDFS Read: 0 HDFS Write: 0 FAIL -- Beau
