Shulou(Shulou.com)06/01 Report--

This article mainly shows you the "start hive command error" Metastore contains multiple versions "how to do", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "start hive command error" Metastore contains multiple versions "how to do" this article.

Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.hive.ql.session.SessionState.start (SessionState.java:444) at org.apache.hadoop.hive.cli.CliDriver.run (CliDriver.java:672) at org.apache.hadoop.hive.cli.CliDriver.main (CliDriver.java:616) at sun.reflect. NativeMethodAccessorImpl.invoke0 (NativeMethod) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:57) at sun.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) Caused by: java.lang.RuntimeException: Unable to instantiate org. Apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance (MetaStoreUtils.java:1449) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient. (RetryingMetaStoreClient.java:63) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy (RetryingMetaStoreClient.java:73) at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient (Hive.java:2661) at org.apache.hadoop.hive.ql.metadata.Hive .getMSC (Hive.java:2680) at org.apache.hadoop.hive.ql.session.SessionState.start (SessionState.java:425)... 8 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance (Constructor.java:526) At org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance (MetaStoreUtils.java:1447)... 13 more Caused by: MetaException (message:Metastore contains multiple versions) at org.apache.hadoop.hive.metastore.ObjectStore.getMSchemaVersion (ObjectStore.java:6643) at org.apache.hadoop.hive.metastore.ObjectStore.getMetaStoreSchemaVersion (ObjectStore.java:6605) at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema (ObjectStore.java:6564) at org.apache.hadoop. Hive.metastore.ObjectStore.verifySchema (ObjectStore.java:6552) at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethod) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke (Method.java:606) at org.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:539) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB (HiveMetaStore.java:587) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init (HiveMetaStore.java:429) at org.apache.hadoop.hive.metastore.RetryingHMSHandler. (RetryingHMSHandler.java:66) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy (RetryingHMSHandler.java:72) at org.apache .hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler (HiveMetaStore.java:5554) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient. (HiveMetaStoreClient.java:178) at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient. (SessionHiveMetaStoreClient.java:73). 18 more123456789101112131415161718192021222324252627282930313233343536373839404142434445 solution:

Because hive metastore is stored in mysql, log in to the DB used by mysql,use hive, and then query the following VERSION table

Mysql > select * from VERSION

+-- +

| | VER_ID | SCHEMA_VERSION | VERSION_COMMENT | |

+-- +

| | 1 | 0.14.0 | Set by MetaStore |

| | 2 | 0.14.0 | Set by MetaStore |

| | 3 | 0.14.0 | Set by MetaStore |

| | 4 | 0.14.0 | Set by MetaStore |

| | 5 | 0.14.0 | Set by MetaStore |

| | 6 | 0.14.0 | Set by MetaStore |

+-- +

Keep the first record and delete all other records

Delete from VERSION where VER_ID! = 1 1 causes this kind of abnormal problem

Hive does not support concurrency. It is estimated that my colleague accidentally started multiple hive. It may also be a network problem. Anyway, it is very weird.

The above is all the contents of the article "start the hive command to report an error" Metastore contains multiple versions "what to do". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.