Fixed issues in Cloudera Data Warehouse Private Cloud (1.4.0-H1)

This section lists issues fixed in this release of Cloudera Data Warehouse (CDW) service.

DWX-13017: Stats task during Hive query execution fails because of the missing “INSERTED_COUNT” column: Earlier, when Hive ran the stats task while a Hive query is running, Hive failed to update the transactional statistics. This issue has been resolved by incorporating a hotfix.
DWX-12801: Authorization error on SSO login in Cloudera Data Visualization on CDW Private Cloud: Cloudera Data Visualization displayed “Access Denied” error when you logged in using SSO. This issue can be resolved by creating a new Cloudera Data Visualization instance from CDW.
To create a new Cloudera Data Visualization instance:

Log in to Cloudera Data Warehouse as a DWAdmin.

Activate the environment.

Create a Hive or an Impala Virtual Warehouse.

Create a Cloudera Data Visualization instance.

Click Data Visualization > ADD NEW.

Specify a name for your instance, and select the environment and size from the drop-down menu and click CREATE.

After the Data Visulization instance is in the running state, open the application by clicking > Open Data Visualization.
SSO is enabled on Cloudera Data Visualization in Private Cloud. If you are logged in to the Control Plane, then you will be logged into Cloudera Data Visualization automatically. If not, then log into the Control Plane using your LDAP credentials.

note

Role Based Access Control (RBAC) is not yet available in Cloudera Data Visualization in Private Cloud. All users can access the Data Visualization instances as non-admin users by default.

When you log in to Cloudera Data Visualization for the first time, you are added as a normal user. With these privileges, you can create datasets and visuals, but you cannot create new connections. To create new connections, you must have the System Admin role. By default, the admin user has the Database admin role.

In CDP Private Cloud, the only available authentication mechanism is SAML SSO. Once you log out from Data Visualization, you cannot sign back into the application using your LDAP credentials. You must go to CDW and launch Cloudera Data Visualization.

To log in as an administrator and change your role:

Log out from the Cloudera Data Visualization application.

Log in to Cloudera Data Visualization using the following credentials:

Username: vizapps_admin

Password: vizapps_admin

note

vizapps_admin is the only available admin user. Cloudera recommends that you change the password for the vizapps_admin user.

New users logging in to Cloudera Data Visualization are automatically added to the viz_guest_group group. You can assign the System Admin role to this group to grant new users the permision to create new connections.

On the Cloudera Data Visualization application, click > Manage Users & Groups.

Click to assign the System Admin role to the required LDAP users.

You can also add new users or groups and assign roles to them.
To create new connections:

Launch Cloudera Data Visualization from CDW using LDAP credentials.

Go to the DATA tab and click NEW CONNECTION.
The Create new Data Connection dialog box is displayed.

Select the connection type, specify a connection name, and select the warehouse you want to connect to from the drop-down menu.
The corresponding connection details (hostname and port) are automatically populated.
Under Credentials, specify the username that you used to log in to Cloudera Data Visualization, as other users may not have proxy privileges in the warehouse, and click TEST.
note
You need not enter the password because you are authenticated with SSO. Trusted impersonation is enabled in CDW.
If the connection test is successful, the Connection Verified message is displayed.
note
(For connections to Impala Warehouse) If the connection test fails, retest the connection using the delegation username and password that you used while activating the CDW environment.

Click CONNECT.
The newly created connection is displayed.