Then where should I get that log file? I am not getting.
On Fri, Dec 2, 2011 at 11:54 AM, Aniket Mokashi <aniket...@gmail.com> wrote: > I guess this is not the right file. You should look into hive app logs.. > You can paste the full exception stack. > > Thanks, > Aniket > > On Thu, Dec 1, 2011 at 10:22 PM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote: > >> 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:aniket...@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 >> <bhavesh25s...@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" >> > > > > -- > "...:::Aniket:::... Quetzalco@tl" -- Regards, Bhavesh Shah