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 3A8EFFFDE for ; Thu, 2 May 2013 17:56:18 +0000 (UTC) Received: (qmail 97696 invoked by uid 500); 2 May 2013 17:56:16 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 97624 invoked by uid 500); 2 May 2013 17:56:16 -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 97616 invoked by uid 99); 2 May 2013 17:56:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 17:56:16 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kulkarni.swarnim@gmail.com designates 209.85.219.41 as permitted sender) Received: from [209.85.219.41] (HELO mail-oa0-f41.google.com) (209.85.219.41) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 17:56:09 +0000 Received: by mail-oa0-f41.google.com with SMTP id k14so822162oag.28 for ; Thu, 02 May 2013 10:55:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:content-type; bh=XJL+rtfDQO2Sr6rJQL2ynY9ujLjD2QczxrLMncQfCVY=; b=OpTspIrXX4pbR0D3swpo1gzMmTH6GjfZog0lsbE74BEyQGKzBZyyMJRHodeoiw0jKA i+LthBksrdK4RXG8/rP9AiFf4w2d3yFGq5MIW3fQvUjAYWkkQmxVC/7zuNTRklbtnZoe vcLTwVYeZhJriwSxLWWE4fjND7X0EpgylakvaONjI6ULoLmFoLXkH1zsMYS6nY7bwL3W rBJ7LRZAEoh9LnL7DzIlfHogZVrLdEfb1mCMcnoevUSp6SUHlmpxAUE7eslCbomcM0Zl tT8nc+sc7pK1fzPuhoL8xXt7zOPJVo9yrfWdkIKMLmxnsn6Fn+TAdf8AF/xS6V2hPG4e eisg== X-Received: by 10.182.139.37 with SMTP id qv5mr1998054obb.92.1367517348762; Thu, 02 May 2013 10:55:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.76.9.201 with HTTP; Thu, 2 May 2013 10:55:28 -0700 (PDT) In-Reply-To: References: From: "kulkarni.swarnim@gmail.com" Date: Thu, 2 May 2013 12:55:28 -0500 Message-ID: Subject: Re: Getting Started To: user@hive.apache.org Content-Type: multipart/alternative; boundary=e89a8f83a5c5cc6c3a04dbbff1e1 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8f83a5c5cc6c3a04dbbff1e1 Content-Type: text/plain; charset=ISO-8859-1 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 --e89a8f83a5c5cc6c3a04dbbff1e1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
But that would still use the HADOOP_CLASSPATH right?
=


On Thu, May 2= , 2013 at 12:52 PM, Cyril Bogus <cyrilbogus@gmail.com> wr= ote:
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





--
= Swarnim
--e89a8f83a5c5cc6c3a04dbbff1e1--