Versions Compared

Old Version 6

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version Current

changes.mady.by.user Kalpana Malladi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

[RN Update]: The Hive Snap Pack is certified with the Cloudera Data Warehouse (CDW). You can use the Hive Execute Snap to work with CDW clusters, through a Generic Hive Database account.

Overview

The Hive Snap Pack supports Cloudera Data Platform (CDP) to connect to the Cloud Data Warehouse (CDW). Using the Workload user's credentials, you can use a Generic Hive Database Account to connect to the Hive database service running on CDP’s Data Warehouse

Prerequisites

  • Valid Cloudera Workload user’s credentials.

  • Cloudera instance.

Info

This article provides details, for an existing Data Warehouse in the CDP.

Locate Details in the Cloudera Data Platform

To validate your Generic Hive Database account in the SnapLogic platform to use the CDW on the CDP, you must have the following details:

...

  1. Log in to the CDP portal (https://sso.cloudera.com) or register yourself if you do not have an account.
    The MyCloudera home page opens.

  2. Click your Profile icon and select the Cloudera Data Platform. For example, Cloudera Data Platform US West. You are redirected to the Cloudera Data Platform page.
    Note: We are using Cloudera Data Platform US West to demonstrate the procedure of accessing details from the CDW.

  3. Under Data Services, click the Data Warehouse card.

  4. Click the Tic-tac-toe icon and select Data Warehouse.

    Image Removedsnaplogic-cdw.pngImage Added

  5. The active CDWs are displayed.

    Image Removedvirtual-cdw.pngImage Added

  6. Navigate to User Management in the left navigation pane, click the <user>, select Profile, and note the Workload credentials.

    Image RemovedImage Added

Configuring a Generic Hive Database Account with Settings from the CDW

  1. Drag the Hive Execute Snap.

  2. Add the Generic Hive Database account to the Snap.

  3. Enter the Username and Password of your Cloudera Workload instance. (Refer to Step 6 above.)

  4. Enter the JDBC URL of the Hive Server.

    1. Click the Ellipsis on the CDW and select Copy JDBC URL.

    2. Enter the port number right after the domain and update the SSL value from true to 1, wherein 0 is false and 1 is true.

    3. Enter the Site number as 443.

    4. If the SSL is enabled on the Hive server, leave SSL as true. If the SSL is not enabled on the server, enter SSL as 0 or 1.
      For example, jdbc:hive2://<cdw-datahub-cluster-host>:443/;ssl=1;transportMode=http;httpPath=data-hub-cluster-1/cdw-proxy-api/hive

  5. Upload the Hive driver in the JDBC Driver field. You can download the latest JDBC Hive driver from here.

  6. Specify the JDBC Driver Class as com.cloudera.hive.jdbc.HS2Driver.

    Image Removedgeneric-hive-database-account-cdw.pngImage Added

  7. Click Validate. Your account should validate successfully.