Hive 2.3.0 MetaException(message:Version information not found in metastore. )

本文主要是介绍Hive 2.3.0 MetaException(message:Version information not found in metastore. )，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

使用Hive 2.3.0 配置远程模式（Remote）时，执行hive --service metastore命令时出现MetaException(message:Version information not found in metastore. )错误。

解决办法：

The necessary tables required for the metastore are missing in MySQL. Manually create the tables and restart hive metastore.

The schema files for MySQL will be available under the path $HIVE_HOME/scripts/metastore/upgrade/mysql/.

cd $HIVE_HOME/scripts/metastore/upgrade/mysql/< Login into MySQL >mysql> drop database IF EXISTS hive;
mysql> create database hive;
mysql> use hive;
mysql> source hive-schema-2.1.1.mysql.sql;

Restart Hive metastore.

这篇关于Hive 2.3.0 MetaException(message:Version information not found in metastore. )的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---