Guru,
The error message is in your tasktracker log. Go the link pointed by hive
when the job fails to find the logs. In your case it was
http://xx.xx.xx.xxx:50030/taskdetails.jsp?jobid=job_201009280549_0050&tipid=task_201009280549_0050_r_000000
.
This particular link might have expired by now, so rerun your query to
reproduce the error.
On a side note, return code 2 is not restricted to any particular error.
Quoting the ExecDriver:
String statusMesg = "Ended Job = " + rj.getJobID();
if (!success) {
statusMesg += " with errors";
* returnVal = 2;*
console.printError(statusMesg);
showJobFailDebugInfo(job, rj);
}
Simply put, when the hadoop job fails , the retval is 2. What exactly
happened hive doesn't know (in most cases), but hadoop knows and thats where
you go and look for it.
On Tue, Oct 12, 2010 at 7:50 AM, Guru Prasad <guru.pra...@ibibogroup.com>wrote:
> Restarting hadoop server is not working for me.
>
>
> Thanks & Regards
> Guru Prasad
> ~guru
>
>
> On 10/12/2010 07:24 PM, Narendra wrote:
>
> 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.
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
> 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.
>
>
