Hive部署到IDEA报错 Hive Schema version 2.1.0 does not match metastore's schema version 1.2.0 Metasto

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部署到IDEA报错 Hive Schema version 2.1.0 does not match metastore's schema version 1.2.0 Metasto

主要原因是版本不匹配

解决方案:

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

 

上一篇:软件测试方法分类


下一篇:软件测试常见术语(英->汉)收藏好随时备用!