Cloudera Docs

Known issues in Cloudera Data Warehouse on premises 1.5.4 SP1

Review the issues identified in this service pack release of Cloudera Data Warehouse on premises.

DWX-19016: Hue Importer displays an incorrect status message
When you create an Impala table by importing CSV files using the Hue Importer, the Importer window might display a warning indicating that the query has failed. This is an incorrect message and the table is successfully created.
None. This issue is only related to the display of an incorrect status message and does not affect the actual table creation process.
Hive compaction of Iceberg tables results in a failure
When Cloudera Data Warehouse and Cloudera Base on premises are deployed in the same environment and use the same Hive Metastore (HMS) instance, the Cloudera Base on premises compaction workers can inadvertently pick up Iceberg compaction tasks. Since Iceberg compaction is not yet supported in the latest Cloudera Base on premises version, the compaction tasks will fail when they are processed by the Cloudera compaction workers.

In such a scenario where both Cloudera Data Warehouse and Cloudera Base on premises share the same HMS instance and there is a requirement to run both Hive ACID and Iceberg compaction jobs, it is recommended that you use the Cloudera Data Warehouse environment for these jobs. If you want to run only Hive ACID compaction tasks, you can choose to use either the Cloudera Data Warehouse or Cloudera Base on premises environments.

If you want to run the compaction jobs without changing the environment, it is recommended that you use Cloudera Data Warehouse. To avoid interference from Cloudera Base on premises, change the value of the hive.compactor.worker.threads Hive Server (HS2) property to '0'. This ensures that the compaction jobs are not processed by Cloudera Base on premises.
  1. In Cloudera Manager, click Clusters > Hive > Configuration to navigate to the configuration page for HMS.
  2. Search for hive.compactor.worker.threads and modify the value to '0'.
  3. Save the changes and restart the Hive service.
DWX-19327: Unable to upgrade the Cloudera Data Visualization instance
If you are upgrading your Cloudera Data Visualization instance from Cloudera Data Warehouseon premises 1.5.4 or earlier versions to Cloudera Data Warehouse on premises 1.5.4 SP1, the upgrade fails with a “Failed to acquire lease” error.

This issue occurs because of a missing vizCRN from some of the older Cloudera Data Visualization application objects.

Create a new Cloudera Data Visualization instance. For more information, see Deploying Cloudera Data Visualization instance in Cloudera Data Warehouse.
DWX-19489: Concurrent Hive-Iceberg UPDATE/INSERT query fails
Concurrent UPDATE/INSERT queries on Hive Virtual Warehouses might fail intermittently with the following error:
return code 40000 from org.apache.hadoop.hive.ql.exec.MoveTask. Error committing job
Run the failed queries again.