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, dq-docs.collibra.com will remain accessible, but the DQ User Guide is now maintained exclusively in the Documentation Center.
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]
com.simba.hive.jdbc41.HS2Driver
hive.resultset.use.unique.column.names=false
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]
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.
hive.resultset.use.unique.column.names=false
Last modified 4mo ago