解决 message:Hive Schema version 2.1.0 does not match metastore's schema version 1.2.0

2019独角兽企业重金招聘Python工程师标准>>>

hive启动时遇到问题

Caused by: MetaException(message:Hive Schema version 2.1.0 does not match metastore's schema version 1.2.0 Metastore is not upgraded or corrupt)

解决办法：

$HIVE_HOME/scripts/metastore/upgrade/mysql 路径下提供了一些sql脚本执行升级，

mysql -uroot -p

mysql> use hive;
Database changed
mysql> source upgrade-1.2.0-to-2.0.0.mysql.sql
mysql> source upgrade-2.0.0-to-2.1.0.mysql.sql

重新启动hive即可。

转载于:https://my.oschina.net/u/1447519/blog/1551117