Hive 2.1.1 MetaException（消息：在Metastore中未找到版本信息。） [英] Hive 2.1.1 MetaException(message:Version information not found in metastore. )
本文介绍了Hive 2.1.1 MetaException（消息：在Metastore中未找到版本信息。）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在Ubuntu 16.04上运行Hadoop 2.7.3，MySQL 5.7.17和Hive 2.1.1。
当我运行./hive时，以下警告和异常：
SLF4J：类路径包含多个SLF4J绑定。
SLF4J：在[jar：file：/home/server/hive/lib/log4j-slf4j-impl-2.4.1.jar！/org/slf4j/impl/StaticLoggerBinder.class]中找到绑定
SLF4J：在[jar：file：/home/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar！/org/slf4j/impl/StaticLoggerBinder.class]中找到绑定
SLF4J：请参阅http://www.slf4j.org/codes.html#multiple_bindings以获取解释。
SLF4J：实际绑定类型为[org.apache.logging.slf4j.Log4jLoggerFactory]
使用jar中的配置初始化日志：file：/ home / server / hive / lib / hive- common-2.1.1.jar！/hive-log4j2.properties Async：true
2017年2月13日星期二12:01:41 WARN：建议不建议使用服务器身份验证建立SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:41 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:41 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:41 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:42 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:42 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:42 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
Mon Feb 13 12:01:42 EST 2017 WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。
线程main中的异常java.lang.RuntimeException：org.apache.hadoop.hive.ql.metadata.HiveException：java.lang.RuntimeException：无法实例化org.apache.hadoop.hive.ql.metadata .SessionHiveMetaStoreClient
at org.apache.hadoop.hive.ql.session.SessionState.start（SessionState.java:591）
at org.apache.hadoop.hive.ql.session.SessionState.beginStart（ SessionState.java:531）
at org.apache.hadoop.hive.cli.CliDriver.run（CliDriver.java:705）
at org.apache.hadoop.hive.cli.CliDriver.main（在sun.reflect.NativeMethodAccessorImpl.invoke CliDriver.java:641）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本机方法）
（NativeMethodAccessorImpl.java:62）
。在sun.reflect。 DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method.java:498）
at org.apache.hadoop.util.RunJar.run（RunJar。 java：221）
在org.apache.hadoop.util.RunJar.main（RunJar.java:136）
导致：org.apache.hadoop.hive.ql.metadata.HiveException：java.lang.RuntimeException：无法在org.apache实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
。 hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce（Hive.java:226）
at org.apache.hadoop.hive.ql.metadata.Hive。< init>（Hive.java:366）
at org.apache.hadoop.hive.ql.metadata.Hive.create（Hive.java:310）
at org.apache.hadoop.hive.ql.metadata.Hive.getInternal（Hive.java： 290）
at org.apache.hadoop.hive.ql.metadata.Hive.get（Hive.java:266）
at org.apache.hadoop.hive.ql.session.SessionState.start（ SessionState.java:558）
... 9 more
导致：java.lang.RuntimeException：无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
at org .apache.hadoop.hive.metastore.MetaStoreUtils.newInstance（MetaStoreUtils.java:1654）
位于org.apache.hadoop.hive.metastore.RetryingMetaStoreClient。< init>（RetryingMeta StoreClient.java:80）
在org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy（RetryingMetaStoreClient.java:130）
在org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy（ RetryingMetaStoreClient.java:101）
位于org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient（Hive.java:3367）
位于org.apache.hadoop.hive.ql.metadata。 Hive.getMSC（Hive.java:3406）
位于org.apache.hadoop.hive.ql.metadata.Hive.getMSC（Hive.java:3386）
位于org.apache.hadoop.hive。在org.apache上
在org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions（Hive.java:236）上
。 hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce（Hive.java:221）
... 14 more
导致：java.lang.reflect.InvocationTargetException $ b $ sun.reflect。 NativeConstructorAccessorImpl.newInstance0（本地方法）
at sun.reflect.NativeConstructorAccessorImpl.newInstance（NativeConstructorAccessorIm
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance（DelegatingConstructorAccessorImpl.java:45）
at java.lang.reflect.Constructor.newInstance（Constructor.java:423）
在org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance（MetaStoreUtils.java:1652）
... 23 more
引起：MetaException（消息：在Metastore中找不到版本信息。 ）
at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema（ObjectStore.java:7753）
at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema（ObjectStore.java:7731 ）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本机方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）
在sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl .java：43）
at java.lang.reflect.Method.invoke（Method.java:498）
at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke（RawStoreProxy.java:101 ）
at com.sun.proxy $ Proxy21.verifySchema（Unknown Source）
at org.apache.hadoop.hive.metastore.HiveMetaStore $ HMSHandler.getMS（HiveMetaStore.java:565）
。在org.apache.hadoop.hive.metastore.HiveMetaStore $ HMSHandler.createDefaultDB（HiveMetaStore.java:626）
在org.apache.hadoop.hive.metastore.HiveMetaStore $ HMSHandler.init（HiveMetaStore.java:416 ）在org.apache.hadoop
.hive.metastore.RetryingHMSHandler<初始化>（RetryingHMSHandler.java:78）
。在org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy（RetryingHMSHandler.java:84）
。在有机apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler（HiveMetaStore.java:6490）LT
。在org.apache.hadoop.hive.metastore.HiveMetaStoreClient&;初始化>（HiveMetaStoreClient.java:238）
< init>（SessionHiveMetaStoreClient.java:70）
... 28 more
这是我的hive-site.xml
<？xml version =1.0encoding =UTF-8standalone =no？>
<？xml-stylesheet type =text / xslhref =configuration.xsl？>
<配置>
<属性>
< name> javax.jdo.option.ConnectionURL< / name>
< value> jdbc：mysql：// localhost：3306 / hive？createDatabaseIfNotExist = true< / value>
< / property>
<属性>
< name> javax.jdo.option.ConnectionDriverName< / name>
<值> com.mysql.jdbc.Driver< /值>
< / property>
<属性>
< name> javax.jdo.option.ConnectionUserName< / name>
< value>配置单元< /值>
< / property>
<属性>
< name> javax.jdo.option.ConnectionPassword< / name>
<值>密码< /值>
< / property>
< / configuration>
为了解决这个错误，我尝试了 / hive-unable-to-instantiate-org-apache-hadoop-hive-ql-metadata-sessionhivemetasto> Hive无法实例化org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient 和无法实例化org.apache .hadoop.hive.ql.metadata.SessionHiveMetaStoreClient 。但我仍然得到相同的例外。
我是Hadoop和Hive的新手，我该如何修复异常？
谢谢！
解决方案
MySQL中缺少必要的Metastore表。手动创建表并重新启动配置单元Metastore。
MySQL的模式文件将在路径 $ HIVE_HOME / scripts / metastore / upgrade / mysql / 。
cd $ HIVE_HOME / scripts / metastore / upgrade / mysql /
< b<登录到MySQL>
mysql> drop database IF EXISTS hive;
mysql>创建数据库配置单元;
mysql>使用配置单元;
mysql> source hive-schema-2.1.1.mysql.sql;
重新启动Hive Metastore。
I'm running Hadoop 2.7.3, MySQL 5.7.17 and Hive 2.1.1 on Ubuntu 16.04.
When I run ./hive, I keep getting the following warning and exception:
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/server/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Logging initialized using configuration in jar:file:/home/server/hive/lib/hive-common-2.1.1.jar!/hive-log4j2.properties Async: true
Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:41 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Feb 13 12:01:42 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:591)
at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:531)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:705)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:226)
at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:366)
at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:310)
at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:290)
at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:266)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:558)
... 9 more
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:1654)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3367)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3406)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3386)
at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3640)
at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:236)
at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:221)
... 14 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1652)
... 23 more
Caused by: MetaException(message:Version information not found in metastore. )
at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7753)
at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7731)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)
at com.sun.proxy.$Proxy21.verifySchema(Unknown Source)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:565)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:626)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6490)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:238)
at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70)
... 28 more
Here is my hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>password</value>
</property>
</configuration>
In order to fix the error, I've tried Hive Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient and Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient. But I am still getting the same exceptions.
I'm newbie to Hadoop and Hive, how could I fix the exception? Thanks!
解决方案
The necessary tables required for the metastore are missing in MySQL. Manually create the tables and restart hive metastore.
The schema files for MySQL will be available under the path $HIVE_HOME/scripts/metastore/upgrade/mysql/.
cd $HIVE_HOME/scripts/metastore/upgrade/mysql/
< Login into MySQL >
mysql> drop database IF EXISTS hive;
mysql> create database hive;
mysql> use hive;
mysql> source hive-schema-2.1.1.mysql.sql;
Restart Hive metastore.
这篇关于Hive 2.1.1 MetaException（消息：在Metastore中未找到版本信息。）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
