解决Hive的Establishing SSL connection without server's identity verification is not recommended问题

最新推荐文章于 2024-05-22 15:26:44 发布

原创最新推荐文章于 2024-05-22 15:26:44 发布 · 2.5k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#Hive #hive-site.xml #Establishing SSL

大数据同时被 3 个专栏收录

196 篇文章

订阅专栏

hadoop

36 篇文章

订阅专栏

Hive

9 篇文章

订阅专栏

本文解决了一个关于Hive连接MySQL时出现的SSL连接警告问题，通过修改hive-site.xml文件中的JDBC连接字符串，禁用了SSL验证，避免了因默认SSL连接设置导致的应用不兼容问题。

问题描述：

hive> Sat Oct 13 15:36:32 CST 2018 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.

解决方法：

修改~/hive/conf下的hive-site.xml文件，记住Master和slave节点上都要修改
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://Master:3306/hive?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>