Hive部署到IDEA报错 Hive Schema version 2.1.0 does not match metastore's schema version 1.2.0 Metastore is not upgraded or corrupt 解决方案

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)

主要原因是版本不匹配

解决方案:

1、修改hive元数据版本信息

登陆mysql，修改hive metastore版本：
进行mysql：mysql -uroot -p （root）

use hive;
select * from version;
update VERSION set SCHEMA_VERSION='2.1.0' where  VER_ID=1;

 

2、 简单粗暴：在hvie-site.xml中关闭版本验证

<property>
    <name>hive.metastore.schema.verification</name>
    <value>false</value>
</property>

成功解决问题!

参考博客:https://blog.csdn.net/qq_27882063/article/details/79886935