Versions Compared

Old Version 9

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version 10

changes.mady.by.user Anand Vedam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  7. Click Validate. Your account should validate successfully.