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 BFCEADF24 for ; Tue, 18 Sep 2012 09:12:50 +0000 (UTC) Received: (qmail 58582 invoked by uid 500); 18 Sep 2012 09:12:49 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 58071 invoked by uid 500); 18 Sep 2012 09:12:44 -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 58028 invoked by uid 99); 18 Sep 2012 09:12:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2012 09:12:42 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_HI,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Rekha_Joshi@intuit.com designates 206.108.40.7 as permitted sender) Received: from [206.108.40.7] (HELO qdcapmail1.data.ie.intuit.net) (206.108.40.7) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2012 09:12:36 +0000 DomainKey-Signature: s=default; d=intuit.com; c=nofws; q=dns; h=X-SBRS:X-IronPort-AV:Received:Received:Received:From:To: Subject:Thread-Topic:Thread-Index:Date:Message-ID: In-Reply-To:Accept-Language:Content-Language: X-MS-Has-Attach:X-MS-TNEF-Correlator:user-agent: x-originating-ip:Content-Type:MIME-Version:Return-Path; b=kLcoFu2yIHUIXDQKd++nQGyCBx51DqwtaiS2XO/8nea+25QEGxQn08tZ QsSJ1ER+EkbBKuunGXP6JQXy8J9if7G9UX3WGJEACH1PUyfW62pyu+a4m 5jREgZjtgPNt/YJ; DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=intuit.com; i=Rekha_Joshi@intuit.com; q=dns/txt; s=default; t=1347959555; x=1379495555; h=from:to:subject:date:message-id:in-reply-to:mime-version; bh=5Xs5WQEVNrp/FNvnqCpzq136UPvQVJm+Up2T1OiQJ78=; b=cOKk8EW8yuHeyYyA4DYpnyXHqUn0q4cBaqNEbUwc3ZMio85yAA6F3kPo /0JyZto9CeCoEkYMDgJl3x6EV8GVU7rIkCG/P40nvjMZYpzrNWfem70rp vpCsyHY6CSrZVos; X-SBRS: None X-IronPort-AV: E=Sophos;i="4.80,441,1344236400"; d="scan'208,217";a="219280179" Received: from qynprdexhubap02.data.corp.intuit.net (HELO QYNPRDEXHUBAP02.corp.intuit.net) ([10.136.19.160]) by qdcapmail1.data.ie.intuit.net with ESMTP/TLS/AES128-SHA; 18 Sep 2012 02:12:10 -0700 Received: from BANPRDEXMBXAP02.corp.intuit.net (172.19.139.42) by QYNPRDEXHUBAP02.corp.intuit.net (10.136.19.160) with Microsoft SMTP Server (TLS) id 14.1.355.2; Tue, 18 Sep 2012 02:12:10 -0700 Received: from BANPRDEXMBXAP01.corp.intuit.net ([fe80::f9f7:fb00:9bd0:ae2c]) by BANPRDEXMBXAP02.corp.intuit.net ([fe80::149:f410:d496:fba7%27]) with mapi id 14.01.0355.002; Tue, 18 Sep 2012 14:42:07 +0530 From: "Joshi, Rekha" To: "user@hive.apache.org" Subject: Re: Issue while using hive 0.9 Thread-Topic: Issue while using hive 0.9 Thread-Index: AQHNlMLhaQvh8jPWo0ikWY8G3Q1pvJeOYeSA//+quoCAAWa6gP//vIoAgAAA34CAAAmtgIAAAduAgAABaoCAAJUEAA== Date: Tue, 18 Sep 2012 09:12:07 +0000 Message-ID: In-Reply-To: <50580BFD.9040804@algofusiontech.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.10.0.110310 x-originating-ip: [172.19.139.60] Content-Type: multipart/alternative; boundary="_000_CC7E39579ECBrekhajoshiintuitcom_" MIME-Version: 1.0 --_000_CC7E39579ECBrekhajoshiintuitcom_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Yes, it and all (hive-lib and hadoop jars) should be seen in class path.Ple= ase set. And if antlr 3.0.1 does not work, you will have to checkout source to be ab= le to build it with new antlr, otherwise compile and runtime would clash. However I agree today there was some issue with hive trunk build, but you c= an always choose to take few days older build in such cases using svn co = =96r svn co -r 1387000 http://svn.apache.org/repos/asf/hive/trunk hive I did tried with latest (r,1387047) now, and the build seems to be happenin= g fine. Thanks Rekha From: Sarath > Reply-To: > Date: Tue, 18 Sep 2012 11:21:57 +0530 To: > Subject: Re: Issue while using hive 0.9 No I don't see any antlr jars in the output. Infact not even the default ve= rsion that exists in the hive lib folder. Do I need to explicitly mention in the classpath? On Tuesday 18 September 2012 11:16 AM, Ashutosh Chauhan wrote: Do ps aux | grep hive n check the classpath of hive process. See if you can spot antlr jar versio= ns in it. On Mon, Sep 17, 2012 at 10:40 PM, Sarath > wrote: Thanks for the quick reply. Tried it. But same issue. Pointed system to JDK 1.6 (update 32). Changed hadoop conf to use this JDK. "java -version" prints the 1.6 version= . Replaced antlr JAR with the same version as it came in hive binary (3.0.1). Anything else I have to do? Do I need to make any changes in hive->conf fol= der? On Tuesday 18 September 2012 10:35 AM, Ashutosh Chauhan wrote: Only thing which is different then usual setups is jdk1.7 Is it possible fo= r you to test with jdk1.6 ? Ashutosh On Mon, Sep 17, 2012 at 10:02 PM, Sarath Chandra > wrote: @Ashutosh I haven't built my hive from sources. I just downloaded the binaries from t= he site. The downloaded tar has come with 3.0.1 version of antlr. I didn't = do any changes. Just set the environment variables and invoked hive and got= this error. I checked out sources and tried to build hive as directed in h= ive wiki. But the build failed. @Rekha Downloaded 3.4.1 version from the site mentioned and tried again. No luck. = Same issue. Just wondering now, how is it working for others out there. What am I missi= ng? Am I doing something wrong? Is this right combination - jdk 1.7 / hadoo= p 1.0.3 / hive 0.9.0? Regards, Sarath. On Tue, Sep 18, 2012 at 9:00 AM, Joshi, Rekha > wrote: Hi Sarath, Sorry for delay =96 I don't see this mail folder all the time. Anyhow do try with exactly antler 3.4.1 =96 available at http://www.antlr.o= rg/wiki/display/ANTLR3/ANTLR+3+Wiki+Home Even antler 3.0.1 might work. Thanks Rekha From: Sarath > Reply-To: > Date: Mon, 17 Sep 2012 17:10:01 +0530 To: > Subject: Re: Issue while using hive 0.9 >From ANTLR site downloaded the latest JAR -> antlr-3.4-complete.jar. Copied this to lib folder and tried again. Same issue persists. Thanks, Sarath. On Monday 17 September 2012 04:42 PM, Joshi, Rekha wrote: Try with antlr 3.4.1 jar? Thanks Rekha From: Sarath > Reply-To: > Date: Mon, 17 Sep 2012 16:24:02 +0530 To: > Subject: Issue while using hive 0.9 Hi, I'm new to hive. As first step downloaded version 0.9 and upacked it. Set the HIVE_HOME to t= he unpacked folder. I already have hadoop 1.0.3 installed and its configuration is in classpath= . Then issued the hive command and got the hive prompt. After this whatever I= try to execute, results in the below error - Exception in thread "main" java.lang.NoSuchFieldError: type at org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_CREATE(HiveLexer.java:= 1602) at org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens(HiveLexer.java:638= 0) at org.antlr.runtime.Lexer.nextToken(Lexer.java:89) at org.antlr.runtime.BufferedTokenStream.fetch(BufferedTokenStream.java= :133) at org.antlr.runtime.BufferedTokenStream.sync(BufferedTokenStream.java:= 127) at org.antlr.runtime.CommonTokenStream.setup(CommonTokenStream.java:132= ) at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:91) at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java= :547) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:4= 38) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:416) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:= 258) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl= .java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce= ssorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Googled and found several posts with the same issue. Every where it says th= at issue is with version of antlr.jar. But I find that antlr.jar is already with correct version inside hive's lib= directory and I don't think there's any other antlr.jar in my classpath. 1. What is going wrong? 2. Where and what else to be checked? 3. How to resolve and start using Hive? Please guide me. Regards, Sarath. --_000_CC7E39579ECBrekhajoshiintuitcom_ Content-Type: text/html; charset="Windows-1252" Content-ID: <1F65DC015DD7D149A7E1E571C92B7ECB@intuit.com> Content-Transfer-Encoding: quoted-printable
Yes, it and all (hive-lib and hadoop jars) should be seen in class pat= h.Please set.

And if antlr 3.0.1 does not work, you will have to checkout source to = be able to build it with new antlr, otherwise compile and runtime would cla= sh.
However I agree today there was some issue with hive trunk build, but = you can always choose to take few days older build in such cases using svn = co =96r <release no>
svn co -r 1387000 http://svn.apache.org/repos/asf/hive/trunk hive

I did tried with latest (r,1387047) now, and the build seems to b= e happening fine.

Thanks
Rekha

From: Sarath <sarathchandra.josyam@algofusiontec= h.com>
Reply-To: <user@hive.apache.org>
Date: Tue, 18 Sep 2012 11:21:57 = 3;0530
To: <user@hive.apache.org>
Subject: Re: Issue while using hive= 0.9

No I don't see any antlr jars in the output.= Infact not even the default version that exists in the hive lib folder. Do I need to explicitly mention in the classpath?

On Tuesday 18 September 2012 11:16 AM, Ashutosh Chauhan wrote:
Do
ps aux | grep hive
n check the classpath of hive process. See if you can spot antlr jar v= ersions in it.

On Mon, Sep 17, 2012 at 10:40 PM, Sarath <sarathchandra.josyam@algofusiontech.com&= gt; wrote:
Thanks for the quick reply. Tried it. But same issue.

Pointed system to JDK 1.6 (update 32).
Changed hadoop conf to use this JDK. "java -version" prints the 1= .6 version.
Replaced antlr JAR with the same version as it came in hive binary (3.0.1).=

Anything else I have to do? Do I need to make any changes in hive->conf = folder?


On Tuesday 18 September 2012 10:35 AM, Ashutosh Chauhan wrote:
Only thing which is different then usual setups i= s jdk1.7 Is it possible for you to test with jdk1.6 ?

Ashutosh
On Mon, Sep 17, 2012 at 10:02 PM, Sarath Chandra= <sarathchandra.josyam@algofusiontech.com&= gt; wrote:
@Ashutosh
I haven't built my hive from sources. I just downloaded the binaries f= rom the site. The downloaded tar has come with 3.0.1 version of antlr. I di= dn't do any changes. Just set the environment variables and invoked hive an= d got this error. I checked out sources and tried to build hive as directed in hive wiki. But the build fa= iled.

@Rekha
Downloaded 3.4.1 version from the site mentioned and tried again. No l= uck. Same issue.

Just wondering now, how is it working for others out there. What am I = missing? Am I doing something wrong? Is this right combination - jdk 1.7 / = hadoop 1.0.3 / hive 0.9.0?

Regards,
Sarath.


On Tue, Sep 18, 2012 at 9:00 AM, Joshi, Rekha <Rekha_Joshi@intuit.com> wrote:
Hi Sarath,

Sorry for delay =96 I don't see this mail folder all the time.

Anyhow do try with exactly antler 3.4.1 =96 available at http://www.antlr.org/wiki/displa= y/ANTLR3/ANTLR+3+Wiki+Home

Even antler 3.0.1 might work.

Thanks
Rekha

Date: Mon, 17 Sep 2012 17:10:01 = 3;0530
To: <user@hive.apache.or= g>
Subject: Re: Issue while using hive= 0.9

From ANTLR site downloaded the latest JAR -> antlr-3.4-complete.jar= .
Copied this to lib folder and tried again. Same issue persists.

Thanks,
Sarath.

On Monday 17 September 2012 04:42 PM, Joshi, Rekha wrote:
Try with antlr 3.4.1 jar? 

Thanks
Rekha

From: Sarath <sarathchandra.josyam@algofusiontech.com>
Reply-To: <user@hive.apa= che.org>
Date: Mon, 17 Sep 2012 16:24:02 = 3;0530
To: <user@hive.apache.or= g>
Subject: Issue while using hive 0.9=

Hi,

I'm new to hive.

As first step downloaded version 0.9 and upacked it. Set the HIVE_HOME to t= he unpacked folder.
I already have hadoop 1.0.3 installed and its configuration is in classpath= .

Then issued the hive command and got the hive prompt. After this whatever I= try to execute, results in the below error -
Exception in thread "main" java.lang.NoSuchFieldError: = type
    at org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_CREATE(= HiveLexer.java:1602)
    at org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens(Hiv= eLexer.java:6380)
    at org.antlr.runtime.Lexer.nextToken(Lexer.java:89)
    at org.antlr.runtime.BufferedTokenStream.fetch(BufferedT= okenStream.java:133)
    at org.antlr.runtime.BufferedTokenStream.sync(BufferedTo= kenStream.java:127)
    at org.antlr.runtime.CommonTokenStream.setup(CommonToken= Stream.java:132)
    at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:91)
    at org.apache.hadoop.hive.ql.parse.HiveParser.statement(= HiveParser.java:547)
    at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(Par= seDriver.java:438)
    at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:= 416)
    at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:= 336)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909)=
    at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(= CliDriver.java:258)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDr= iver.java:215)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliD= river.java:406)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.ja= va:689)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.j= ava:557)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet= hodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg= atingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

Googled and found several posts with the same issue. Every where it says th= at issue is with version of antlr.jar.
But I find that antlr.jar is already with correct version inside hive's lib= directory and I don't think there's any other antlr.jar in my classpath.
1. What is going wrong?
2. Where and what else to be checked?
3. How to resolve and start using Hive?

Please guide me.

Regards,
Sarath.





 --_000_CC7E39579ECBrekhajoshiintuitcom_--