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

最新推荐文章于 2022-01-11 19:10:31 发布

原创最新推荐文章于 2022-01-11 19:10:31 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

我们不生产知识，我们只是互联网的搬运工

文章标签：

#Hive

大数据专栏收录该内容

27 篇文章

订阅专栏

本文详细记录了在Hive中遇到无法实例化SessionHiveMetaStoreClient的异常，通过初始化元数据数据库derby解决该问题的过程，并分享了初始化失败及重复函数错误的处理方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

hive> show databases;
FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

原因

没有初始化元数据数据库，在我这是 derby

那就初始化一下

root@monkey-VirtualBox:/home/monkey# $HIVE_HOME/bin/schematool -initSchema -dbType derby
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL:	 jdbc:derby:;databaseName=metastore_db;create=true
Metastore Connection Driver :	 org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:	 APP
Starting metastore schema initialization to 3.1.0
Initialization script hive-schema-3.1.0.derby.sql

 
Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

阿这。。。Error: FUNCTION 'NUCLEUS_ASCII' already exists. 这又是为什么？

不管为什么，把元数据可删掉，重新初始化总行了吧！真实场景中这么干有风险，毕竟不能随便删库的

root@monkey-VirtualBox:/home/monkey# rm -rf metastore_db/
root@monkey-VirtualBox:/home/monkey# $HIVE_HOME/bin/schematool -initSchema -dbType derby

现在就 ok 了

root@monkey-VirtualBox:~# hive
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = 3016f143-e2bd-495d-806d-dfea95fc75f2

Logging initialized using configuration in file:/usr/local/hive/conf/hive-log4j2.properties Async: true

Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Hive Session ID = 3f0e5026-671d-400b-9ff4-be650ba91b0c
hive> show databases;
OK
default
Time taken: 0.496 seconds, Fetched: 1 row(s)