Hive shell操作出现警告:
Thu Jun 06 21:08:22 CST 2019 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-2.3.5/conf目录下的hive-site.xml文件
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://slave01:3306/hive?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>