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 241D1F096 for ; Thu, 2 May 2013 18:04:34 +0000 (UTC) Received: (qmail 24857 invoked by uid 500); 2 May 2013 18:04:32 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 24794 invoked by uid 500); 2 May 2013 18:04:31 -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 24785 invoked by uid 99); 2 May 2013 18:04:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 18:04:31 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of cyrilbogus@gmail.com designates 209.85.212.52 as permitted sender) Received: from [209.85.212.52] (HELO mail-vb0-f52.google.com) (209.85.212.52) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 18:04:27 +0000 Received: by mail-vb0-f52.google.com with SMTP id p13so708168vbe.25 for ; Thu, 02 May 2013 11:04:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=7Q2h32CnvjkXUM+xSFNcp28KqHDyqbGKoqWj0f3kSu8=; b=s1nKBjZGWsYpYkgdXLPnOk5f+R5Yvx1SMgQHTFCROXRp0FFvNudNtzBOY+1w7qWBEX isNrqZqiEth/W3zMIDVAJx3DlPB5ylC2HeqX/ftr2KiQM6ppGtmFKIoHXTDWrvT7Caak uSyCpfdE1RQaYn7CeKytC/CucEq98KWg7vn7bKIhwGKXxwg+OoIjjNmZmkebptFUvxMt QxpWkax8ico1a1xHEYT0mfLmhrRG6QYVqM4+R4LyVqDlNLhh8G3TLUCD97hTQPEQbryo mhnzTXCs6BwH/QN8HtJHj4clPp3NuWvUvg4yaV7Nj0f6PV6gRgZJmcSzb+bI9xJ46+vQ Cm8g== MIME-Version: 1.0 X-Received: by 10.58.188.82 with SMTP id fy18mr2545472vec.41.1367517846765; Thu, 02 May 2013 11:04:06 -0700 (PDT) Received: by 10.59.12.41 with HTTP; Thu, 2 May 2013 11:04:06 -0700 (PDT) In-Reply-To: References: Date: Thu, 2 May 2013 14:04:06 -0400 Message-ID: Subject: Re: Getting Started From: Cyril Bogus To: user@hive.apache.org Content-Type: multipart/alternative; boundary=089e011847fa7b0ad004dbc00fde X-Virus-Checked: Checked by ClamAV on apache.org --089e011847fa7b0ad004dbc00fde Content-Type: text/plain; charset=ISO-8859-1 I put it in both and I am still getting the same error. On Thu, May 2, 2013 at 1:55 PM, kulkarni.swarnim@gmail.com < kulkarni.swarnim@gmail.com> wrote: > But that would still use the HADOOP_CLASSPATH right? > > > On Thu, May 2, 2013 at 12:52 PM, Cyril Bogus wrote: > >> But right now I am just trying to run it as standalone (no need to check >> for the packages I assume) with hadoop's hdfs in order to do some indexing >> on data already present in the hdfs >> >> >> On Thu, May 2, 2013 at 1:50 PM, Cyril Bogus wrote: >> >>> Actually two the one from hadoop (which is the same as from the one in >>> the hive package) and the one from mahout 0.7 which is newer antlr 3.2 >>> >>> >>> On Thu, May 2, 2013 at 1:47 PM, kulkarni.swarnim@gmail.com < >>> kulkarni.swarnim@gmail.com> wrote: >>> >>>> Do you have a different version of antlr jar in your classpath other >>>> than the one packaged with hive? >>>> >>>> >>>> On Thu, May 2, 2013 at 12:38 PM, Cyril Bogus wrote: >>>> >>>>> I am using the default setup for the hive-site.xml so the meta store >>>>> is in /user/hive/warehouse in the hdfs (Which I have setup as specified >>>>> under Getting started in the hive website. >>>>> >>>>> Here is the output from the command. >>>>> >>>>> >>>>> >>>>> hive -hiveconf hive.root.logger=INFO,console -e "show databases" >>>>> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. >>>>> Please use org.apache.hadoop.log.metrics.EventCounter in all the >>>>> log4j.properties files. >>>>> Logging initialized using configuration in >>>>> jar:file:/home/hive/lib/hive-common-0.10.0.jar!/hive-log4j.properties >>>>> 13/05/02 13:37:09 INFO SessionState: Logging initialized using >>>>> configuration in >>>>> jar:file:/home/hive/lib/hive-common-0.10.0.jar!/hive-log4j.properties >>>>> Hive history >>>>> file=/tmp/cyrille/hive_job_log_cyrille_201305021337_431171577.txt >>>>> 13/05/02 13:37:09 INFO exec.HiveHistory: Hive history >>>>> file=/tmp/cyrille/hive_job_log_cyrille_201305021337_431171577.txt >>>>> 13/05/02 13:37:09 INFO ql.Driver: >>>>> 13/05/02 13:37:09 INFO ql.Driver: >>>>> 13/05/02 13:37:09 INFO ql.Driver: >>>>> 13/05/02 13:37:09 INFO parse.ParseDriver: Parsing command: show >>>>> databases >>>>> 13/05/02 13:37:09 INFO ql.Driver: >>>> start=1367516229487 end=1367516229681 duration=194> >>>>> >>>>> Exception in thread "main" java.lang.NoSuchFieldError: type >>>>> at >>>>> org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_SHOW(HiveLexer.java:1305) >>>>> at >>>>> org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens(HiveLexer.java:6439) >>>>> at org.antlr.runtime.Lexer.nextToken(Lexer.java:84) >>>>> at >>>>> org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStream.java:95) >>>>> at org.antlr.runtime.CommonTokenStream.LT >>>>> (CommonTokenStream.java:238) >>>>> at >>>>> org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:573) >>>>> at >>>>> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:439) >>>>> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:416) >>>>> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335) >>>>> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:893) >>>>> at >>>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259) >>>>> at >>>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216) >>>>> at >>>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412) >>>>> at >>>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347) >>>>> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:706) >>>>> >>>>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613) >>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>> at >>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>>> at >>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>>> at java.lang.reflect.Method.invoke(Method.java:616) >>>>> at org.apache.hadoop.util.RunJar.main(RunJar.java:156) >>>>> >>>>> >>>>> >>>>> On Thu, May 2, 2013 at 1:25 PM, Sanjay Subramanian < >>>>> Sanjay.Subramanian@wizecommerce.com> wrote: >>>>> >>>>>> Can u share your hive-site.xml ? What meta store r u using ? >>>>>> Also try this to get additional debug messages that u can use to >>>>>> analyze the problem >>>>>> >>>>>> From your linux command prompt run the following and tell us what u >>>>>> see. Also hive-site.xml please >>>>>> >>>>>> /path/to/hive -hiveconf hive.root.logger=INFO,console -e "show >>>>>> databases" >>>>>> >>>>>> From: Cyril Bogus >>>>>> Reply-To: "user@hive.apache.org" >>>>>> Date: Thursday, May 2, 2013 10:19 AM >>>>>> To: "user@hive.apache.org" >>>>>> Subject: Getting Started >>>>>> >>>>>> Hi, >>>>>> >>>>>> I am currently running hadoop 1.0.4 and hive 0.10.0 >>>>>> also I have HADOOP_HOME set to /home/hadoop and HIVE_HOME to >>>>>> /home/hive along with JAVA_HOME also to the right location. >>>>>> and I would like to run the hive command line but I keep getting the >>>>>> following error when I try to run a simple query like show databases; >>>>>> >>>>>> >>>>>> hive >>>>>> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. >>>>>> Please use org.apache.hadoop.log.metrics.EventCounter in all the >>>>>> log4j.properties files. >>>>>> Logging initialized using configuration in >>>>>> jar:file:/home/hive/lib/hive-common-0.10.0.jar!/hive-log4j.properties >>>>>> Hive history >>>>>> file=/tmp/cyrille/hive_job_log_cyrille_201305021317_1253522258.txt >>>>>> hive> show databases; >>>>>> Exception in thread "main" java.lang.NoSuchFieldError: type >>>>>> at >>>>>> org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_SHOW(HiveLexer.java:1305) >>>>>> at >>>>>> org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens(HiveLexer.java:6439) >>>>>> at org.antlr.runtime.Lexer.nextToken(Lexer.java:84) >>>>>> at >>>>>> org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStream.java:95) >>>>>> at org.antlr.runtime.CommonTokenStream.LT >>>>>> (CommonTokenStream.java:238) >>>>>> at >>>>>> org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:573) >>>>>> at >>>>>> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:439) >>>>>> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:416) >>>>>> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335) >>>>>> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:893) >>>>>> at >>>>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259) >>>>>> at >>>>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216) >>>>>> at >>>>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412) >>>>>> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755) >>>>>> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613) >>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>>>> at >>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>>>> at >>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>>>> at java.lang.reflect.Method.invoke(Method.java:616) >>>>>> at org.apache.hadoop.util.RunJar.main(RunJar.java:156) >>>>>> >>>>>> Thank you in advance for the input >>>>>> >>>>>> CONFIDENTIALITY NOTICE >>>>>> ====================== >>>>>> This email message and any attachments are for the exclusive use of >>>>>> the intended recipient(s) and may contain confidential and privileged >>>>>> information. Any unauthorized review, use, disclosure or distribution is >>>>>> prohibited. If you are not the intended recipient, please contact the >>>>>> sender by reply email and destroy all copies of the original message along >>>>>> with any attachments, from your computer system. If you are the intended >>>>>> recipient, please be advised that the content of this message is subject to >>>>>> access, review and disclosure by the sender's Email System Administrator. >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Swarnim >>>> >>> >>> >> > > > -- > Swarnim > --089e011847fa7b0ad004dbc00fde Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I put it in both and I am still getting the same error.


On Th= u, May 2, 2013 at 1:55 PM, ku= lkarni.swarnim@gmail.com <kulkarni.swarnim@gmail.com><= /span> wrote:
But that would still use th= e HADOOP_CLASSPATH right?


On Thu, May 2, 2013 at 12:52 PM, Cyril B= ogus <cyrilbogus@gmail.com> wrote:
But right now I am just try= ing to run it as standalone (no need to check for the packages I assume) wi= th hadoop's hdfs in order to do some indexing on data already present i= n the hdfs


On Thu, May 2, 2013 at 1:50 PM, Cyril Bo= gus <cyrilbogus@gmail.com> wrote:
Actually two the one from hadoop (which is the same as fro= m the one in the hive package) and the one from mahout 0.7 which is newer a= ntlr 3.2


On Thu, May 2, 2013 at 1:47 PM, kulkarni.swarnim@gmail.com <<= a href=3D"mailto:kulkarni.swarnim@gmail.com" target=3D"_blank">kulkarni.swa= rnim@gmail.com> wrote:
Do you have a different ver= sion of antlr jar in your classpath other than the one packaged with hive?= =A0


On = Thu, May 2, 2013 at 12:38 PM, Cyril Bogus <cyrilbogus@gmail.com>= wrote:
I am using the default= setup for the hive-site.xml so the meta store is in /user/hive/warehouse i= n the hdfs (Which I have setup as specified under Getting started in the hi= ve website.

Here is the output from the command.



hive -hiveconf hive.root.logger=3DINFO,console -e=A0 "show dat= abases"
WARNING: org.apache.hadoop.metrics.jvm.EventCou= nter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter i= n all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/hive/lib/hive-com= mon-0.10.0.jar!/hive-log4j.properties
13/05/02 13:37:09 INFO Sessi= onState: Logging initialized using configuration in jar:file:/home/hive/lib= /hive-common-0.10.0.jar!/hive-log4j.properties
Hive history file=3D/tmp/cyrille/hive_job_log_cyrille_201305021337_43117157= 7.txt
13/05/02 13:37:09 INFO exec.HiveHistory: Hive history file=3D/tmp/= cyrille/hive_job_log_cyrille_201305021337_431171577.txt
13/05/02 13:37:0= 9 INFO ql.Driver: <PERFLOG method=3DDriver.run>
13/05/02 13:37:09 INFO ql.Driver: <PERFLOG method=3DTimeToSubmit>
= 13/05/02 13:37:09 INFO ql.Driver: <PERFLOG method=3Dcompile>
13/05= /02 13:37:09 INFO parse.ParseDriver: Parsing command: show databases
13/= 05/02 13:37:09 INFO ql.Driver: </PERFLOG method=3Dcompile start=3D136751= 6229487 end=3D1367516229681 duration=3D194>

Exception in thread "main" java.lang.NoSuchFieldError: type
= =A0=A0 =A0at org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_SHOW(HiveLexer.j= ava:1305)
=A0=A0 =A0at org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens= (HiveLexer.java:6439)
=A0=A0 =A0at org.antlr.runtime.Lexer.nextToken(Lexer.java:84)
=A0=A0 =A0= at org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStream.java:95= )
=A0=A0 =A0at org.antlr.runtime.CommonTokenStream.LT(CommonTokenSt= ream.java:238)
=A0=A0 =A0at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParse= r.java:573)
=A0=A0 =A0at org.apache.hadoop.hive.ql.parse.ParseDriver.par= se(ParseDriver.java:439)
=A0=A0 =A0at org.apache.hadoop.hive.ql.Driver.c= ompile(Driver.java:416)
=A0=A0 =A0at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)
= =A0=A0 =A0at org.apache.hadoop.hive.ql.Driver.run(Driver.java:893)
=A0= =A0 =A0at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.ja= va:259)
=A0=A0 =A0at org.apache.hadoop.hive.cli.CliDriver.processCmd(Cli= Driver.java:216)
=A0=A0 =A0at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.jav= a:412)
=A0=A0 =A0at org.apache.hadoop.hive.cli.CliDriver.processLi= ne(CliDriver.java:347)
=A0=A0 =A0at org.apache.hadoop.hive.cli.CliDriver= .run(CliDriver.java:706)

=A0=A0 =A0at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)<= br>=A0=A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)=
=A0=A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc= cessorImpl.java:57)
=A0=A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth= odAccessorImpl.java:43)
=A0=A0 =A0at java.lang.reflect.Method.invoke(Met= hod.java:616)
=A0=A0 =A0at org.apache.hadoop.util.RunJar.main(RunJar.jav= a:156)



On Thu, May 2, 2013 at 1:25 PM, Sanjay Subramanian <Sanjay.Subramanian@wizecommerce.com> wrote:
Can u share =A0your hive-site.xml ? What meta store r u using ?=A0
Also try this to get additional debug messages that u can use to analy= ze the problem

From your linux command prompt run the following and tell us what u se= e. Also hive-site.xml please=A0
=A0
/path/to/hive -hiveconf hive.root.logger=3DINF= O,console -e =A0"show databases"=A0

From: Cyril Bogus <cyrilbogus@gmail.com> Reply-To: "user@hive.apache.org" <<= a href=3D"mailto:user@hive.apache.org" target=3D"_blank">user@hive.apache.o= rg>
Date: Thursday, May 2, 2013 10:19 A= M
To: "user@hive.apache.org" <user@hive.apache.org= >
Subject: Getting Started

Hi,

I am currently running hadoop 1.0.4 and hive 0.10.0
also I have HADOOP_HOME set to /home/hadoop and HIVE_HOME to /home/hiv= e along with JAVA_HOME also to the right location.
and I would like to run the hive command line but I keep getting the follow= ing error when I try to run a simple query like show databases;


hive
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please u= se org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties f= iles.
Logging initialized using configuration in jar:file:/home/hive/lib/hive-com= mon-0.10.0.jar!/hive-log4j.properties
Hive history file=3D/tmp/cyrille/hive_job_log_cyrille_201305021317_12535222= 58.txt
hive> show databases;
Exception in thread "main" java.lang.NoSuchFieldError: type
=A0=A0=A0 at org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_SHOW(HiveLexer.j= ava:1305)
=A0=A0=A0 at org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens(HiveLexer.ja= va:6439)
=A0=A0=A0 at org.antlr.runtime.Lexer.nextToken(Lexer.java:84)
=A0=A0=A0 at org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStre= am.java:95)
=A0=A0=A0 at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.= java:238)
=A0=A0=A0 at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParse= r.java:573)
=A0=A0=A0 at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.= java:439)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:416)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:893)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver= .java:259)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java= :216)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.jav= a:412)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755) =A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)<= br> =A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) =A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess= orImpl.java:57)
=A0=A0=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth= odAccessorImpl.java:43)
=A0=A0=A0 at java.lang.reflect.Method.invoke(Method.java:616)
=A0=A0=A0 at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

Thank you in advance for the input

CONFIDENTIALITY NOTICE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This email message and any attachments are for the exclusive use of the int= ended recipient(s) and may contain confidential and privileged information.= Any unauthorized review, use, disclosure or distribution is prohibited. If= you are not the intended recipient, please contact the sender by reply email and destroy all copies of the ori= ginal message along with any attachments, from your computer system. If you= are the intended recipient, please be advised that the content of this mes= sage is subject to access, review and disclosure by the sender's Email System Administrator.




<= /div>--
Swarnim





<= /div>--
Swarnim

--089e011847fa7b0ad004dbc00fde--