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:
  1. Log in to Cloudera Data Warehouse as a DWAdmin.
  2. Activate the environment.
  3. Create a Hive or an Impala Virtual Warehouse.
  4. Create a Cloudera Data Visualization instance.
    1. Click Data Visualization > ADD NEW.
    2. Specify a name for your instance, and select the environment and size from the drop-down menu and click CREATE.
  5. 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.

To log in as an administrator and change your role:
  1. Log out from the Cloudera Data Visualization application.
  2. Log in to Cloudera Data Visualization using the following credentials:
    • Username: vizapps_admin
    • Password: vizapps_admin
  3. On the Cloudera Data Visualization application, click > Manage Users & Groups.
  4. 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:
  1. Launch Cloudera Data Visualization from CDW using LDAP credentials.
  2. Go to the DATA tab and click NEW CONNECTION.

    The Create new Data Connection dialog box is displayed.

  3. 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.
    If the connection test is successful, the Connection Verified message is displayed.
  4. Click CONNECT.

    The newly created connection is displayed.