Encrypt Hive JDBC and Hive Server traffic

Question

Hi. I have set up Hive server and JDBC and have made connections between these two. The data between the JDBC and Hive server are not encrypted. I want to encrypt it to maintain data integrity. How can I encrypt it?

Answer 1

You can enable encryption of data flowing between Hive JDBC and Hive server by adding the following property in the hive-site.xml file:

<property>
<name>hive.server2.thrift.sasl.qop</name>
<value>auth-conf</value>
<description>Sasl QOP value; one of 'auth', 'auth-int' and 'auth-conf'</description>
</property>