Return-Path: Delivered-To: apmail-hive-user-archive@www.apache.org Received: (qmail 32746 invoked from network); 12 Oct 2010 14:51:20 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 12 Oct 2010 14:51:20 -0000 Received: (qmail 7830 invoked by uid 500); 12 Oct 2010 14:51:19 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 7790 invoked by uid 500); 12 Oct 2010 14:51:17 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 7782 invoked by uid 99); 12 Oct 2010 14:51:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Oct 2010 14:51:17 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of guru.prasad@ibibogroup.com designates 221.134.155.172 as permitted sender) Received: from [221.134.155.172] (HELO mail02.ibibogroup.com) (221.134.155.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Oct 2010 14:51:11 +0000 X-IronPort-AV: E=Sophos;i="4.57,320,1283711400"; d="scan'208,217";a="13806618" Received: from gurntmx01.idc.mihindia.com ([10.100.2.21]) by mail.mihindia.com with ESMTP; 12 Oct 2010 20:07:12 +0530 Received: from [10.80.3.56] ([10.80.3.56]) by gurntmx01.idc.mihindia.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 12 Oct 2010 20:28:00 +0530 Message-ID: <4CB4759B.7000407@ibibogroup.com> Date: Tue, 12 Oct 2010 20:20:03 +0530 From: Guru Prasad User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.9) Gecko/20100922 Thunderbird/3.1.4 MIME-Version: 1.0 To: user@hive.apache.org Subject: Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver References: <4CB2C664.6040003@ibibogroup.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------010905030008080101010605" X-OriginalArrivalTime: 12 Oct 2010 14:58:00.0277 (UTC) FILETIME=[DCE4D050:01CB6A1D] This is a multi-part message in MIME format. --------------010905030008080101010605 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1"; format="flowed" 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 > 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 > 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 > > 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 > > 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 > > 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 =3D 0%, reduce = =3D 0% > 2010-10-11 03:53:00,467 Stage-1 map =3D 4%, reduce = =3D 0% > 2010-10-11 03:53:02,542 Stage-1 map =3D 5%, reduce = =3D 0% > 2010-10-11 03:53:03,566 Stage-1 map =3D 9%, reduce = =3D 0% > 2010-10-11 03:53:05,640 Stage-1 map =3D 13%, reduce > =3D 0% > 2010-10-11 03:53:06,644 Stage-1 map =3D 16%, reduce > =3D 0% > 2010-10-11 03:53:08,671 Stage-1 map =3D 20%, reduce > =3D 0% > 2010-10-11 03:53:09,720 Stage-1 map =3D 24%, reduce > =3D 0% > 2010-10-11 03:53:11,824 Stage-1 map =3D 29%, reduce > =3D 0% > 2010-10-11 03:53:14,883 Stage-1 map =3D 36%, reduce > =3D 0% > 2010-10-11 03:53:18,000 Stage-1 map =3D 44%, reduce > =3D 0% > 2010-10-11 03:53:21,037 Stage-1 map =3D 51%, reduce > =3D 0% > 2010-10-11 03:53:24,085 Stage-1 map =3D 56%, reduce > =3D 0% > 2010-10-11 03:53:27,203 Stage-1 map =3D 62%, reduce > =3D 0% > 2010-10-11 03:53:30,294 Stage-1 map =3D 69%, reduce > =3D 0% > 2010-10-11 03:53:33,519 Stage-1 map =3D 75%, reduce > =3D 0% > 2010-10-11 03:53:36,599 Stage-1 map =3D 82%, reduce > =3D 0% > 2010-10-11 03:53:39,866 Stage-1 map =3D 89%, reduce > =3D 0% > 2010-10-11 03:53:41,931 Stage-1 map =3D 91%, reduce > =3D 0% > 2010-10-11 03:53:42,942 Stage-1 map =3D 95%, reduce > =3D 0% > 2010-10-11 03:53:45,031 Stage-1 map =3D 98%, reduce > =3D 0% > 2010-10-11 03:53:46,042 Stage-1 map =3D 100%,=20 > reduce =3D 0% > 2010-10-11 03:53:52,083 Stage-1 map =3D 100%,=20 > reduce =3D 1% > *2010-10-11 03:54:21,328 Stage-1 map =3D 100%,=20 > reduce =3D 0%* > 2010-10-11 03:54:33,424 Stage-1 map =3D 100%,=20 > reduce =3D 2% > 2010-10-11 03:55:12,690 Stage-1 map =3D 100%,=20 > reduce =3D 3% > *2010-10-11 03:55:42,905 Stage-1 map =3D 100%,=20 > reduce =3D 0%* > 2010-10-11 03:55:55,010 Stage-1 map =3D 100%,=20 > reduce =3D 4% > 2010-10-11 03:56:10,106 Stage-1 map =3D 100%,=20 > reduce =3D 5% > 2010-10-11 03:56:49,384 Stage-1 map =3D 100%,=20 > reduce =3D 7% > *2010-10-11 03:57:04,478 Stage-1 map =3D 100%,=20 > reduce =3D 0%* > 2010-10-11 03:57:16,558 Stage-1 map =3D 100%,=20 > reduce =3D 7% > 2010-10-11 03:57:31,679 Stage-1 map =3D 100%,=20 > reduce =3D 8% > 2010-10-11 03:58:08,901 Stage-1 map =3D 100%,=20 > reduce =3D 9% > *2010-10-11 03:58:27,026 Stage-1 map =3D 100%,=20 > reduce =3D 0%* > 2010-10-11 03:58:33,067 Stage-1 map =3D 100%,=20 > reduce =3D 100% > Ended Job =3D job_201009280549_0050 with errors > > Failed tasks with most(4) failures : > Task URL: > http://xx.xx.xx.xxx:50030/taskdetails.jsp?jobid=3Djob= _201009280549_0050&tipid=3Dtask_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 addr= essee and may contain information that is privileged, confidential > and exempt from disclosure under applicable law. If t= he reader of this message is not the intended recipient, or the > employee or agent responsible for delivering the mess= age to the intended recipient, you are hereby notified that any > dissemination, distribution or copying of this commun= ication is strictly prohibited. If you have received this e-mail > in error, please notify us immediately by return e-ma= il 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=20 and exempt from disclosure under applicable law. If the reader of this mess= age is not the intended recipient, or the=20 employee or agent responsible for delivering the message to the intended re= cipient, you are hereby notified that any=20 dissemination, distribution or copying of this communication is strictly pr= ohibited. If you have received this e-mail=20 in error, please notify us immediately by return e-mail and delete this e-m= ail and all attachments from your system. --------------010905030008080101010605 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-1" 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 <sssssssenator@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.nari@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 <parag@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.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@ibibo= group.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 =3D 0%,  reduce =3D 0%
2010-10-11 03:53:00,467 Stage-1 map =3D 4%,  reduce =3D 0%
2010-10-11 03:53:02,542 Stage-1 map =3D 5%,  reduce =3D 0%
2010-10-11 03:53:03,566 Stage-1 map =3D 9%,  reduce =3D 0%
2010-10-11 03:53:05,640 Stage-1 map =3D 13%,  reduce =3D 0%
2010-10-11 03:53:06,644 Stage-1 map =3D 16%,  reduce =3D 0%
2010-10-11 03:53:08,671 Stage-1 map =3D 20%,  reduce =3D 0%
2010-10-11 03:53:09,720 Stage-1 map =3D 24%,  reduce =3D 0%
2010-10-11 03:53:11,824 Stage-1 map =3D 29%,  reduce =3D 0%
2010-10-11 03:53:14,883 Stage-1 map =3D 36%,  reduce =3D 0%
2010-10-11 03:53:18,000 Stage-1 map =3D 44%,  reduce =3D 0%
2010-10-11 03:53:21,037 Stage-1 map =3D 51%,  reduce =3D 0%
2010-10-11 03:53:24,085 Stage-1 map =3D 56%,  reduce =3D 0%
2010-10-11 03:53:27,203 Stage-1 map =3D 62%,  reduce =3D 0%
2010-10-11 03:53:30,294 Stage-1 map =3D 69%,  reduce =3D 0%
2010-10-11 03:53:33,519 Stage-1 map =3D 75%,  reduce =3D 0%
2010-10-11 03:53:36,599 Stage-1 map =3D 82%,  reduce =3D 0%
2010-10-11 03:53:39,866 Stage-1 map =3D 89%,  reduce =3D 0%
2010-10-11 03:53:41,931 Stage-1 map =3D 91%,  reduce =3D 0%
2010-10-11 03:53:42,942 Stage-1 map =3D 95%,  reduce =3D 0%
2010-10-11 03:53:45,031 Stage-1 map =3D 98%,  reduce =3D 0%
2010-10-11 03:53:46,042 Stage-1 map =3D 100%,  reduce =3D 0% 2010-10-11 03:53:52,083 Stage-1 map =3D 100%,  reduce =3D 1% 2010-10-11 03:54:21,328 Stage-1 map =3D 100%,  reduc= e =3D 0%
2010-10-11 03:54:33,424 Stage-1 map =3D 100%,  reduce =3D 2% 2010-10-11 03:55:12,690 Stage-1 map =3D 100%,  reduce =3D 3% 2010-10-11 03:55:42,905 Stage-1 map =3D 100%,  reduc= e =3D 0%
2010-10-11 03:55:55,010 Stage-1 map =3D 100%,  reduce =3D 4% 2010-10-11 03:56:10,106 Stage-1 map =3D 100%,  reduce =3D 5% 2010-10-11 03:56:49,384 Stage-1 map =3D 100%,  reduce =3D 7% 2010-10-11 03:57:04,478 Stage-1 map =3D 100%,  reduc= e =3D 0%
2010-10-11 03:57:16,558 Stage-1 map =3D 100%,  reduce =3D 7% 2010-10-11 03:57:31,679 Stage-1 map =3D 100%,  reduce =3D 8% 2010-10-11 03:58:08,901 Stage-1 map =3D 100%,  reduce =3D 9% 2010-10-11 03:58:27,026 Stage-1 map =3D 100%,  reduc= e =3D 0%
2010-10-11 03:58:33,067 Stage-1 map =3D 100%,  reduce =3D 100%=
Ended Job =3D job_201009280549_0050 with errors

Failed tasks with most(4) failures :
Task URL: http://xx.xx.xx= .xxx:50030/taskdetails.jsp?jobid=3Djob_201009280549_0050&tipid=3Dtask_2= 01009280549_0050_r_000000

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.Exec= Driver
---------------------------------------------------------------------------= --------------------------------------------

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=20
and exempt from disclosure under applicable law. If the reader of this mess=
age is not the intended recipient, or the=20
employee or agent responsible for delivering the message to the intended re=
cipient, you are hereby notified that any=20
dissemination, distribution or copying of this communication is strictly pr=
ohibited. If you have received this e-mail=20
in error, please notify us immediately by return e-mail and delete this e-m=
ail and all attachments from your system.







This message is intended only for the use of the addressee and may c=
ontain information that is privileged, confidential=20
and exempt from disclosure under applicable law. If the reader of this mess=
age is not the intended recipient, or the=20
employee or agent responsible for delivering the message to the intended re=
cipient, you are hereby notified that any=20
dissemination, distribution or copying of this communication is strictly pr=
ohibited. If you have received this e-mail=20
in error, please notify us immediately by return e-mail and delete this e-m=
ail and all attachments from your system.
--------------010905030008080101010605--