Re: Return code 2 from org.apache.hadoop.hive.ql.exec.ExecDRiver error

[王世森]

Hi,

 

Thanks for your reply. Here is the result of ‘Describe tables;’

 

hive> Describe table1;

OK

id      int

name    string

Time taken: 18.104 seconds

 

Jack

 

发件人: sangeetha s [mailto:sangee....@gmail.com] 
发送时间: 2011年3月23日 16:40
收件人: user@hive.apache.org
主题: Re: Return code 2 from org.apache.hadoop.hive.ql.exec.ExecDRiver error

 

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 幻 <ygnhz...@gmail.com>

你试过这样查么？

select a.id from table1 a;

在 2011年3月22日 下午4:31，王世森 <wangshi...@oraro.net>写道：

 

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(HiveInputForm
at.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.jav
a: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