你试过这样查么? select a.id from table1 a; 在 2011年3月22日 下午4:31,王世森 <[email protected]>写道:
> Hi, > > > > My hive version is 0.6.0, I can query data like this: select * from table1; > > > > OK > > 1 wss > > 2 chenliang > > Time taken: 7.366 seconds > > > > But when the sql is ‘select id from table1;’, hive throws a exception: > > > > 2011-03-22 14:12:46,612 Stage-1 map = 0%, reduce = 0% > > 2011-03-22 14:13:13,984 Stage-1 map = 100%, reduce = 100% > > Ended Job = job_201103221411_0001 with errors > > > > FAILED: Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.ExecDriver > > > > Here is the hadoop log: > > java.lang.RuntimeException: java.util.NoSuchElementException > > at > org.apache.hadoop.hive.ql.exec.Utilities.getMapRedWork(Utilities.java:168) > > at > org.apache.hadoop.hive.ql.io.HiveInputFormat.init(HiveInputFormat.java:235) > > at > org.apache.hadoop.hive.ql.io.HiveInputFormat.initColumnsNeeded(HiveInputFormat.java:311) > > at > org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:217) > > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:338) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:307) > > at org.apache.hadoop.mapred.Child.main(Child.java:170) > > Caused by: java.util.NoSuchElementException > > at java.util.Vector.lastElement(Vector.java:456) > > at com.sun.beans.ObjectHandler.lastExp(ObjectHandler.java:134) > > at > com.sun.beans.ObjectHandler.dequeueResult(ObjectHandler.java:138) > > at java.beans.XMLDecoder.readObject(XMLDecoder.java:201) > > at > org.apache.hadoop.hive.ql.exec.Utilities.deserializeMapRedWork(Utilities.java:409) > > at > org.apache.hadoop.hive.ql.exec.Utilities.getMapRedWork(Utilities.java:160) > > ... 6 more > > > > So,what’s the problem? > > > > > > Thanks very much > > > > Jack > > > > >
