hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sangeetha s <sangee....@gmail.com>
Subject Re: Return code 2 from org.apache.hadoop.hive.ql.exec.ExecDRiver error
Date Wed, 23 Mar 2011 09:06:34 GMT
Hi,

Did you checked your hadoop cluster? Are you able to run hadoop jobs
successfully? Because, the query 'Select * from table1;' will fetch the
information directly from the metastore and will not be executed as a series
of map/reduce jobs.

While running a query with some filters,say 'select id from table1;' will
produce several map reduce jobs which will be executed in the hadoop
cluster.
So kindly check your cluster status before proceeding.

Also kindly tell me which ,metastore are you using for Hive? i.e MySql or
Derby.

~~Cheers..

2011/3/23 王世森 <wangshisen@oraro.net>

>  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.sha@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 幻 <ygnhzeus@gmail.com>
>
> 你试过这样查么?
>
> select a.id from table1 a;
>
> 在 2011年3月22日 下午4:31,王世森 <wangshisen@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(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
>



-- 



Regards,
Sangita

Mime
View raw message