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 0CC97180CF for ; Mon, 4 Apr 2016 19:06:15 +0000 (UTC) Received: (qmail 89489 invoked by uid 500); 4 Apr 2016 19:06:13 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 89419 invoked by uid 500); 4 Apr 2016 19:06:13 -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 89409 invoked by uid 99); 4 Apr 2016 19:06:12 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Apr 2016 19:06:12 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 8486F180430 for ; Mon, 4 Apr 2016 19:06:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.178 X-Spam-Level: * X-Spam-Status: No, score=1.178 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 9LvCIo5C3FOa for ; Mon, 4 Apr 2016 19:06:10 +0000 (UTC) Received: from nm40-vm8.bullet.mail.ne1.yahoo.com (nm40-vm8.bullet.mail.ne1.yahoo.com [98.138.229.184]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 757A85F5CD for ; Mon, 4 Apr 2016 19:06:09 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1459796762; bh=aHn7DacwzRjrRG4k7wzNnyTkVCa6QMJ+7XtUoj2VBsQ=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=Bs5fucUXd+bioKwA68ppAwoG307jXxdKDRwe+DjchODiQ5SC7OXZsfS1qdzZ8P+ZLLgILNUWI6iFY0ynt5NYcxqHBhRcHir4Ul3bmRjltZK3nvDrvjNnjHX6wwJ152pzBTFO4dLJYfFPWgYuNb9LbESCP9z+JLeaAPcylXLs3Os/u8fo+j6GIZa1nlcQQi6L0NNShjNSmSRlB0Mhew4qVayF+CkVt4Cw1VHzdNKRQKNW6MrQhlKNugPT+xfiNv6QSi8meBSK7YjME/xj5RFJWMIgHZvguhB21SwQ78ZcFEteN9dC2S2ZsunsCbh1HbQm7GcD7Uuf5maTGdVPO4sJOg== Received: from [127.0.0.1] by nm40.bullet.mail.ne1.yahoo.com with NNFMP; 04 Apr 2016 19:06:02 -0000 Received: from [98.138.100.114] by nm40.bullet.mail.ne1.yahoo.com with NNFMP; 04 Apr 2016 19:02:41 -0000 Received: from [98.138.226.164] by tm105.bullet.mail.ne1.yahoo.com with NNFMP; 04 Apr 2016 19:01:39 -0000 Received: from [127.0.0.1] by omp1065.mail.ne1.yahoo.com with NNFMP; 04 Apr 2016 19:01:39 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 689909.4195.bm@omp1065.mail.ne1.yahoo.com X-YMail-OSG: txpbYDAVM1nR6EIpTmOMTgqXCqLR5tDVF_LcQnLCkFmDxKcv1IG7JuM8.YpYD1G TRxpWnAwyB0BxdcpvfQzrqF_0CZYxiF5PBgaM52VgamA0qew_YFefEyMdO0vvrPfmhjE5buzKnvS TjMQkgr91CzRHYBrq6cboJ4jQeFKB696liiYYNvzGLCz956HMRIBsYRSjTHA2gZGUecMrB16uB0I T0_JFayk8baZaHfRn81QelMc5_qqaftkpaDPpKZ5XoB8ibTQs6l2Hlc2VzaHnbC0HfP0TK1wfeFR JaXiV5aJz3w0SSUgRg_fnYXr6Kd9alhm4vd8sMudH_vxvh7k1fdZkrJU1ag616vndQU0Jk1dIx_V DjGzqx0TBwc397POA2c_ELQL1Ykiat.DguPBQxq0aVO70jJ8sIU1Mi5yNiJKKW6.tjf3hHawY5_h 9piKnSqER3mzxGKb2wHUa9Umhlw0odQUvcw6BWXutYHE0fbBTq13TBL1Ou0dGmKibYK3451GOW.p 7UXUkeCvBa5jLF1J3I8z1g3jL Received: by 98.138.105.195; Mon, 04 Apr 2016 19:01:39 +0000 Date: Mon, 4 Apr 2016 19:01:37 +0000 (UTC) From: Raj Hadoop Reply-To: Raj Hadoop To: Mich Talebzadeh , user Message-ID: <548115994.2175622.1459796497831.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: Unable to start Hive CLI after install MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2175621_1436290615.1459796497821" ------=_Part_2175621_1436290615.1459796497821 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Mike. If Hive 2.0 is stable - i would definitely go for it. But let = me troubleshoot 1.1.1 issues i am facing now. here is my hive-site.xml. Can you please let me know if i am missing anythi= ng. hive.exec.scratchdir /tmp/hive hive.metastore.local false hive.metastore.warehouse.dir hdfs://z1:8899/user/hive/warehouse javax.jdo.option.ConnectionURL jdbc:oracle:thin:@//z4:1521/xe =C2=A0 javax.jdo.option.ConnectionDriverName com.oracle.jdbc.Driver =C2=A0 javax.jdo.option.ConnectionUserName hive =C2=A0 javax.jdo.option.ConnectionPassword hive =C2=A0 =C2=A0=C2=A0=C2=A0 hive.querylog.location =C2=A0=C2=A0=C2=A0 $HIVE_HOME/iotmp =C2=A0=C2=A0=C2=A0 Location of Hive run time structured log fi= le =C2=A0 =C2=A0 =C2=A0=C2=A0=C2=A0 hive.exec.local.scratchdir =C2=A0=C2=A0=C2=A0 $HIVE_HOME/iotmp =C2=A0=C2=A0=C2=A0 Local scratch space for Hive jobs =C2=A0 =C2=A0 =C2=A0=C2=A0=C2=A0 hive.downloaded.resources.dir =C2=A0=C2=A0=C2=A0 $HIVE_HOME/iotmp =C2=A0=C2=A0=C2=A0 Temporary local directory for added resourc= es in the remote file system. =C2=A0 =20 On Monday, April 4, 2016 11:46 AM, Mich Talebzadeh wrote: =20 Interesting why you did not download Hive 2.0 which is out now The error says: =C2=A0HiveConf of name hive.metastore.local does not exist In you hive-site.xml how have you configured parameters for hive.metastore? HTH Dr Mich Talebzadeh=C2=A0LinkedIn =C2=A0https://www.linkedin.com/profile/vie= w?id=3DAAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw=C2=A0http://talebzadehmich.w= ordpress.com=C2=A0 On 4 April 2016 at 18:25, Raj Hadoop wrote: Hi, I have downloaded apache hive 1.1.1 and trying to setup hive environment in= my hadoop cluster. On one of the nodes i installed hive and when i set all the variables and e= nvironment i am getting the following error.Please advise. [hadoop@z1 bin]$ hive 2016-04-04 10:12:45,686 WARN=C2=A0 [main] conf.HiveConf (HiveConf.java:init= ialize(2605)) - HiveConf of name hive.metastore.local does not exist Logging initialized using configuration in jar:file:/home/hadoop/hive/hive1= 11/lib/hive-common-1.1.1.jar!/hive-log4j.properties SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/hadoop/hadoop262/hadoop262/share/ha= doop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.= class] SLF4J: Found binding in [jar:file:/home/hadoop/hive/hive111/lib/hive-jdbc-1= .1.1-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explana= tion. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeExc= eption: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiv= eMetaStoreClient =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.ql.session.SessionState.start(= SessionState.java:472) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.ja= va:671) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.j= ava:615) =C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod) =C2=A0=C2=A0=C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet= hodAccessorImpl.java:57) =C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg= atingMethodAccessorImpl.java:43) =C2=A0=C2=A0=C2=A0 at java.lang.reflect.Method.invoke(Method.java:606) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.util.RunJar.run(RunJar.java:221) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.had= oop.hive.ql.metadata.SessionHiveMetaStoreClient =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.metastore.MetaStoreUtils.newIn= stance(MetaStoreUtils.java:1485) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.metastore.RetryingMetaStoreCli= ent.(RetryingMetaStoreClient.java:64) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.metastore.RetryingMetaStoreCli= ent.getProxy(RetryingMetaStoreClient.java:74) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.ql.metadata.Hive.createMetaSto= reClient(Hive.java:2841) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.j= ava:2860) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.ql.session.SessionState.start(= SessionState.java:453) =C2=A0=C2=A0=C2=A0 ... 8 more Caused by: java.lang.reflect.InvocationTargetException =C2=A0=C2=A0=C2=A0 at sun.reflect.NativeConstructorAccessorImpl.newInstance= 0(Native Method) =C2=A0=C2=A0=C2=A0 at sun.reflect.NativeConstructorAccessorImpl.newInstance= (NativeConstructorAccessorImpl.java:57) =C2=A0=C2=A0=C2=A0 at sun.reflect.DelegatingConstructorAccessorImpl.newInst= ance(DelegatingConstructorAccessorImpl.java:45) =C2=A0=C2=A0=C2=A0 at java.lang.reflect.Constructor.newInstance(Constructor= .java:526) =C2=A0=C2=A0=C2=A0 at org.apache.hadoop.hive.metastore.MetaStoreUtils.newIn= stance(MetaStoreUtils.java:1483) =C2=A0=C2=A0=C2=A0 ... 13 more Caused by: javax.jdo.JDOFatalInternalException: Error creating transactiona= l connection factory NestedThrowables: java.lang.reflect.InvocationTargetException =C2=A0=C2=A0=C2=A0 at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExcept= ionForNucleusException(NucleusJDOHelper.java:587) =C2=A0=C2=A0=C2=A0 at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.= freezeConfiguration(JDOPersistenceManagerFactory.java:78 Regards,Raj ------=_Part_2175621_1436290615.1459796497821 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks Mike. If Hive 2.0 is stable - i would definitely go for it. But le= t me troubleshoot 1.1.1 issues i am facing now.

here is my hive-site.xml. Can you please let me kn= ow if i am missing anything.

<property>
<name>hive.exec.scratchdir= </name>
<value>= /tmp/hive</value>
<= ;/property>


<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>


<property>
<name>hive.metastore.warehouse.dir</= name>
<value>hdfs:= //z1:8899/user/hive/warehouse</value>
</property>

<property><name>javax.jdo.option= .ConnectionURL</name>
<value>jdbc:oracle:thin:@//z4:1521/xe</value>
</property>
 
<property>
<nam= e>javax.jdo.option.ConnectionDriverName</name>
<value>com.oracle.jdbc.Driver</value&= gt;
</property>
 
<property>
<name>javax.jdo.option.ConnectionUserName</name><value>hive</value&= gt;
</property>
 
<property>
<name>javax.jdo.option.ConnectionPassword</name><value>hive</value&= gt;
</property>
 

<= ;property>
  &= nbsp; <name>hive.querylog.location</name>
    <value>$HIVE_HOME/iotmp= </value>
  =   <description>Location of Hive run time structured log file<= /description>
  <= ;/property>

  <property>
    <name>hive.exec.= local.scratchdir</name>
    <value>$HIVE_HOME/iotmp</value>
    <description&g= t;Local scratch space for Hive jobs</description>
  </property>

  <property>
&n= bsp;   <name>hive.downloaded.resources.dir</name>
    <value&g= t;$HIVE_HOME/iotmp</value>
    <description>Temporary local directory for a= dded resources in the remote file system.</description>
  </property>


</configuration&= gt;


On Monday, April 4, 2016 11:46 AM, Mich Talebzade= h <mich.talebzadeh@gmail.com> wrote:


<= div>Interesting why you did not download Hive 2.0 which is out now

The error says:

 HiveConf of name hive.metastore.local does not exist

In you hive-site.xml how have you conf= igured parameters for hive.metastore?

HTH



On 4 April 2016 at 1= 8:25, Raj Hadoop <hadoopraj@yahoo.com> wrote:
Hi,

I have downloaded apache hive = 1.1.1 and trying to setup hive environment in my hadoop cluster.
=
On one of the nodes i installed h= ive and when i set all the variables and environment i am getting the follo= wing error.
Please advise.

[hadoop@z1 bin]$ hive
2016-04-04 10:12:45,686 WARN  [main] conf.HiveConf (HiveConf= .java:initialize(2605)) - HiveConf of name hive.metastore.local does not ex= ist

Logging initialized using configur= ation in jar:file:/home/hadoop/hive/hive111/lib/hive-common-1.1.1.jar!/hive= -log4j.properties
SLF4J: Class path contains multiple SLF= 4J bindings.
SLF4J: Found binding in [jar:file:/home/hado= op/hadoop262/hadoop262/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org= /slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found bindin= g in [jar:file:/home/hadoop/hive/hive111/lib/hive-jdbc-1.1.1-standalone.jar= !/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_= bindings for an explanation.
SLF4J: Actual binding is= of type [org.slf4j.impl.Log4jLoggerFactory]
Exception in= thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unab= le to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreCl= ient
    at org.apache.hadoop.hive.ql.sess= ion.SessionState.start(SessionState.java:472)
  = ;  at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)
    at org.apache.hadoop.hive.cli.CliDriver.m= ain(CliDriver.java:615)
    at sun.reflect= .NativeMethodAccessorImpl.invoke0(Native Method)
 &n= bsp;  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces= sorImpl.java:57)
    at sun.reflect.Delega= tingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.jav= a:606)
    at org.apache.hadoop.util.RunJa= r.run(RunJar.java:221)
    at org.apache.h= adoop.util.RunJar.main(RunJar.java:136)
Caused by: java.l= ang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metad= ata.SessionHiveMetaStoreClient
    at org.= apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java= :1485)
    at org.apache.hadoop.hive.metas= tore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:64)<= br clear=3D"none">    at org.apache.hadoop.hive.metastore.Re= tryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:74)
    at org.apache.hadoop.hive.ql.metadata.Hive.create= MetaStoreClient(Hive.java:2841)
    at org= .apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2860)
    at org.apache.hadoop.hive.ql.session.SessionState.sta= rt(SessionState.java:453)
    ... 8 moreCaused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorI= mpl.newInstance0(Native Method)
    at sun= .reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccesso= rImpl.java:57)
    at sun.reflect.Delegati= ngConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.jav= a:45)
    at java.lang.reflect.Constructor= .newInstance(Constructor.java:526)
    at = org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.= java:1483)
    ... 13 more
Caused by: javax.jdo.JDOFatalInternalException: Error creating transacti= onal connection factory
NestedThrowables:
java.lang.reflect.InvocationTargetException
 &nbs= p;  at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucl= eusException(NucleusJDOHelper.java:587)
   = ; at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfigurati= on(JDOPersistenceManagerFactory.java:78



Regards,
Raj




------=_Part_2175621_1436290615.1459796497821--