啟動hiveserver2時報錯:

java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientat org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:86) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:95) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:148) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:119) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:4181) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:4249) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:4229) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:4485) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:296) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:279) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:440) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:380) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:360) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:336) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.session.SessionState.setAuthorizerV2Config(SessionState.java:947) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.session.SessionState.setupAuth(SessionState.java:911) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.session.SessionState.applyAuthorizationPolicy(SessionState.java:1880) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hive.service.cli.CLIService.applyAuthorizationConfigPolicy(CLIService.java:131) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.cli.CLIService.init(CLIService.java:115) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.CompositeService.init(CompositeService.java:59) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:224) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.server.HiveServer2.startHiveServer2(HiveServer2.java:1013) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.server.HiveServer2.access$1800(HiveServer2.java:134) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.server.HiveServer2$StartOptionExecutor.execute(HiveServer2.java:1282) ~[hive-service-3.0.0.jar:3.0.0]at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:1126) ~[hive-service-3.0.0.jar:3.0.0]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_131]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_131]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]at org.apache.hadoop.util.RunJar.run(RunJar.java:318) ~[hadoop-common-3.1.2.jar:?]at org.apache.hadoop.util.RunJar.main(RunJar.java:232) ~[hadoop-common-3.1.2.jar:?] Caused by: java.lang.reflect.InvocationTargetExceptionat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_131]at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_131]at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_131]at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_131]at org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:84) ~[hive-exec-3.0.0.jar:3.0.0]... 30 more Caused by: org.apache.hadoop.hive.metastore.api.MetaException: Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: java.net.ConnectException: 連線被拒絕 (Connection refused)at org.apache.thrift.transport.TSocket.open(TSocket.java:226)at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:515)at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:223)at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:94)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:423)at org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:84)at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:95)at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:148)at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:119)at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:4181)at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:4249)at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:4229)at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:4485)at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:296)at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:279)at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:440)at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:380)at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:360)at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:336)at org.apache.hadoop.hive.ql.session.SessionState.setAuthorizerV2Config(SessionState.java:947)at org.apache.hadoop.hive.ql.session.SessionState.setupAuth(SessionState.java:911)at org.apache.hadoop.hive.ql.session.SessionState.applyAuthorizationPolicy(SessionState.java:1880)at org.apache.hive.service.cli.CLIService.applyAuthorizationConfigPolicy(CLIService.java:131)at org.apache.hive.service.cli.CLIService.init(CLIService.java:115)at org.apache.hive.service.CompositeService.init(CompositeService.java:59)at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:224)at org.apache.hive.service.server.HiveServer2.startHiveServer2(HiveServer2.java:1013)at org.apache.hive.service.server.HiveServer2.access$1800(HiveServer2.java:134)at org.apache.hive.service.server.HiveServer2$StartOptionExecutor.execute(HiveServer2.java:1282)at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:1126)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:498)at org.apache.hadoop.util.RunJar.run(RunJar.java:318)at org.apache.hadoop.util.RunJar.main(RunJar.java:232) Caused by: java.net.ConnectException: 連線被拒絕 (Connection refused)at java.net.PlainSocketImpl.socketConnect(Native Method)at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)at java.net.Socket.connect(Socket.java:589)at org.apache.thrift.transport.TSocket.open(TSocket.java:221)... 38 moreat org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:564) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:223) ~[hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:94) ~[hive-exec-3.0.0.jar:3.0.0]at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_131]at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_131]at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_131]at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_131]at org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:84) ~[hive-exec-3.0.0.jar:3.0.0]... 30 more 2020-05-27T23:24:13,064 INFO [main] server.HiveServer2: Shutting down HiveServer2 2020-05-27T23:24:13,064 INFO [main] server.HiveServer2: Stopping/Disconnecting tez sessions. 2020-05-27T23:24:13,063 ERROR [main] session.SessionState: Error setting up authorization: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

原因:

這是因為沒有啟動元數(shù)據(jù)庫

解決方案:

hive --service metastore

關(guān)閉hiveserver2

然后重新啟動hiveserver2

注意:

啟動的順序必須是先metastore然后是hiveserver2

如果出現(xiàn)上述報錯，必須關(guān)閉hiveserver2后重新啟動hiveserver2

否則會導致metastore在hiveserver2啟動后才啟動，那么此時hiveserver2就無法監(jiān)聽10000端口，導致beeline無法正常連接元數(shù)據(jù)庫了。

總結(jié)

以上是生活随笔為你收集整理的启动hiveserver2时报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。