Collibra DQ User Guide

Connectivity to Hive

We've moved! To improve customer experience, the Collibra Data Quality User Guide has moved to the Collibra Documentation Center as part of the Collibra Data Quality 2022.11 release. To ensure a seamless transition, will remain accessible, but the DQ User Guide is now maintained exclusively in the Documentation Center.

Example URL

jdbc:hive2://;AuthMech=1;;KrbRealm=CW.COM;KrbServiceName=hive;SSL=1;SSLKeyStore=/opt/cloudera/security/pki/;AllowSelfSignedCerts=1;SSLKeyStorePwd=password;principal=hive/[email protected]

Driver Name


Driver Properties


What Does each option mean

Base connection string = jdbc:hive2://
Authentication identifier = AuthMech=1 (which states Kerberos)
Kerberos Hive Server FQDN =
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/ (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]

Example Connection


It is very common to require this connection property when not using the default schema. Remember to add this to the connection properties when defining the connection.