We just restarted the hadoop server... On Tue, Oct 12, 2010 at 6:57 PM, vaibhav negi <sssssssena...@gmail.com>wrote:
> Hi Narendra, > > What do u mean by bouncing hadoop? Can u share the solution that worked for > u? > > Vaibhav Negi > > > > On Tue, Oct 12, 2010 at 6:48 PM, Narendra <uncle.n...@gmail.com> wrote: > >> It seemed like a problem with communications between nodes. We bounced >> hadoop and the query started working. >> >> >> On Tue, Oct 12, 2010 at 6:07 PM, Parag Arora <pa...@webaroo.com> wrote: >> >>> I was getting the same issue. Looked into jobtracker logs in /logs/hadoop >>> directory and there was an issue related to integer to string casting. I >>> think, return code 2 has to deal with casting. Can you copy/paste your >>> query. >>> >>> On Tue, Oct 12, 2010 at 5:59 PM, Narendra <uncle.n...@gmail.com> wrote: >>> >>>> Even I am facing the same issue. In fact, select * works but if you give >>>> a where clause, it cribs. >>>> >>>> Regards, >>>> Narendra >>>> >>>> On Mon, Oct 11, 2010 at 1:40 PM, Guru Prasad < >>>> guru.pra...@ibibogroup.com> wrote: >>>> >>>>> Hi all, >>>>> When i am running "select count(1) from searchlogs", I am getting >>>>> following errors. >>>>> While "select * from searchlogs" is working properly. >>>>> >>>>> >>>>> -------------------------------------------------------------------------------------- >>>>> 2010-10-11 03:52:54,371 Stage-1 map = 0%, reduce = 0% >>>>> 2010-10-11 03:53:00,467 Stage-1 map = 4%, reduce = 0% >>>>> 2010-10-11 03:53:02,542 Stage-1 map = 5%, reduce = 0% >>>>> 2010-10-11 03:53:03,566 Stage-1 map = 9%, reduce = 0% >>>>> 2010-10-11 03:53:05,640 Stage-1 map = 13%, reduce = 0% >>>>> 2010-10-11 03:53:06,644 Stage-1 map = 16%, reduce = 0% >>>>> 2010-10-11 03:53:08,671 Stage-1 map = 20%, reduce = 0% >>>>> 2010-10-11 03:53:09,720 Stage-1 map = 24%, reduce = 0% >>>>> 2010-10-11 03:53:11,824 Stage-1 map = 29%, reduce = 0% >>>>> 2010-10-11 03:53:14,883 Stage-1 map = 36%, reduce = 0% >>>>> 2010-10-11 03:53:18,000 Stage-1 map = 44%, reduce = 0% >>>>> 2010-10-11 03:53:21,037 Stage-1 map = 51%, reduce = 0% >>>>> 2010-10-11 03:53:24,085 Stage-1 map = 56%, reduce = 0% >>>>> 2010-10-11 03:53:27,203 Stage-1 map = 62%, reduce = 0% >>>>> 2010-10-11 03:53:30,294 Stage-1 map = 69%, reduce = 0% >>>>> 2010-10-11 03:53:33,519 Stage-1 map = 75%, reduce = 0% >>>>> 2010-10-11 03:53:36,599 Stage-1 map = 82%, reduce = 0% >>>>> 2010-10-11 03:53:39,866 Stage-1 map = 89%, reduce = 0% >>>>> 2010-10-11 03:53:41,931 Stage-1 map = 91%, reduce = 0% >>>>> 2010-10-11 03:53:42,942 Stage-1 map = 95%, reduce = 0% >>>>> 2010-10-11 03:53:45,031 Stage-1 map = 98%, reduce = 0% >>>>> 2010-10-11 03:53:46,042 Stage-1 map = 100%, reduce = 0% >>>>> 2010-10-11 03:53:52,083 Stage-1 map = 100%, reduce = 1% >>>>> *2010-10-11 03:54:21,328 Stage-1 map = 100%, reduce = 0%* >>>>> 2010-10-11 03:54:33,424 Stage-1 map = 100%, reduce = 2% >>>>> 2010-10-11 03:55:12,690 Stage-1 map = 100%, reduce = 3% >>>>> *2010-10-11 03:55:42,905 Stage-1 map = 100%, reduce = 0%* >>>>> 2010-10-11 03:55:55,010 Stage-1 map = 100%, reduce = 4% >>>>> 2010-10-11 03:56:10,106 Stage-1 map = 100%, reduce = 5% >>>>> 2010-10-11 03:56:49,384 Stage-1 map = 100%, reduce = 7% >>>>> *2010-10-11 03:57:04,478 Stage-1 map = 100%, reduce = 0%* >>>>> 2010-10-11 03:57:16,558 Stage-1 map = 100%, reduce = 7% >>>>> 2010-10-11 03:57:31,679 Stage-1 map = 100%, reduce = 8% >>>>> 2010-10-11 03:58:08,901 Stage-1 map = 100%, reduce = 9% >>>>> *2010-10-11 03:58:27,026 Stage-1 map = 100%, reduce = 0%* >>>>> 2010-10-11 03:58:33,067 Stage-1 map = 100%, reduce = 100% >>>>> Ended Job = job_201009280549_0050 with errors >>>>> >>>>> Failed tasks with most(4) failures : >>>>> Task URL: >>>>> http://xx.xx.xx.xxx:50030/taskdetails.jsp?jobid=job_201009280549_0050&tipid=task_201009280549_0050_r_000000 >>>>> >>>>> FAILED: Execution Error, return code 2 from >>>>> org.apache.hadoop.hive.ql.exec.ExecDriver >>>>> >>>>> ----------------------------------------------------------------------------------------------------------------------- >>>>> >>>>> Please help me out. >>>>> >>>>> Thanks & Regards >>>>> Guru Prasad >>>>> ~guru >>>>> >>>>> This message is intended only for the use of the addressee and may >>>>> contain information that is privileged, confidential >>>>> and exempt from disclosure under applicable law. If the reader of this >>>>> message is not the intended recipient, or the >>>>> employee or agent responsible for delivering the message to the intended >>>>> recipient, you are hereby notified that any >>>>> dissemination, distribution or copying of this communication is strictly >>>>> prohibited. If you have received this e-mail >>>>> in error, please notify us immediately by return e-mail and delete this >>>>> e-mail and all attachments from your system. >>>>> >>>>> >>>> >>> >> >
