Community Articles

Find and share helpful community-sourced technical articles.
avatar
Master Collaborator

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.

649 Views
0 Kudos