Overview

The Hive Execute Snap in the Hive Snap Pack require a Cloudera instance to access the Hive database. For the Generic Hive Datbase account to authorize successfully, ensure to create and configure an application corresponding to the account.

Prerequisites

• Valid Cloudera credentials.

• Clouder instance.

Locate Details in Cloudera

To validate your account in SnapLogic, you must have the following details:

• JDBC URL

• JDBC Driver Class

• Workload User name and password.

1. Log in to https://sso.cloudera.com/
   The Cloudera home page is displayed.

2. Click your Profile icon and select Cloudera Data Platform US West.
   

   

3. Under Data Management, click Management Console.
   

   

   
   

4. Click Data Hub Clusters. The list of hub clusters is displayed.

5. Click the Endpoints tab.

6. Copy or make note of the JDBC URL of the Hive Server to use it in the Generic Hive Database Account.
   

   

7. Click Snap Team and select Profile. Make note of the Workload credentials.
   

   

Configuring Generic Hive Database Account with Cloudera

1. Drag the Hive Execute Snap.

2. Add Generic Hive Database Account.

3. Enter the Username and Password of your Cloudera workload.

4. Enter the JDBC URL of the Hive Server.

   1. Enter the Site number as 443.

   2. 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.

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

   

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

   

Related Content: