解决Hive启动后报错FAILED:HiveException java.lang.RuntimeException

启动hive后，在“hive>”输入“show databases；”报错：

FAILED:HiveException java.lang.RuntimeException： Unable to instantiate org.apache...

 搜索解决办法发现是要开启元数据：

hive --service metastore 

开启时报错：

 搜索解决办法发现要修改hive-site.xml的配置：

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

再次试图开启元数据：

hive --service metastore 

出现新的报错

MetaException(message:Required table missing : “DBS” in Catalog “” Schema “”. DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable “datanucleus.schema.autoCreateTables”)：

 搜索解决办法发现还要修改hive-site.xml的配置： 

<property>
    <name>datanucleus.schema.autoCreateAll</name>
    <value>true</value>
 </property>

再次修改配置后终于能开启元数据了：

hive --service metastore 

输入“show databases;”试试看：

解决！🐾

参考来源：

FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.me_Not_writer的博客-CSDN博客FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.mehttps://blog.csdn.net/Not_writer/article/details/124361416Hive--MetaException(message:Version information not found in metastore.) - it610.com报错：MetaException(message:Versioninformationnotfoundinmetastore.)atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:84)atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.https://www.it610.com/article/1297491623684415488.htmHive--MetaException(message:Required table missing : “`DBS`“ in Catalog ““ Schema ““. DataNucleus re_Erase Me的博客-CSDN博客在开启Hive-metastore的时候报错：MetaException(message:Required table missing : “DBS” in Catalog “” Schema “”. DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable “datanucleus.schema.autoCrhttps://blog.csdn.net/qq_44957186/article/details/107336023