Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMe

一时失言乱红尘 2022-06-16 09:44 148阅读 0赞

\[root@slave [Hadoop][]\]\# cd [Hive][]\-1.2.1/bin/

\[root@slave bin\]\# ./hive  
17/02/20 19:33:00 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist  
Logging initialized using configuration in file:/home/hadoop/hive-1.2.1/conf/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:498)  
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:423)  
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)  
... 14 more  
Caused by: MetaException(message: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 (Connection refused)  
at org.apache.thrift.transport.TSocket.open(TSocket.java:187)  
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:420)  
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:236)  
at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)  
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.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)  
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)  
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:498)  
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)  
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)  
Caused by: **java.net.ConnectException: Connection refused (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:182)  
... 22 more  
)  
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:466)  
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:236)  
at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)  
... 19 more  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
   解决办法：  
1、网上说有这样一种方法，我这边的情况试了，反正是没啥效果：  
    
  尝试修改了一下MySQL的日志格式：  
mysq -u  root -p  
mysql> set global binlog\_format='MIXED';  
mysql> flush privileges;  
再试，Ok了。记得必须是root用户才有权限更改的。  
  
2、还有种方法，我这边试了，管用：  
\[ root@slave bin\]\# ./hive --service metastore &  
\[2\] 5194  
\[root@slave bin\]\# Starting Hive Metastore Server

17/02/20 19:46:16 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

\[root@slave bin\]\#** ./hive**  
17/02/20 19:46:45 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist  
Logging initialized using configuration in file:/home/hadoop/hive-1.2.1/conf/hive-log4j.properties

hive>  show databases;

OK  
default  
h\_test  
Time taken: 1.767 seconds, Fetched: 2 row(s)  
hive> use h\_test;  
OK

Time taken: 0.283 seconds

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

解决：WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist  
去hive-site.xml下注释掉这个参数：  
这个配置很早就废除了，网上还是有很多人部署集群的时候加上这个参数

\[root@slave bin\]\# ./hive  
Logging initialized using configuration in file:/home/hadoop/hive-1.2.1/conf/hive-log4j.properties

hive> show databases;  
OK  
default  
h\_test  
Time taken: 0.644 seconds, Fetched: 2 row(s)

[Hadoop]: http://lib.csdn.net/base/hadoop
[Hive]: http://lib.csdn.net/base/hive

Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMe

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Redis连接失败，Caused by: io.lettuce.core.RedisConnectionException: Unable to connect to XXXX:6379

相关 Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

相关 Caused by: io.lettuce.core.RedisConnectionException: Unable to connect to X.X.X.X:6379

相关（解决）java.lang.RuntimeException: Unable to instantiate activity ComponentInfo..Activity

相关 Unable to instantiate activity ComponentInfo

相关 Unable to instantiate application com.android.tools.fd.runtime.BootstrapApplication:

相关 Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMe

相关 HIVE：Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

相关 Android Studio Unable to instantiate activity ComponentInfo

相关 Unable to instantiate default tuplizer [org.hibernate.tuple.entity.PojoEntityTuplizer]