The Cloudera Hive JDBC drivers used https://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-16.html
jdbc:hive2://cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal:10000/default;AuthMech=1;KrbHostFQDN=cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal;KrbRealm=CW.COM;KrbServiceName=hive;SSL=1;SSLKeyStore=/opt/cloudera/security/pki/cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal-server.jks;AllowSelfSignedCerts=1;SSLKeyStorePwd=password;principal=hive/[email protected]
Base connection string = jdbc:hive2://cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal:10000/default
Authentication identifier = AuthMech=1 (which states Kerberos)
Kerberos Hive Server FQDN = KrbHostFQDN=cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal
Kerberos Realm used = KrbRealm=CW.COM (Not necessarily needed)
Kerberos Service name = KrbServiceName=hive
Enabling SSL = SSL=1
The SSL KeyStore to be used to = SSLKeyStore=/opt/cloudera/security/pki/cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal-server.jks (Could use SSLTrustStore also)
Allow for Self Signed certifications to be OK = AllowSelfSignedCerts=1 (our environment used self signed certs)
Password to the KeyStore = SSLKeyStorePwd=password (Not necessarily needed)
Kerberos Principal to use to Authenticate with = principal=hive/[email protected]
Name = hivessl
Connection URL = jdbc:hive2://cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal:10000/default;AuthMech=1;KrbHostFQDN=cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal;KrbRealm=CW.COM;KrbServiceName=hive;SSL=1;SSLKeyStore=/opt/cloudera/security/pki/cdh-instance1.us-east1-b.c.owl-hadoop-cdh.internal-server.jks;AllowSelfSignedCerts=1;SSLKeyStorePwd=password;principal=hive/[email protected]
Port = 10000
Driver Name = com.cloudera.hive.jdbc4.HS2Driver
Username = [email protected]
Password = password