安装hive出现以下错误,查阅很多资料实在不知如何解决,请大神开导
Logginginitialized using configuration in jar:file:/WZfile/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties Exception inthread "main" java.lang.RuntimeException: java.lang.RuntimeException:Unable to instantiateorg.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522) atorg.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677) atorg.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) atjava.lang.reflect.Method.invoke(Method.java:606) atorg.apache.hadoop.util.RunJar.run(RunJar.java:221) atorg.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by:java.lang.RuntimeException: Unable to instantiateorg.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient atorg.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104) atorg.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005) atorg.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 atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atorg.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521) ... 14 more Caused by:javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to thegiven database. JDBC url = jdbc:mysql://172.16.102.207:3306/hive_13?characterEncoding=UTF-8,username = hadoop. Terminating connection pool (set lazyInit to true if youexpect to start your database after your app). Original Exception: ------ com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure The last packetsent successfully to the server was 0 milliseconds ago. The driver has notreceived any packets from the server. atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988) atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341) atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284) atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) atcom.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) atjava.sql.DriverManager.getConnection(DriverManager.java:571) atjava.sql.DriverManager.getConnection(DriverManager.java:187) atcom.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) atcom.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) atcom.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) atorg.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) atorg.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atorg.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) atorg.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) atorg.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) atjava.lang.reflect.Method.invoke(Method.java:606) atjavax.jdo.JDOHelper$16.run(JDOHelper.java:1965) atjava.security.AccessController.doPrivileged(Native Method) atjavax.jdo.JDOHelper.invoke(JDOHelper.java:1960) atjavax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) atorg.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365) atorg.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394) atorg.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291) atorg.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258) atorg.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) atorg.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) atorg.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) atorg.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199) atorg.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104) atorg.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005) at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024) atorg.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503) atorg.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677) atorg.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) atorg.apache.hadoop.util.RunJar.run(RunJar.java:221) atorg.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by:java.net.ConnectException: 拒绝连接 atjava.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) atjava.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) atjava.net.Socket.connect(Socket.java:579) atcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) ... 76 more ------ NestedThrowables: java.sql.SQLException:Unable to open a test connection to the given database. JDBC url =jdbc:mysql://172.16.102.207:3306/hive_13?characterEncoding=UTF-8, username =hadoop. Terminating connection pool (set lazyInit to true if you expect tostart your database after your app). Original Exception: ------ com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure The last packetsent successfully to the server was 0 milliseconds ago. The driver has notreceived any packets from the server. atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988) atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341) atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251) atcom.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284) atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) atcom.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) atjava.sql.DriverManager.getConnection(DriverManager.java:571) atjava.sql.DriverManager.getConnection(DriverManager.java:187) atcom.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) atcom.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) atcom.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) atorg.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) atorg.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) atorg.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) atorg.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) atorg.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) atorg.datanucleus.NucleusContext.initialise(NucleusContext.java:356) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) atjava.lang.reflect.Method.invoke(Method.java:606) atjavax.jdo.JDOHelper$16.run(JDOHelper.java:1965) atjava.security.AccessController.doPrivileged(Native Method) atjavax.jdo.JDOHelper.invoke(JDOHelper.java:1960) atjavax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) atorg.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365) atorg.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394) atorg.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291) atorg.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258) atorg.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) atorg.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) atorg.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57) atorg.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762) atorg.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199) atorg.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atorg.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104) atorg.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005) atorg.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503) atorg.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677) atorg.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) atjava.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) atorg.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by:java.net.ConnectException: 拒绝连接 atjava.net.PlainSocketImpl.socketConnect(Native Method) atjava.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) atjava.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) atjava.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) atcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) ... 76 more ------ atorg.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:436) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:788) at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) atjava.lang.reflect.Method.invoke(Method.java:606) atjavax.jdo.JDOHelper$16.run(JDOHelper.java:1965) atjava.security.AccessController.doPrivileged(Native Method) atjavax.jdo.JDOHelper.invoke(JDOHelper.java:1960) atjavax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) atorg.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365) at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394) atorg.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291) atorg.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) atorg.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) atorg.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57) atorg.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) atorg.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762) atorg.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199) atorg.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74) ... 19 more Caused by:java.sql.SQLException: Unable to open a test connection to the given database.JDBC url = jdbc:mysql://172.16.102.207:3306/hive_13?characterEncoding=UTF-8,username = hadoop. Terminating connection pool (set lazyInit to true if youexpect to start your database after your app). Original Exception: ------ com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure The last packetsent successfully to the server was 0 milliseconds ago. The driver has notreceived any packets from the server. atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988) atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341) atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251) atcom.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284) atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) atjava.sql.DriverManager.getConnection(DriverManager.java:571) atjava.sql.DriverManager.getConnection(DriverManager.java:187) atcom.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) atcom.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) atcom.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) atorg.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) atorg.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) atorg.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) atorg.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) atorg.datanucleus.NucleusContext.initialise(NucleusContext.java:356) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) atjava.lang.reflect.Method.invoke(Method.java:606) at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965) atjava.security.AccessController.doPrivileged(Native Method) atjavax.jdo.JDOHelper.invoke(JDOHelper.java:1960) atjavax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) atorg.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365) atorg.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394) atorg.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291) atorg.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258) atorg.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) atorg.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) atorg.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624) atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66) atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) atorg.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199) atorg.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132) atorg.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104) atorg.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005) at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024) atorg.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503) atorg.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677) atorg.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) atorg.apache.hadoop.util.RunJar.run(RunJar.java:221) atorg.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by:java.net.ConnectException: 拒绝连接 atjava.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) atjava.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) atjava.net.Socket.connect(Socket.java:579) atcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) ... 76 more ------ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.jolbox.bonecp.PoolUtil.generateSQLException(PoolUtil.java:192) atcom.jolbox.bonecp.BoneCP.<init>(BoneCP.java:422) atcom.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) atorg.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) atorg.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:298) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atorg.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631) atorg.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301) atorg.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187) atorg.datanucleus.NucleusContext.initialise(NucleusContext.java:356) atorg.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775) ... 48 more Caused by:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications linkfailure The last packetsent successfully to the server was 0 milliseconds ago. The driver has notreceived any packets from the server. atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341) atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251) atcom.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284) atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) atcom.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) atjava.sql.DriverManager.getConnection(DriverManager.java:571) atjava.sql.DriverManager.getConnection(DriverManager.java:187) atcom.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) atcom.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) ... 60 more Caused by:java.net.ConnectException: 拒绝连接 at java.net.PlainSocketImpl.socketConnect(NativeMethod) atjava.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) atjava.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) atjava.net.Socket.connect(Socket.java:579) atcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) ... 76 more
|