Hive 启动 MetaStore 报错：Version information not found in metastore

原创

已于 2022-09-02 22:46:42 修改 · 1.3w 阅读

标签

#hive #hadoop #大数据

于 2020-08-31 17:19:23 首次发布

本文详细解析了Hive Metastore启动时遇到的Version information not found in metastore错误，介绍了错误的原因在于metastore数据库中缺乏版本信息，提供了通过设置hive.metastore.schema.verification为false或使用schematool进行初始化的解决方案。

我创建了一个《Hadoop 成神之路》的星球，大家有Hadoop 相关的问题可以直接在星球里向我提问，有问必答：https://t.zsxq.com/05JImq37u

环境描述

操作系统：CentOS 6.5
Hadoop：Apache Hadoop 2.7.7
MySQL： 5.6.36
Hive: 2.3.7

问题现象

环境中部署好 MySQL，并修改 hive-site.xml 将 metastore database 设置为 MySQL 后，启动 metastore 报错：

[deploy@master apache-hive-2.3.7-bin]$ hive --service metastore
2020-08-31 16:42:07: Starting Hive Metastore Server
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/data/software/apache-hive-2.3.7-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/data/software/hadoop-2.7.7/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]
MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:83)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:92)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6896)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6891)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:7149)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:7076)
        at sun.r

最低0.47元/天解锁文章