hive实例化schema报错： Failed to get schema version.

最新推荐文章于 2024-08-16 09:41:30 发布

Toroidals

最新推荐文章于 2024-08-16 09:41:30 发布

阅读量1.4w

点赞数 7

分类专栏：大数据组件安装部署教程文章标签： hive schema version Failed

本文链接：https://blog.csdn.net/QYmufeng/article/details/86714092

版权

大数据组件安装部署教程专栏收录该内容

37 篇文章 99 订阅 ¥19.90 ¥99.00

订阅专栏

超级会员免费看

本文介绍了在尝试实例化Hive schema时遇到的错误：Failed to get schema version。问题根源在于hive-site.xml配置文件中，javax.jdo.option.ConnectionURL等属性未正确设置为个人的数据库连接信息。解决方案包括更新配置文件，确保URL、用户名、密码与实际数据库匹配，并在必要时调整MySQL的权限设置，授权hive用户远程访问。

摘要由CSDN通过智能技术生成

具体报错：

Metastore connection URL:     jdbc:mysql://hm02:3306/hive?createDatabaseIfNotExist=true
Metastore Connection Driver :     com.mysql.cj.jdbc.Driver
Metastore connection User:     hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: com.mysql.cj.jdbc.exceptions.CommunicationsException : Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
SQL Error code: 0
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

了解本专栏