Hi, Did you checked the field names in the table properly? Actually from the log file it is clear that there is no element named id in the table 'table1'. Kindly check if there is any typo. Also the alias is not required if you are dealing with a single table with simple queries.
Kindly execute 'Describe table1;' to check the fields. ~~Cheers 2011/3/22 幻 <[email protected]> > 你试过这样查么？ > 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 >> >> >> >> >> > > -- Regards, Sangita
