hive报错SemanticException org.apache.hadoop.hive.ql.metadata.HiveException

最新推荐文章于 2023-04-29 18:46:13 发布

LUK流

最新推荐文章于 2023-04-29 18:46:13 发布

阅读量8.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： hive

本文链接：https://blog.youkuaiyun.com/qq_35688140/article/details/87546472

hive 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了解决Hive2在执行特定操作时报错的方法。通过在配置文件hive-site.xml中添加datanucleus.schema.autoCreateAll=true属性，并重新初始化元数据，可以成功创建数据库。

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

启动hive没有问题，但是当执行show tables或者create database xxx时，报错

hive> create database spark;
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

问题：hive2需要初始化元数据

解决方案：

在hive的配置文件hive-site.xml添加如下配置：

<property>
    <name>datanucleus.schema.autoCreateAll</name>
    <value>true</value>
</property>

在mysql删除原来的hive

drop database hive;

初始化元数据

schematool -initSchema -dbType mysql

重启hive

[root@mini1 hive]#  bin/hive
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/root/apps/apache-hive-2.3.4-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/root/apps/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.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]

Logging initialized using configuration in jar:file:/root/apps/apache-hive-2.3.4-bin/lib/hive-common-2.3.4.jar!/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> create database spark;
OK
Time taken: 7.379 seconds