hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Parag Arora <pa...@webaroo.com>
Subject Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver
Date Tue, 12 Oct 2010 12:37:46 GMT
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.nari@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.prasad@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.
>>
>>
>

Mime
View raw message