hive issue on starting

Question

ERROR:

使用jar:file:/usr/local/hive/lib/hive-common-2.1.0.jar!/hive-log4j2中的配置初始化日志。properties Async: truejava.lang.RuntimeException:无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientorg.apache.hadoop.hive.ql.session.SessionState.start (SessionState.java: 578)org.apache.hadoop.hive.ql.session.SessionState.beginStart (SessionState.java: 518)org.apache.hadoop.hive.cli.CliDriver.run (CliDriver.java: 705)org.apache.hadoop.hive.cli.CliDriver.main (CliDriver.java: 641)在sun.reflect.NativeMethodAccessorImpl。invoke0(本地方法)在sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 57)sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43)java.lang.reflect.Method.invoke (Method.java: 606)org.apache.hadoop.util.RunJar.run (RunJar.java: 221)org.apache.hadoop.util.RunJar.main (RunJar.java: 136)造成原因:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException:无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientorg.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce (Hive.java: 226)在org.apache.hadoop.hive.ql.metadata.Hive。(Hive.java: 366)org.apache.hadoop.hive.ql.metadata.Hive.create (Hive.java: 310)org.apache.hadoop.hive.ql.metadata.Hive.getInternal (Hive.java: 290)org.apache.hadoop.hive.ql.metadata.Hive.get (Hive.java: 266)org.apache.hadoop.hive.ql.session.SessionState.start (SessionState.java: 545)…9日更java.lang.RuntimeException:无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientorg.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance (MetaStoreUtils.java: 1627)在org.apache.hadoop.hive.metastore.RetryingMetaStoreClient。(RetryingMetaStoreClient.java: 80)org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy (RetryingMetaStoreClient.java: 130)org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy (RetryingMetaStoreClient.java: 101)org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient (Hive.java: 3317)org.apache.hadoop.hive.ql.metadata.Hive.getMSC (Hive.java: 3356)org.apache.hadoop.hive.ql.metadata.Hive.getMSC (Hive.java: 3336)org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions (Hive.java: 3590)org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions (Hive.java: 236)org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce (Hive.java: 221)…14个吧原因:java.lang.reflect.InvocationTargetException在sun.reflect.NativeConstructorAccessorImpl。newInstance0(本地方法)在sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java: 57)sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java: 45)java.lang.reflect.Constructor.newInstance (Constructor.java: 526)org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance (MetaStoreUtils.java: 1625)…23日更javax.jdo.JDOFatalInternalException:创建事务连接工厂错误NestedThrowables:java.lang.reflect.InvocationTargetExceptionorg.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException (NucleusJDOHelper.java: 671)org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration (JDOPersistenceManagerFactory.java: 834)org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory (JDOPersistenceManagerFactory.java: 338)org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory (JDOPersistenceManagerFactory.java: 217)在sun.reflect.NativeMethodAccessorImpl。invoke0(本地方法)在sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 57)sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43)java.lang.reflect.Method.invoke (Method.java: 606)在javax.jdo.JDOHelper 16.美元运行(JDOHelper.java: 1965)在java.security.AccessController。doPrivileged(本地方法)javax.jdo.JDOHelper.invoke (JDOHelper.java: 1960)javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation (JDOHelper.java: 1166)javax.jdo.JDOHelper.getPersistenceManagerFactory (JDOHelper.java: 808)javax.jdo.JDOHelper.getPersistenceManagerFactory (JDOHelper.java: 701)org.apache.hadoop.hive.metastore.ObjectStore.getPMF (ObjectStore.java: 424)org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager (ObjectStore.java: 453)org.apache.hadoop.hive.metastore.ObjectStore.initialize (ObjectStore.java: 327)org.apache.hadoop.hive.metastore.ObjectStore.setConf (ObjectStore.java: 294)org.apache.hadoop.util.ReflectionUtils.setConf (ReflectionUtils.java: 76)org.apache.hadoop.util.ReflectionUtils.newInstance (ReflectionUtils.java: 136)在org.apache.hadoop.hive.metastore.RawStoreProxy。(RawStoreProxy.java: 58)org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy (RawStoreProxy.java: 67)org.apache.hadoop.hive.metastore.HiveMetaStore HMSHandler.newRawStore美元(HiveMetaStore.java: 581)org.apache.hadoop.hive.metastore.HiveMetaStore HMSHandler.getMS美元(HiveMetaStore.java: 546)org.apache.hadoop.hive.metastore.HiveMetaStore HMSHandler.createDefaultDB美元(HiveMetaStore.java: 612)org.apache.hadoop.hive.metastore.HiveMetaStore HMSHandler.init美元(HiveMetaStore.java: 398)在org.apache.hadoop.hive.metastore.RetryingHMSHandler。(RetryingHMSHandler.java: 78)org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy (RetryingHMSHandler.java: 84)org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler (HiveMetaStore.java: 6396)在org.apache.hadoop.hive.metastore.HiveMetaStoreClient。(HiveMetaStoreClient.java: 236)在org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient。(SessionHiveMetaStoreClient.java: 70)…28日更原因:java.lang.reflect.InvocationTargetException在sun.reflect.NativeConstructorAccessorImpl。newInstance0(本地方法)在sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java: 57)sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java: 45)java.lang.reflect.Constructor.newInstance (Constructor.java: 526)org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension (NonManagedPluginRegistry.java: 606)org.datanucleus.plugin.PluginManager.createExecutableExtension (PluginManager.java: 330)org.datanucleus.store.AbstractStoreManager.registerConnectionFactory (AbstractStoreManager.java: 203)在org.datanucleus.store.AbstractStoreManager。(AbstractStoreManager.java: 162)在org.datanucleus.store.rdbms.RDBMSStoreManager。(RDBMSStoreManager.java: 284)在sun.reflect.NativeConstructorAccessorImpl。newInstance0(本地方法)在sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java: 57)sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java: 45)java.lang.reflect.Constructor.newInstance (Constructor.java: 526)org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension (NonManagedPluginRegistry.java: 606)org.datanucleus.plugin.PluginManager.createExecutableExtension (PluginManager.java: 301)org.datanucleus.NucleusContextHelper.createStoreManagerForProperties (NucleusContextHelper.java: 133)org.datanucleus.PersistenceNucleusContextImpl.initialise (PersistenceNucleusContextImpl.java: 420)org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration (JDOPersistenceManagerFactory.java: 821)…57更多造成原因:java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver: Unsupported major。次要版本52.0在java.lang.ClassLoader.defineClass1(本机方法)java.lang.ClassLoader.defineClass (ClassLoader.java: 800)java.security.SecureClassLoader.defineClass (SecureClassLoader.java: 142)java.net.URLClassLoader.defineClass (URLClassLoader.java: 449)java.net.URLClassLoader.access 100美元(URLClassLoader.java: 71)在java.net.URLClassLoader 1.美元运行(URLClassLoader.java: 361)在java.net.URLClassLoader 1.美元运行(URLClassLoader.java: 355)在java.security.AccessController。doPrivileged(本地方法)java.net.URLClassLoader.findClass (URLClassLoader.java: 354)java.lang.ClassLoader.loadClass (ClassLoader.java: 425)sun.misc.Launcher AppClassLoader.loadClass美元(Launcher.java: 308)java.lang.ClassLoader.loadClass (ClassLoader.java: 412)java.lang.ClassLoader.loadClass (ClassLoader.java: 358). lang . class。forName0(本地方法)java.lang.Class.forName (Class.java: 270)org.datanucleus.ClassLoaderResolverImpl.classOrNull (ClassLoaderResolverImpl.java: 510)org.datanucleus.ClassLoaderResolverImpl.classForName (ClassLoaderResolverImpl.java: 193)org.datanucleus.ClassLoaderResolverImpl.classForName (ClassLoaderResolverImpl.java: 372)在org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver (AbstractConnectionPoolFactory.java: 47)org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool (BoneCPConnectionPoolFactory.java: 54)org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources (ConnectionFactoryImpl.java: 213)org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources (ConnectionFactoryImpl.java: 117)在org.datanucleus.store.rdbms.ConnectionFactoryImpl。(ConnectionFactoryImpl.java: 82)…75

---

hive-site.xml

<?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>

Answer 1

原因:java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver

在hive-client/lib更改mysql-connector-java-5.1.17.jar版本并重试