I forget to mention those important information. The hadoop version is 0.20..1,
while the hive version... I use svn to get it at
http://svn.apache.org/repos/asf/hadoop/hive/trunk.
Interestingly, no error in the job tracker console. It show the map is in
pending, and the Num of Tasks for reduce is 0.
Kind % Complete Num Tasks Pending Running Complete Killed
Failed/Killed Task Attempts
map 100.00% 1 1 0 0
0 0 / 0
reduce 100.00% 0 0 0
0 0 0 / 0
Luo, Gang
---------
Department of Computer Science
Duke University
(919)316-0993
[email protected]
________________________________
发件人： Ryan LeCompte <[email protected]>
收件人： "[email protected]" <[email protected]>
抄 送： "[email protected]" <[email protected]>;
"[email protected]" <[email protected]>
已发送： 周四, 10 22, 2009 6:08:00 下午
主 题： Re: hive problem
Gang,
Have you tried logging into the hadoop job tracker console and clicking on the
job that hive produced? Click on the failed tasks and see what the error is.
Which version of hadoop and hive are you running? I believe the user guide
suggests checking out code from trunk, but you should instead checkout the code
for the stable 0.4 release:
svn co http://svn.apache.org/repos/asf/hadoop/hive/tags/release-0.4.0/
Thanks,
Ryan
On Oct 22, 2009, at 6:00 PM, Gang Luo <[email protected]> wrote:
Hi everyone,
>I am new to Hive. Here is a problem.
>
>I followed the getting started instructions to setup my hive (as well as
>hadoop). I can create tables, show tables and select without any where clause.
>But once I do something that need to execute mapreduce jobs, it failed. A
>sample operation and the error is listed below:
>
>hive> select a.id from age a where id=1;
>Total MapReduce jobs = 1
>Number of reduce tasks is set to 0 since there's no reduce operator
>Starting Job = job_200910221333_0009, Tracking URL =
>http://localhost:50030/jobdetails.jsp?jobid=job_200910221333_0009
>Kill Command = /home/lgpublic/bin/hadoop/hadoop-0.20.1/bin/.../bin/hadoop
> job -Dmapred.job.tracker=localhost:9001 -kill job_200910221333_0009
>2009-10-22 04:19:50,787 map = 100%, reduce = 100%
>Ended Job = job_200910221333_0009 with errors
>FAILED: Execution Error, return code 2 from
>org.apache.hadoop.hive.ql.exec.ExecDriver
>
>I try the example in hive user guide (the u_data), it also failed. When I try
>to run a mapreduce jobs directly on hadoop, it works well. Could anyone give
>me some hints on this problem? Thanks.
>
> Gang Luo
>---------
>Department of Computer Science
>Duke University
>(919)316-0993
>[email protected]
>
>
>
>
>__________________________________________________
>赶快注册雅虎超大容量免费邮箱?
>http://cn.mail.yahoo.com
___________________________________________________________
好玩贺卡等你发，邮箱贺卡全新上线！
http://card.mail.cn.yahoo.com/
