启动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

Logo

开放原子开发者工作坊旨在鼓励更多人参与开源活动,与志同道合的开发者们相互交流开发经验、分享开发心得、获取前沿技术趋势。工作坊有多种形式的开发者活动,如meetup、训练营等,主打技术交流,干货满满,真诚地邀请各位开发者共同参与!

更多推荐