Hive启动报错Caused by MetaException message Version information not found in metastore

最新推荐文章于 2024-07-18 11:02:29 发布
最新推荐文章于 2024-07-18 11:02:29 发布
阅读量1.4w 收藏 6
点赞数 5
分类专栏： Hive 文章标签： hive Versioninformation n Required table missi hive启动报错
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/NeverGiveup54/article/details/50612252
版权

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原因分析：

datanucleus.autoCreateSchema=true

表示在操作JDO API的时候对应的数据库表还没有创建的话会根据实体的元数据自动创建表

 

另外hive.metastore.schema.verification这个参数：

防止架构版本不兼容时的 Metastore 操作。考虑将此设置为“True”，以减少 Metastore 操作期间发生架构损坏的可能性

注意，将此属性设置为“True”，还会将 datanucleus.autoCreateSchema 属性设置为“False”

 




5解决方案：


修改CDH中hive的配置:

datanucleus.autoCreateSchema=true

datanucleus.metadata.validate=false

hive.metastore.schema.verification=false

 

如下图


修改完配置，重启hive服务问题解决。


 

金玉满堂5
关注
专栏目录
hive1.1 启动异常 ：Caused by: MetaException(message:Version information not found in metastore. )
行走的树
04-10 3836
配置完成Mysql存储元数据信息，启动异常：Caused by: MetaException(message:Version information not found in metastore.Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiat
spark-sql之 Caused by: MetaException(message:Version information not found in metastore. )
wqhlmark64的博客
09-12 1789
试着使用spark-sql访问hive表，启动后spark-sql  --driver-class-path /home/hadoop/bigdata/hive/lib/mysql-connector-java.jar 报如下错误： 17/09/12 16:47:44 INFO metastore.ObjectStore: Initialized ObjectStore 17/09/12 1
matestore服务报错：MetaException(message:Version information not found in metastore.)
weixin_63682399的博客
05-28 2176
环境描述 操作系统：CentOS 7 Hadoop：Apache Hadoop 2.7.3 MySQL：5.7.29 Hive:3.1.2 MetaException(message:Version information not found in metastore.) 问题分析 从 message:Version information not found in metastore 这句报错上可以看出是 metastore 库里面没有找到 Version 相关的信息 启动metastore报错 Meta
初始化hive元数据库报错org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
最新发布
qq_74956310的博客
07-18 361
我的 MySQL版本为8.0.26，第一次的驱动版本与之相同，后来换了多个版本直到8.3.0才解决问题，所以大家一定要选择与MySQL版本相适应的驱动版本，若第一次更换驱动版本没有解决，可以试着多更换几个版本。好了，分享就写到这，希望大家遇到问题切记不要慌，多多实践（不要怕麻烦，也许解决的方法就在下一次时间中），祝大家以后的学习之路一帆风顺！错误表明在使用JDBC连接数据库时，遇到了安全限制，无法从远程服务器获取公钥来进行加密通信。2、是否在hive-site.xml配置中关闭了SSL。
Hive 启动 MetaStore 报错：Version information not found in metastore
热门推荐
Stay hungry, stay foolish !
08-31 1万+
文章目录环境描述问题现象问题分析解决方案总结 环境描述 操作系统：CentOS 6.5 Hadoop：Apache Hadoop 2.7.7 MySQL： 5.6.36 问题现象 环境中部署好 MySQL，并修改 hive-site.xml 将 metastore database 设置为 MySQL 后，启动 metastore 报错： [deploy@master apache-hive-2.3.7-bin]$ hive --service metastore 2020-08-31 16:42:0
Hive--MetaException(message:Version information not found in metastore.)
Oligizzz
07-14 3000
报错： MetaException(message:Version information not found in metastore.) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:84) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java
hive Caused by: MetaException(message:Version information not found in metastore. )解决方法
anzhenxi3529的博客
03-16 2615
Logging initialized using configuration in jar:file:/D:/hive/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar!/hive-log4j.properties SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found bi...
spark MetaException(message:Version information not found in metastore. )
bitcarmanlee的博客
07-25 7185
尝试将spark与hive结合起来。将相关配置完毕以后，启动spark-sql的过程中，出现了以下错误：16/07/25 17:19:08 WARN metadata.Hive: Failed to access metastore. This class should not accessed in runtime. org.apache.hadoop.hive.ql.metadata.HiveE
启动spark-sql报错Caused by: MetaException(message:Version information not found
wqhlmark64的博客
09-13 3685
集群中已部署且正常使用了hadoop, hive, spark。打算启动spark-sql来访问hive数据时报错， WARN metadata.Hive: Failed to access metastore. This class should not accessed in runtime. org.apache.hadoop.hive.ql.metadata.HiveExcep
caused by metaexpection message version information not found in metastore
05-13
这个错误通常是由于你的 Hadoop 集群版本与你的 Hive 版本不兼容所导致的。你需要检查你的 Hadoop 和 Hive 的版本是否匹配。如果版本不匹配，则需要升级或降级其中一个组件以使它们匹配。另外，你还需要检查你的 ...
大数据-hadoop-Hive启动报错（2019-06-01）
Genebrother
06-01 1013
关于大数据学习的最好的网站就是官网http://www.apache.org/ 参考资料：http://www.apache.org/ 免责声明：很多资料都是网上一步步搜集到的，感谢各位前辈默默无闻的奉献与付出，资料过多，不一一感谢，如果侵权，请及时联系作者本人或者投诉至平台，我会第一时间删除，纯分享。 关于hive的启动报错，一开始我们会遇到很多的问题，慢慢的遇到多了，就可...
hive启动message:Version information not found in metastore.
weixin_52597250的博客
01-06 1220
我按照视频跟着一步一步操作，人家就可以直接通过，我就报错了。出现上面这个错误，我不是很理解，误人子弟呢这不。 我也确定我敲得没有问题 然后换了个视频看，他有一个步骤是初始化 schematool -initSchema -dbType mysql 所有配置完成之后运行此行代码 我的电脑还是报错HiveSchemaTool:Parsing failed. Reason: Unrecognized option: -dbtype 说找不到数据库 我依然很确定我安装了，status也是运行状态 继续
Hive 2.3.0 MetaException(message:Version information not found in metastore. )
大雄没有叮当猫的博客
08-27 3551
使用Hive 2.3.0 配置远程模式（Remote）时，执行hive --service metastore命令时出现MetaException(message:Version information not found in metastore. )错误。 解决办法： The necessary tables required for the metastore are missing i...
Sqoop Hive Caused by: MetaException(message:Version information not found in metastore.)
m0_68415041的博客
02-19 593
Sqoop Hive Caused by: MetaException(message:Version information not found in metastore.)
hive ：MetaException(message:Version information not found in metastore. )
小桥
11-03 3049
hive ：MetaException(message:Version information not found in metastore. ) MetaException(message:Version information not found in metastore. ) Hive now records the schema version in the metas
windows平台 Hive启动报错Caused by MetaException message Version information not found in metastore
Harvay的博客
09-30 885
硬件配置：  hive版本为 v2.1.0 windows平台使用window server 2008 R2 数据库为mysql数据库； 问题分析 ： hive启动在需要mysql中存在scheme 表格结构，而mysql数据库中不存在导致异常。 解决办法： hive启动之后需要首先在mysql数据库中创建必要的表格信息，所以在linux平台需要首先做 schematool --db...
报错：MetaException(message:Version information not found in metastore. )
weixin_30216561的博客
05-08 1146
报错背景： CDH安装完成hive后启动失败。 报错现象： [main]: Metastore Thrift Server threw an exception... MetaException(message:Version information not found in metastore. ) at org.apache.hadoop.hive.metastore...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值