使用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.