Closed gitava closed 4 years ago
https://blog.csdn.net/u012922838/article/details/73291524
二、解决方法 根据告警提示有两种解决方法:
1.设置useSSL=false 这里有个坑就是hive的配置文件是.XML格式,而在xml文件中&;才表示&,所以正确的做法是在Hive的配置文件中,如hive-site.xml进行如下设置
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
2.设置useSSL = true并为服务器证书验证提供信任库。
server version
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.33.102:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>
<description>
JDBC connect string for a JDBC metastore.
To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
</description>
</property>
issue solved!!
whenever to run hive commands, the following annoying inof showed up...