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).
You must connect to your data prior to using the data modeling and visualization
functionalities. The following steps show you how to create a new CML data connection to a
Hive data warehouse.
When you create a connection, you automatically gain privileges to create and manage
datasets associated with this connection, and to 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 interface appears, open on the Datasets
tab.
In the Data side menu bar, click NEW
CONNECTION.
The Create New Data Connection modal window appears.
Select the HiveConnection type from the drop-down list and provide a name for 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 and configure the additional
details.
Click the Parameters tab and set the
hive.server2.async.exec.async.compile parameter to
false.
Click TEST to test the connection.
Click CONNECT to create the connection.
You have set up a connection to a running Hive DW.