Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C1729777A for ; Wed, 9 Nov 2011 04:57:14 +0000 (UTC) Received: (qmail 66783 invoked by uid 500); 9 Nov 2011 04:57:14 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 66474 invoked by uid 500); 9 Nov 2011 04:57:12 -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 66457 invoked by uid 99); 9 Nov 2011 04:57:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Nov 2011 04:57:10 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [122.98.14.32] (HELO kecgate02.infosys.com) (122.98.14.32) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Nov 2011 04:57:06 +0000 X-TM-IMSS-Message-ID: <60123ce000023977@infosys.com> Received: from blrkechub02.ad.infosys.com ([10.66.236.42]) by infosys.com ([122.98.14.32]) with ESMTP (TREND IMSS SMTP Service 7.1) id 60123ce000023977 ; Wed, 9 Nov 2011 10:26:06 +0530 Received: from BLRKECHUB05.ad.infosys.com (10.66.236.45) by blrkechub02.ad.infosys.com (10.66.236.42) with Microsoft SMTP Server (TLS) id 8.2.176.0; Wed, 9 Nov 2011 10:25:33 +0530 Received: from BLRKECMBX01.ad.infosys.com ([10.66.236.21]) by BLRKECHUB05.ad.infosys.com ([10.66.236.45]) with mapi; Wed, 9 Nov 2011 10:25:20 +0530 From: Aditya Singh30 To: "user@hive.apache.org" CC: Vikas Srivastava Date: Wed, 9 Nov 2011 10:25:19 +0530 Subject: RE: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver Thread-Topic: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver Thread-Index: AcyeFhh5ovkcS3KlQGKPs5XwQpG9kAAhWJUg Message-ID: <3328D456F567BB42856F60C58D32F0C3215D8E8282@BLRKECMBX01.ad.infosys.com> References: <3328D456F567BB42856F60C58D32F0C3215D8E8057@BLRKECMBX01.ad.infosys.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_3328D456F567BB42856F60C58D32F0C3215D8E8282BLRKECMBX01ad_" MIME-Version: 1.0 --_000_3328D456F567BB42856F60C58D32F0C3215D8E8282BLRKECMBX01ad_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I am curious that if the 'value', for which we are looking = for in a column, doesn't exist, doesn't hive tells 'no data found matching = the criteria' or something like that, rather than returning an error. From: Vikas Srivastava [mailto:vikas.srivastava@one97.net] Sent: Tuesday, November 08, 2011 6:29 PM To: user@hive.apache.org Subject: Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.= exec.ExecDriver hey Aditya!! col values is case sensitive so u have to put exact value . select * from table where col_name=3D'EXACT_VALUE' regards Vikas Srivastava On Tue, Nov 8, 2011 at 5:17 PM, Aditya Singh30 > wrote: Hi, I have setup a two node hadoop cluster, and tested it by ru= nning examples provided with Hadoop. Examples are working fine. then I trie= d to run hive on the cluster. I was able to create tables and load data int= o tables. And also the query : "select * from tablename" is working fine. B= ut when I try to run a query with where option : hive> select * from tablename where column_name=3D'Value'; I get the following error Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriv= er The jobdetails.jsp shows the following: java.lang.RuntimeException: java.util.NoSuchElementException at org.apache.hadoop.hive.ql.exec.Utilities.getMapRedWork(Utilities. java:168) at org.apache.hadoop.hive.ql.io.HiveInputFormat.init(HiveInputFormat.java:235) at org.apache.hadoop.hive.ql.io.HiveInputFormat.initColumnsNeeded(HiveInputFor= m at.java:311).............. ............ I am using hive's derby only and not MySQL or any other DB for metastore. A= nd most of the settings are having their default values in Hadoop, except f= or the minimum changes needed to run the cluster. There is no hive-site.xml= as I haven't changed any of the hive's properties. Please tell me what is wrong and what do I need to do. Regards, Aditya Singh Infosys, India. **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solel= y for the use of the addressee(s). If you are not the intended recipient, ple= ase notify the sender by e-mail and delete the original message. Further, you a= re not to copy, disclose, or distribute this e-mail or its contents to any other p= erson and any such actions are unlawful. This e-mail may contain viruses. Infosys has= taken every reasonable precaution to minimize this risk, but is not liable for an= y damage you may sustain as a result of any virus in this e-mail. You should carry o= ut your own virus checks before opening the e-mail or attachment. Infosys reserves = the right to monitor and review the content of all messages sent to or from thi= s e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking ! --_000_3328D456F567BB42856F60C58D32F0C3215D8E8282BLRKECMBX01ad_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,<= /o:p>

     &= nbsp;          I am curious th= at if the ‘value’, for which we are looking for in a column, do= esn’t exist, doesn’t hive tells ‘no data found matching t= he criteria’ or something like that, rather than returning an error.<= o:p>

 

From: Vikas Srivastava [mailto:vikas.srivastava@one97.= net]
Sent: Tuesday, November 08, 2011 6:29 PM
To: user= @hive.apache.org
Subject: Re: Execution Error, return code 2 from= org.apache.hadoop.hive.ql.exec.ExecDriver

 

hey Aditya!!

col values is case sensitive so u have to = put exact value .

select * from table where col_name=3D'EXACT_VAL= UE'

regards
Vikas Srivastava

On Tue, Nov 8, 2011 at 5:17 PM, Aditya Singh30 <Aditya_Singh30@infosys.com> w= rote:

Hi,

  &= nbsp;           &nbs= p; I have setup a two node hadoop cluster, and tested it by running example= s provided with Hadoop. Examples are working fine. then I tried to run hive= on the cluster. I was able to create tables and load data into tables. And= also the query : “select * from tablename” is working fine. Bu= t when I try to run a query with where option :

 =             &nb= sp;  hive> select * from tablename where column_name=3D’Value= ’;

I get the following error

 

Execution Error, return code 2 from org.apache.hadoop.hive.q= l.exec.ExecDriver

 

T= he jobdetails.jsp shows the following:

 

java.lang.RuntimeException: java.u= til.NoSuchElementException

at org.apache.hadoop.hive.ql.exec.Utiliti= es.getMapRedWork(Utilities.
java:168)

at
org.apache.hadoop.hiv= e.ql.io.HiveInputFormat.init(HiveInputFormat.java:235)

at
org.apa= che.hadoop.hive.ql.io.HiveInputFormat.initColumnsNeeded(HiveInputForm
at= .java:311)…………..

…………

 

I am using hive’s derby only and not = MySQL or any other DB for metastore. And most of the settings are having th= eir default values in Hadoop, except for the minimum changes needed to run = the cluster. There is no hive-site.xml as I haven’t changed any of th= e hive’s properties.

Please tell me what is wron= g and what do I need to do.

 

R= egards,

Aditya Singh

<= span style=3D'font-size:9.0pt;font-family:"Bookman Old Style","serif";color= :#17365D'>Infosys, India.

 

= 
**************** CAUTION - Disclaimer ****************=
*
This e-mail conta=
ins PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). =
If you are not the intended recipient, please 
=
notify the sender by e-mail and delete the orig=
inal message. Further, you are not 
to copy, disclose, or distribute this e-mail or its conten=
ts to any other person and 
any such actions are unlawful. This e-mail may contain viruses. In=
fosys has taken 
ev=
ery reasonable precaution to minimize this risk, but is not liable for any =
damage 
you may sus=
tain as a result of any virus in this e-mail. You should carry out your 
own virus checks befo=
re opening the e-mail or attachment. Infosys reserves the 
right to monitor and review the con=
tent of all messages sent to or from this e-mail
address. Messages sent to or from this e-mai= l address may be stored on the 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***




--
With Regards
Vikas Srivastava

DWH & Analytics Team<= /span>

Mob:+91 9560885900
One97 | Let's get = talking !

 

= --_000_3328D456F567BB42856F60C58D32F0C3215D8E8282BLRKECMBX01ad_--