Caused by: MetaException(message:Hive Schema version 2.1.0 does not match metastore's schema version
来源:互联网 发布:金融职位人数 知乎 编辑:程序博客网 时间:2024/06/06 08:34
问题原因:
从hive1.2升级到hive-2.0.0 时没有问题。现在升级到hive-2.1.1之后,元数据就不匹配了。
解决:
(1)删除HDFS上的hive数据与hive数据库 hadoop fs -rm -r -f /tmp/hive hadoop fs -rm -r -f /user/hive(2)删除MySQL上的hive的元数据信息 mysql -uroot -p drop database hive(3)初始化hive, 将mysql作为hive的元数据库 schematool -dbType mysql -initSchema
暂时解决了问题,重启hive之后问题依旧。
1.
删除mysql 下 ,hive数据库
mysql> flush privileges;
2.
删除HDFS下的hive元数据:
raini@biyuzhe:~$ hadoop fs -rm -r -f /user/hive/tmp/* (hive-site.xml的配置)
raini@biyuzhe:~$ hadoop fs -ls /user/hive/warehouse
Found 1 items
drwxrwxrwx - raini supergroup 0 2017-05-11 15:18 /user/hive/warehouse/anserchapp.db
raini@biyuzhe:~$ hadoop fs -rm -r -f /user/hive/warehouse/*
17/05/11 15:56:20 INFO fs.TrashPolicyDefault: Namenode trash configuration: Deletion interval = 0 minutes, Emptier interval = 0 minutes.
Deleted /user/hive/warehouse/anserchapp.db
3.
schematool -dbType mysql -initSchema
新问题:
metastore.HiveMetaException: Failed to get schema version.Underlying cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException : Table 'hive.VERSION' doesn't exist
解决:
...还在解决
0 0
- Caused by: MetaException(message:Hive Schema version 2.1.0 does not match metastore's schema version
- Hive-异常处理Hive Schema version 2.3.0 does not match metastore's schema version 1.2.0 Metastore is not
- Hive启动报错Caused by MetaException message Version information not found in metastore
- 启动hive2.1.1遇到的异常,Caused by: MetaException(message:Version information not found in metastore. )
- spark-sql之 Caused by: MetaException(message:Version information not found in metastore. )
- hive :MetaException(message:Version information not found in metastore. )
- spark MetaException(message:Version information not found in metastore. )
- 启动spark-sql报错Caused by: MetaException(message:Version information not found
- 「Hive元数据问题」hive.metastore.HiveMetaException: Failed to get schema version.
- 解决 Failed to get schema version when starting Hive Metastore Service
- org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
- request does not match component version
- MetaException(message:Hive metastore database is not initialized. Please use schematool (e.g. ./sch
- invalid application descriptor: descriptor version does not match runtime version
- kernel version 367.48. does not match DSO version 367.57
- ambari安装hive遭遇Failed to get schema version
- Do not specify version numbers in Spring schema references
- Java compiler level does not match the version
- 学习@浅墨_毛星云的【OpenCV入门教程】之四
- Zookeeper系列(十二)Zookeeper开源客户端之Curator的事件监听
- oracle 权限
- 手机卫士Day01
- java、scala集合自定义排序异常:Comparison method violates its general contract!
- Caused by: MetaException(message:Hive Schema version 2.1.0 does not match metastore's schema version
- linux---ps用法
- Python3中的map问题
- jquery 动态生成form提交数据的例子, 及其 form is not connected 错误解决
- 单点登录使用
- 归并排序的同时求逆序数
- linux-用户命令
- 手机卫士02
- elasticsearch5 源码 索引过程