Connect to CDP DataHub Hive using Cloudera ODBC Driver

[#1]

JDBC/ODBC Drivers for Hive can be downloaded from Cloudera website.

The first thing we need to collect is the Hive Endpoint from Cloudera Management console. This can be found at the bottom of in the specific DataHub window. It will be in the following format:

jdbc:hive2://datahub1-master0.geo-1035.lskx-pvue.a4.cloudera.site/;ssl=true;transportMode=http;httpPath=datahub1/cdp-proxy-api/hive

Majorly we need to furnish the following information in the appropriate fields:

1. Host(s) : datahub1-master0.geo-1035.lskx-pvue.a4.cloudera.site
2. Port : 443
3. Authentication Mechanism : Username/Password
4. Thrift Transport : HTTP
5. Go to HTTP Options : 
    HTTP Path : datahub1/cdp-proxy-api/hive  (you will get this info from the Hive Endpoint)
   
   
6. Go to SSL Options:
   
   6.1. Check Enable SSL
   6.2. Check Allow Self-signed Server Certificate check box
   6.3. Trusted Certificates: Select the path to the PEM file containing the root ca cert of the Knox gateway.
   
   Note: You can download the TLS Public Certificate from Data Hub > Token Integration > TLS Public Certificate > Download the PEM file.

Save and Test Connection.