hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version, Cause:Table 'metastore.VERSION' doesn't exist
时间: 2023-12-26 21:28:47 浏览: 262
出现这个问题是因为Hive在验证时无法找到'metastore.VERSION'表。解决方法是删除数据库'metastore',然后使用当前集群系统的schematool工具重新创建该数据库。同时,需要修改配置文件'/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hive/conf/hive-site.xml',添加相应的内容。
以下是解决方法的步骤:
1. 删除'metastore'数据库。
2. 使用schematool工具重新创建'metastore'数据库。
3. 修改配置文件'/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hive/conf/hive-site.xml',添加以下内容:
```xml
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
<description>Whether to verify the schema version of the metastore database.
Hive stores the schema version in a table in the metastore database and verifies it when opening a metastore connection.
If the schema versions don't match, Hive refuses to open the metastore.
This property disables the schema version check, but should only be used if the schema can be upgraded by another instance of Hive that shares the same metastore database.
Otherwise, there is a risk of metadata corruption and data loss.
</description>
</property>
```
请注意,以上步骤是解决'metastore.VERSION'表不存在问题的常见方法。如果问题仍然存在,请提供更多详细信息以便进一步帮助。
阅读全文