hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhavesh Shah" <bhavesh25s...@gmail.com>
Subject RE: Problem in running Hive Queries
Date Fri, 02 Dec 2011 06:22:21 GMT
Hi,
Tthe content of file is too large, that's why I am attaching file.
Pls check it out.
Thanks.

-----Original Message-----
From: Aniket Mokashi [mailto:aniket486@gmail.com] 
Sent: Friday, December 02, 2011 11:46 AM
To: dev@hive.apache.org
Subject: Re: Problem in running Hive Queries

you should open
/tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201112021007_2120318983.txt.
That will give you more hints. Paste some lines from there on this thread.

Thanks,
Aniket

On Thu, Dec 1, 2011 at 10:11 PM, Bhavesh Shah
<bhavesh25shah@gmail.com>wrote:

> Hi,
>
> I am new to Hive. I have configured Hadoop and Hive on Windows 7 
> through Cygwin.
>
> Currently I am running hive queries on Hive CLI.
>
> I want to ask question that:
>
> When I enter the hive queries I get the following errors as:
>
> Query:
>
> bin/hive -e "insert overwrite table pokes select a.* from invites a 
> where a.ds='2008-08-15';"
>
>
>
> Errors:
>
> bin/hive -e "insert overwrite table pokes select a.* from invites a 
> where a.ds='2008-08-15';"
>
> Hive history
>
> file=/tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201112021007_21203189
> 83.txt
>
> Total MapReduce jobs = 2
>
> Launching Job 1 out of 2
>
> Number of reduce tasks is set to 0 since there's no reduce operator
>
> Starting Job = job_201112011620_0004, Tracking URL =
> http://localhost:50030/jobdetails.jsp?jobid=job_201112011620_0004
>
> Kill Command = C:\cygwin\home\Bhavesh.Shah\hadoop-0.20.2\/bin/hadoop 
> job
> -Dmapred.job.tracker=localhost:9101 -kill job_201112011620_0004
>
> 2011-12-02 10:07:30,777 Stage-1 map = 0%,  reduce = 0%
>
> 2011-12-02 10:07:57,796 Stage-1 map = 100%,  reduce = 100%
>
> Ended Job = job_201112011620_0004 with errors
>
> FAILED: Execution Error, return code 2 from 
> org.apache.hadoop.hive.ql.exec.MapRedTask
>
>
>
>
>
> So what could be the solution? Pls suggest me.
>
>
>
>
>
> Thanks and Regards,
>
> Bhavesh Shah.
>
>


--
"...:::Aniket:::... Quetzalco@tl"

Mime
View raw message