Creating a CML data connection to a Hive data warehouse

Learn how to connect natively to data stored in Hive when using Data Visualization in Cloudera Machine Learning (CML).

Before you start using data modeling and visualization functions, you must connect to your data. The following steps show you how to create a new CML data connection in Cloudera Data Visualization (CDV) to a Hive data warehouse.

When you create a connection, you automatically get privileges to create and manage the associated datasets. You can also build dashboards and visuals within these datasets.

  • For more information on the Manage data connections privilege, see RBAC permissions.
  • For instructions on how to define privileges for a specific role, see Setting role privileges.
  • For instructions on how to assign the administrator role to a user, see Promoting a user to administrator.
If you are using a CDP Base cluster running Hive with Kerberos for authentication, make sure that Kerberos credentials are configured in CML before creating a CML data connection to the Hive data warehouse. This ensures seamless integration and authentication between CDV and the Hive cluster. If you add Kerberos credentials after launching the CDV app, you need to restart the app for the changes to take effect.
  1. On the main navigation bar, click DATA.
    The DATA opens, displaying the Datasets tab.
  2. On the side menu bar, click NEW CONNECTION.
    The Create New Data Connection modal window appears.
  3. Choose Hive from the Connection type drop-down list and assign a name to your connection.
  4. Enter the hostname or IP address of the running coordinator.
    You can get the coordinator hostname from the JDBC URL of the Hive DW.
  5. Use port 443.
  6. Enter your workload username and password as credentials.
  7. Click the Advanced tab to configure the additional details.
  8. Click the Parameters tab and set the hive.server2.async.exec.async.compile parameter to false.
  9. Check the Data tab for more configuration options.
  10. Once you finish configuring the settings, click TEST to test the connection.
  11. Click CONNECT to establish the connection.
You have successfully set up a connection to a running Hive DW.