美文网首页
HIVE使用PG(postgreSQL)做元数据启动异常解决

HIVE使用PG(postgreSQL)做元数据启动异常解决

作者: Anan9527 | 来源:发表于2018-08-09 11:14 被阅读0次
    上午10点58:39.292分 WARN    Query   
    [main]: Query for candidates of org.apache.hadoop.hive.metastore.model.MVersionTable and subclasses resulted in no possible candidates
    Required table missing : ""VERSION"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
    org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : ""VERSION"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
        at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:485)
        at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3380)
    ...
    上午10点55:18.670分 ERROR   HiveMetaStore   
    [main]: MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7276)
        at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7252)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    

    解决方案:

    1.将datanucleus.autoCreateSchema 改为true
    2.将hive.metastore.schema.verification 改为 flash
    
    image.png

    相关文章

      网友评论

          本文标题:HIVE使用PG(postgreSQL)做元数据启动异常解决

          本文链接:https://www.haomeiwen.com/subject/lxeqbftx.html