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.
- On the main navigation bar, click DATA.The DATA opens, displaying the Datasets tab.
On the side menu bar, click NEW CONNECTION.
The Create New Data Connection modal window appears.
Choose Hive from the Connection type drop-down list and
assign a name to your connection.
Enter the hostname or IP address of the running coordinator.
You can get the coordinator hostname from the JDBC URL of the Hive DW.
- Use port 443.
- Enter your workload username and password as credentials.
Click the Advanced tab to configure the additional
- Click the Parameters tab and set the
- Check the Data tab for more configuration options.
- Once you finish configuring the settings, click TEST to test the connection.
- Click CONNECT to establish the connection.