5. JDBC

[Note]Note

Currently HDP 2 does not support encryption with JDBC. This section describes a feature that will be implemented in upcoming releases.

Recently HiveServer2 implemented encryption with the Java SASL protocol's quality of protection (QOP) setting. Using this the data moving between a HiveServer2 over JDBC and a JDBC client can be encrypted. On the HiveServer2, set the hive.server2.thrift.sasl.qop property in hive-site.xml, and on the JDBC client specify sasl.sop as part of the JDBC-Hive connection string, for example jdbc:hive://hostname/dbname;sasl.qop=auth-int. See HIVE-4911 for more details on this enhancement.