Hive启动报错Caused by MetaException message Version information not found in metastore_caused by: metaexception(message:version informati

1.问题错误：

Caused by: MetaException(message:Versioninformation not found in metastore. )

或

Caused by: javax.jdo.JDODataStoreException:Required table missing : "`VERSION`" in Catalog "" Schema"". DataNucleus requires this table to perform its persistenceoperations. Either your MetaData is incorrect, or you need to enable"datanucleus.autoCreateTables"

2.前置条件：

3.问题重现:

[root@h1 hive]# tail -100fhadoop-cmf-hive-HIVEMETASTORE-h1.log.out
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)
       at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
       at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
2016-01-30 16:28:06,951 INFO  org.apache.hadoop.hive.metastore.HiveMetaStore:[Thread-3]: Shutting down hive metastore.
2016-01-30 16:31:13,929 WARN  DataNucleus.Query: [main]: Query forcandidates of org.apache.hadoop.hive.metastore.model.MVersionTable andsubclasses resulted in no possible candidates
Required table missing :"`VERSION`" in Catalog "" Schema "". DataNucleusrequires this table to perform its persistence operations. Either your MetaDatais 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 persistenceoperations. Either your MetaData is incorrect, or you need to enable"datanucleus.autoCreateTables"
       at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:485)
       atorg.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3380)
       at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190)
       atorg.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841)
       atorg.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)
       atorg.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605)
       at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954)
       atorg.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679)
       atorg.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:408)
       atorg.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:947)
       atorg.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:370)
       at org.datanucleus.store.query.Query.executeQuery(Query.java:1744)
       at org.datanucleus.store.query.Query.executeWithArray(Query.java:1672)
       at org.datanucleus.store.query.Query.execute(Query.java:1654)
       at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:221)
       at org.apache.hadoop.hive.metastore.ObjectStore.getMSchemaVersion(ObjectStore.java:6957)
       atorg.apache.hadoop.hive.metastore.ObjectStore.getMetaStoreSchemaVersion(ObjectStore.java:6941)
       at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6899)
       atorg.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6883)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)
       atorg.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:98)
        atcom.sun.proxy.$Proxy5.verifySchema(Unknown Source)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:575)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:623)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:464)
       atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
       at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5775)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5770)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6022)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5947)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)
       at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
       at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
2016-01-30 16:31:13,958 ERRORorg.apache.hadoop.hive.metastore.HiveMetaStore: [main]:MetaException(message:Version information not found in metastore. )
       atorg.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6902)
       atorg.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6883)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)
       atorg.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:98)
       at com.sun.proxy.$Proxy5.verifySchema(Unknown Source)
       at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:575)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:623)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:464)
       atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
       atorg.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
       at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5775)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5770)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6022)
       atorg.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5947)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)
       at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
       at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

4原因分析：

5解决方案：