java.lang.RuntimeException：无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient [英] java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

查看：6062
本文介绍了java.lang.RuntimeException：无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我在Ubuntu 14.0上安装了Hadoop 2.7.1和apache-hive-1.2.1版本。


  1. 为什么会发生此错误？

  2. 是否需要安装元存储安装程序？

  3. 当我们在终端上输入hive命令时，xml的内部调用是什么，这些xml的流程是什么？

  4. 需要其他配置吗？

当我在ubuntu 14.0终端上写入配置单元命令时，它抛出了下面的异常。



<$ p $使用jar中的配置初始化日志：file：/usr/local/hive/apache-hive-1.2.1-bin/lib/hive-common- 1.2.1.jar！/hive-log4j.properties
线程main中的异常java.lang.RuntimeException：java.lang.RuntimeException：无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
在org.apache.hadoop.hive.ql.session.SessionState.start（SessionState.java:522）
在org.apache.hadoop.hive.cli.CliDriver.run（CliDriver.java： 677）
在org.apache.hadoop.hive.cli.CliDrive r.main（CliDriver.java:621）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本机方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）
。在sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method.java:520）
at org.apache.hadoop.util.RunJar。运行（RunJar.java:221）
在org.apache.hadoop.util.RunJar.main（RunJar.java:136）
引起：java.lang.RuntimeException：无法实例化org.apache在org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance .hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
（MetaStoreUtils.java:1523）
。在org.apache.hadoop.hive.metastore。 RetryingMetaStoreClient<初始化>（RetryingMetaStoreClient.java:86）
。在org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy（RetryingMetaStoreClient.java:132）
。在org.apache.hadoo在org上使用org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient（Hive.java:3005）

。 apache.hadoop.hive.ql.metadata.Hive.getMSC（Hive.java:3024）
at org.apache.hadoop.hive.ql.session.SessionState.start（SessionState.java:503）
... 8 more
由于：java.lang.reflect.InvocationTargetException $ b $在sun.reflect.NativeConstructorAccessorImpl.newInstance0（本地方法）
在sun.reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorImpl .java：62）
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl.java:45）
at java.lang.reflect.Constructor.newInstance（Constructor.java:426）
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance（MetaStoreUtils.java:1521）
... 14 more
原因：javax.jdo.JDOFatalIntern alException：创建事务连接工厂时出错
NestedThrowables：
java.lang.reflect.InvocationTargetException $ b $ org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException（NucleusJDOHelper.java:587）
。在在org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory（JDOPersistenceManagerFactory.java:333）
org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration（JDOPersistenceManagerFactory.java:788）
。在组织。 datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory（JDOPersistenceManagerFactory.java:202）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本机方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62 ）
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method.java:520 ）
at javax.jdo.JDOHelper $ 16.run（JDOHelper.java:1965）
at java.security.AccessController.doPrivileged（Native Method）
at javax.jdo.JDOHelper.invoke（ JDOHelper.java:1960）美元，javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation（JDOHelper.java:1166 b $ b）
在javax.jdo.JDOHelper.getPersistenceManagerFactory（JDOHelper.java:808）
在使用javax .jdo.JDOHelper.getPersistenceManagerFactory（JDOHelper.java:701）
at org.apache.hadoop.hive.metastore.ObjectStore.getPMF（ObjectStore.java:365）
at org.apache.hadoop.hive .metastore.ObjectStore.getPersistenceManager（ObjectStore.java:394）
at org.apache.hadoop.hive.metastore.ObjectStore.initialize（ObjectStore.java:291）
at org.apache.hadoop.hive .metastore.ObjectStore.setConf（ObjectStore.java:258）
位于org.apache.hadoop.util.ReflectionUtils.setConf（ReflectionUtils.java:76）
位于org.apache.hadoop.util.Reflection Utils.newInstance（ReflectionUtils.java:136）
at org.apache.hadoop.hive.metastore.RawStoreProxy。< init>（RawStoreProxy.java:57）
at org.apache.hadoop.hive .metastore.RawStoreProxy.getProxy（RawStoreProxy.java:66）
在org.apache.hadoop.hive.metastore.HiveMetaStore $ HMSHandler.newRawStore（HiveMetaStore.java:593）
在org.apache.hadoop .hive.metastore.HiveMetaStore $ HMSHandler.getMS（HiveMetaStore.java:571）
在org.apache.hadoop.hive.metastore.HiveMetaStore $ HMSHandler.createDefaultDB（HiveMetaStore.java:624）
。在组织.apache.hadoop.hive.metastore.HiveMetaStore $ HMSHandler.init（HiveMetaStore.java:461）
在org.apache.hadoop.hive.metastore.RetryingHMSHandler。< init>（RetryingHMSHandler.java:66）$在org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy（RetryingHMSHandler.java:72）b
$ b。在org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler（HiveMetaStore.java:5762）
在org.apache.hadoop.hive.metastore.HiveMetaStoreClient<初始化>（HiveMetaStoreClient.java:199）
。在org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient< INIT>（SessionHiveMetaStoreClient。 java：74）
... 19 more
由于：java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0（Native Method）
at sun。 reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorImpl.java:62）
在sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl.java:45）
在java.lang.reflect.Constructor.newInstance（Constructor.java：在org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension（NonManagedPluginRegistry.java:631 426）
）
在org.datanucleus.plugin.PluginManager.createExecutableExtension（PluginManager.java:325）
。在组织.datanucleus.store.AbstractStoreManager。 registerConnectionFactory（AbstractStoreManager.java:282）LT
。在org.datanucleus.store.AbstractStoreManager&;初始化>（AbstractStoreManager.java:240）
。在org.datanucleus.store.rdbms.RDBMSStoreManager< INIT> ;（RDBMSStoreManager.java:286）
at sun.reflect.NativeConstructorAccessorImpl.newInstance0（Native Method）
at sun.reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorImpl.java:62）
at sun。 reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl.java:45）
在java.lang.reflect.Constructor.newInstance（Constructor.java:426）
在org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension（NonManagedPluginRegistry。
at org.datanucleus.plugin.PluginManager.createExecutableExtension（PluginManager.java:301）
at org.datanucleus.NucleusContext.createStoreManagerForProperties（NucleusContext.java:1187）
在org.datanucleus.NucleusContext.initialise（NucleusContext.java:356）
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration（JDOPersistenceManagerFactory.java:775）
... 48 more
导致：org.datanucleus.exceptions.NucleusException：尝试调用BONECP插件来创建ConnectionPool时出现错误：在CLASSPATH中找不到指定的数据存储驱动程序（com.mysql.jdbc.Driver）。请检查您的CLASSPATH规范以及驱动程序的名称。
at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources（ConnectionFactoryImpl.java:259）
at org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources（ConnectionFactoryImpl.java:131）

在org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool（BoneCPConnectionPoolFactory.java:54）
at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources（ConnectionFactoryImpl.java:238）
... 68 more

为了避免上述错误，我创建了hive-site.xml文件： 

 <结构> 
 
<属性> 
< name> hive.metastore.warehouse.dir< / name> 
<值> / home / local / hive-metastore-dir / warehouse< /值> 
 
< / property> 
 
<属性> 
< name> javax.jdo.option.ConnectionURL< / name> 
< value> jdbc：mysql：// localhost：3306 / hivedb？createDatabaseIfNotExist = true< / value> 
< / property> 
<属性> 
< name> javax.jdo.option.ConnectionDriverName< / name> 
<值> com.mysql.jdbc.Driver< /值> 
< / property> 
<属性> 
< name> javax.jdo.option.ConnectionUserName< / name> 
<值>用户< /值> 
< / property> 
<属性> 
< name> javax.jdo.option.ConnectionPassword< / name> 
<值>密码< /值> 
< / property> 
 
<配置>

还提供了〜/ .bashrc文件中的环境变量;仍然错误仍然存​​在 

  #HIVE主目录配置
 export HIVE_HOME = / usr / local / hive / apache-hive -1.2.1-bin 
 export PATH =$ PATH：$ HIVE_HOME / bin


解决方案

 我做了下面的修改，并且能够启动Hive Shell而没有任何错误：



1。 〜/ .bashrc



在bashrc文件里添加以下环境变量到文件结尾：sudo gedit〜/ .bashrc




$ PATH = $ PATH $ $ JAVA_HOME / bin

＃Hadoop主目录配置
export HADOOP_HOME = / usr / local / hadoop $ b $ export PATH = $ PATH：$ HADOOP_HOME / bin $ b $ export PATH = $ PATH：$ HADOOP_HOME / sbin
$ b $ export HIVE_HOME = / usr / lib / hive $ b $ export PATH = $ PATH：$ HIVE_HOME / bin



2。 hive-site.xml



您必须在Hive的conf目录中创建此文件（hive-site.xml）并添加以下详细信息：

 <？xml version =1.0encoding =UTF-8standalone =no？> 
<？xml-stylesheet type =text / xslhref =configuration.xsl？> 
<配置> 
 
<属性> 
< name> javax.jdo.option.ConnectionURL< / name> 
< value> jdbc：mysql：// localhost / metastore？createDatabaseIfNotExist = true< / value> 
< / property> 
 
 
<属性> 
< name> javax.jdo.option.ConnectionDriverName< / name> 
<值> com.mysql.jdbc.Driver< /值> 
< / property> 
 
<属性> 
< name> javax.jdo.option.ConnectionUserName< / name> 
<值>根< /值> 
< / property> 
 
<属性> 
< name> javax.jdo.option.ConnectionPassword< / name> 
<值>根< /值> 
< / property> 
 
<属性> 
<名称> datanucleus.autoCreateSchema< /名称> 
<值> true< /值> 
< / property> 
 
<属性> 
< name> datanucleus.fixedDatastore< / name> 
<值> true< /值> 
< / property> 
 
<属性> 
< name> datanucleus.autoCreateTables< / name> 
<值>真实< /值> 
< / property> 
 
< / configuration>



3。您还需要将jar文件（mysql-connector-java-5.1.28.jar）放在Hive



4的lib目录中。在Ubuntu上启动Hive Shell所需的安装如下：



  4.1 MySql 
 4.2 Hadoop 
 4.3 Hive 
 4.4 Java



5。执行部分：



  1。启动Hadoop的所有服务：start-all.sh 
 
 2.输入jps命令以检查所有Hadoop服务是否已启动并运行：jps 
 
 3.输入配置单元命令进入配置单元shell：hive


I have Hadoop 2.7.1 and apache-hive-1.2.1 versions installed on ubuntu 14.0.

  1. Why this error is occurring ?
  2. Is any metastore installation required?
  3. When we typing hive command on terminal how the xml's internally called, what is the flow of those xml's?
  4. Any other configuration's required?

When I am writing the hive command on ubuntu 14.0 terminal it is throwing the below exception.

 $ hive

    Logging initialized using configuration in jar:file:/usr/local/hive/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
    Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:520)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
    Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
        at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
        at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
        at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
        ... 8 more
    Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:426)
        at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
        ... 14 more
    Caused by: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
    NestedThrowables:
    java.lang.reflect.InvocationTargetException
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:587)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:788)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:520)
        at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
        at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
        at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
        at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
        at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)
        at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)
        at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)
        at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)
        at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
        at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
        at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
        ... 19 more
    Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:426)
        at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
        at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:325)
        at org.datanucleus.store.AbstractStoreManager.registerConnectionFactory(AbstractStoreManager.java:282)
        at org.datanucleus.store.AbstractStoreManager.<init>(AbstractStoreManager.java:240)
        at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:286)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:426)
        at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
        at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
        at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
        at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
        ... 48 more
    Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:259)
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources(ConnectionFactoryImpl.java:131)
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.<init>(ConnectionFactoryImpl.java:85)
        ... 66 more
    Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
        at org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:58)
        at org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool(BoneCPConnectionPoolFactory.java:54)
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:238)
        ... 68 more

To avoid above error I created hive-site.xml with :

 <configuration>

      <property>
        <name>hive.metastore.warehouse.dir</name>
        <value>/home/local/hive-metastore-dir/warehouse</value>

      </property>

    <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://localhost:3306/hivedb?createDatabaseIfNotExist=true</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionDriverName</name>
      <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionUserName</name>
      <value>user</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionPassword</name>
      <value>password</value>
    </property>

    <configuration>

Also provided the environment variables in ~/.bashrc file; Still the error persist

#HIVE home directory configuration
export HIVE_HOME=/usr/local/hive/apache-hive-1.2.1-bin
export PATH="$PATH:$HIVE_HOME/bin"

解决方案 

I did below modifications and I am able to start the Hive Shell without any errors:

1. ~/.bashrc

Inside bashrc file add the below environment variables at End Of File : sudo gedit ~/.bashrc

#Java Home directory configuration
export JAVA_HOME="/usr/lib/jvm/java-9-oracle"
export PATH="$PATH:$JAVA_HOME/bin"

# Hadoop home directory configuration
export HADOOP_HOME=/usr/local/hadoop
export PATH=$PATH:$HADOOP_HOME/bin
export PATH=$PATH:$HADOOP_HOME/sbin

export HIVE_HOME=/usr/lib/hive
export PATH=$PATH:$HIVE_HOME/bin

2. hive-site.xml

You have to create this file(hive-site.xml) in conf directory of Hive and add the below details

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
</property>


<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>root</value>
</property>

<property>
  <name>datanucleus.autoCreateSchema</name>
  <value>true</value>
</property>

<property>
  <name>datanucleus.fixedDatastore</name>
  <value>true</value>
</property>

<property>
 <name>datanucleus.autoCreateTables</name>
 <value>True</value>
 </property>

</configuration>

3. You also need to put the jar file(mysql-connector-java-5.1.28.jar) in the lib directory of Hive

4. Below installations required on your Ubuntu to Start the Hive Shell:

    4.1 MySql
    4.2 Hadoop
    4.3 Hive
    4.4 Java

5. Execution Part:

1. Start all services of Hadoop: start-all.sh

2. Enter the jps command to check whether all Hadoop services are up and running: jps

3. Enter the hive command to enter into hive shell: hive

这篇关于java.lang.RuntimeException：无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
服务器开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆