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 D76D59162 for ; Tue, 8 Nov 2011 11:48:49 +0000 (UTC) Received: (qmail 49593 invoked by uid 500); 8 Nov 2011 11:48:49 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 49539 invoked by uid 500); 8 Nov 2011 11:48:48 -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 49531 invoked by uid 99); 8 Nov 2011 11:48:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Nov 2011 11:48:48 +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 (nike.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; Tue, 08 Nov 2011 11:48:39 +0000 X-TM-IMSS-Message-ID: <5c64aeda000173b1@infosys.com> Received: from blrkechub03.ad.infosys.com ([10.66.236.43]) by infosys.com ([122.98.14.32]) with ESMTP (TREND IMSS SMTP Service 7.1) id 5c64aeda000173b1 ; Tue, 8 Nov 2011 17:17:40 +0530 Received: from BLRKECMBX01.ad.infosys.com ([10.66.236.21]) by blrkechub03.ad.infosys.com ([10.66.236.43]) with mapi; Tue, 8 Nov 2011 17:17:09 +0530 From: Aditya Singh30 To: "user@hive.apache.org" Date: Tue, 8 Nov 2011 17:17:08 +0530 Subject: 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: AcyeBxYZJOD1ttdLSXmJeVkjeCnfzg== Message-ID: <3328D456F567BB42856F60C58D32F0C3215D8E8057@BLRKECMBX01.ad.infosys.com> 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_3328D456F567BB42856F60C58D32F0C3215D8E8057BLRKECMBX01ad_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_3328D456F567BB42856F60C58D32F0C3215D8E8057BLRKECMBX01ad_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have setup a two node hadoop cluster, and tested it by = running examples provided with Hadoop. Examples are working fine. then I = tried to run hive on the cluster. I was able to create tables and load da= ta into tables. And also the query : "select * from tablename" is working= fine. But 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.ExecDr= iver 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:23= 5) at org.apache.hadoop.hive.ql.io.HiveInputFormat.initColumnsNeeded(HiveInputF= orm 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 their default values in Hadoop, exce= pt for the minimum changes needed to run the cluster. There is no hive-si= te.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 sol= ely for the use of the addressee(s). If you are not the intended recipient, p= lease notify the sender by e-mail and delete the original message. Further, you= are not to copy, disclose, or distribute this e-mail or its contents to any other= person and any such actions are unlawful. This e-mail may contain viruses. Infosys h= as taken every reasonable precaution to minimize this risk, but is not liable for = any damage you may sustain as a result of any virus in this e-mail. You should carry= out your own virus checks before opening the e-mail or attachment. Infosys reserve= s the right to monitor and review the content of all messages sent to or from t= his e-mail address. Messages sent to or from this e-mail address may be stored on th= e Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** --_000_3328D456F567BB42856F60C58D32F0C3215D8E8057BLRKECMBX01ad_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi,

       &nbs= p;        I have setup a two node hado= op cluster, and tested it by running examples provided with Hadoop. Examp= les 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. But when I try to run a q= uery with where option :

  &= nbsp;           &n= bsp; hive> select * from tablename where column_name=3D’Value= 217;;

I get the following error <= /o:p>

 

<= span style=3D'font-size:10.0pt;font-family:"Courier New"'>Execution Error= , return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver=

 

The jobdetails.jsp shows the following:

 

java.lang.RuntimeException: java.util.No= SuchElementException

at org.apache.hadoop.hive.ql.exec.Utilities.g= etMapRedWork(Utilities.
java:168)

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

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

…………

<= o:p> 

I am using hive’s derby on= ly and not MySQL or any other DB for metastore. And most of the settings = are having their 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 the hive’s properties.

Please tell me what is wrong and what do I need to do.

 

Regards= ,

Aditya Singh <= /p>

Infosys, India.

 

= 
*************=
*** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended sol=
ely 
for the use of the addressee(s). If you are not the intended recipient, p=
lease 
notify the sender by e-mail and delete the original message. Further, you=
 are not 
to copy, disclose, or distribute this e-mail or its contents to any other=
 person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys h=
as taken 
every reasonable precaution to minimize this risk, but is not liable for =
any damage 
you may sustain as a result of any virus in this e-mail. You should carry=
 out your 
own virus checks before opening the e-mail or attachment. Infosys reserve=
s the 
right to monitor and review the content of all messages sent to or from t=
his e-mail 
address. Messages sent to or from this e-mail address may be stored on th=
e 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--_000_3328D456F567BB42856F60C58D32F0C3215D8E8057BLRKECMBX01ad_--