June 04, 2025 - Hotfix

Review the fixed issues in this release of the Cloudera Data Warehouse service on cloud

DWX-20174: Removal of obsolete Upgrade Now option from user interface

In an older release, the Upgrade Now option was displayed under the Environments tab, but was no longer functional, as the upgrade process had been replaced by the Backup and Restore procedure. The non-functional Upgrade Now option is now removed from user interface.

DWX-20746: CloudFormation (CF) template encryption change and Cloudera Data Warehouse cluster activation issue

CloudFormation (CF) templates uploaded to S3 buckets previously used AES256 encryption, which has now been replaced by the bucket's default encryption settings. This change impacted the activation of Cloudera Data Warehouse clusters when the datalake bucket had SSE-CMK encryption enabled. Activation failures were observed due to missing permissions in the cross-account role policies.

This issue is now resolved by updating the cross-account role policies to include the necessary permissions. These updates have been applied to both the restricted and reduced policies.

DWX-20754: Error while running LATERAL VIEW query on non-native tables

When running LATERAL VIEW queries on non-native Iceberg tables, you may encounter the following error:

org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Invalid column reference 'BLOCK__OFFSET__INSIDE__FILE'

This issue occurs because Iceberg tables are incorrectly classified as native tables, resulting in the addition of incorrect virtual columns in the RowResolver.

The issue has been resolved, and LATERAL VIEW queries on non-native Iceberg tables should now work as expected.

Apache Jira: HIVE-28938

DWX-20798: Hive VW sometimes fails to resume after it goes idle

Hive VW does not resume and gets stuck sometimes, this is because compute watch restarts do not receive events occasionally.

The issue was addressed by adding an auto-retry mechanism that resets the watch if no event is received within 5 seconds of a watch restart.

DWX-20918: API allowlist feature compatibility issue with older environment

In the latest control plane release, the nginx-service was renamed from nginx-controller. This change caused the API allowlist feature to stop working in environments older than version 1.10.1, as the system was trying to locate the outdated service name. This issue is now fixed.

DWX-20924: Query cancellation did not stop compute resource creation

Cancelling a Hive query did not interrupt the creation of the associated StandaloneCompute resource, leading to unused compute nodes.

DWX-20931: Runtime error during the configuration updates

After upgrading to Impala Virtual Warehouse version 2025.0.19.0-51, a runtime error message occurred when attempting to edit or update an existing configuration. This error was triggered by a problem in the upgraded configuration. This issue is now fixed.

DWX-20939: Cloudera Data Visualization restore issue on private AKS and EKS clusters

Cloudera Data Visualization restore on private AKS and EKS clusters was failing because the restore job did not account for increased communication delays between the Cloudera Data Warehouse Control Plane and the Cloudera Data Warehouse cluster in private network setups. The logic has been updated to handle higher response times, and the issue is now resolved.

DWX-21045: Hue AI Assistant Azure persistent volume issue

Cloudera Data Warehouse introduced a new persistent volume for Hue's SQL AI Assistant, intended for storing sentence transformer models. This provisioning attempted to use Azure storage accounts with public access enabled by default. Customers with stricter security policies that deny public storage account creation or restrict new account provisioning experienced failures with Hive, and Impala Virtual Warehouse provisioning due to these Azure policy violations.

As a result of this fix, the SQL AI Assistant may not be available in air-gapped Azure environments. For more information, see TSB 2025-858: Cloudera Data Warehouse provisioning failures due to storage policies.

CDPD-80939: Missing equivalence conjunct in aggregation node with inline views

In queries that include filters on the result of a UNION operation, the planner sometime removed required conjuncts, which caused incorrect query results.

This has now been fixed.

Apache Jira: IMPALA-13873

CDPD-82599: Query rejected due to too many fragment instances on one node

Some queries failed with a scheduling error when too many fragment instances were placed on a single executor node.

The fix limits the number of instances per node during scheduling to avoid exceeding the maximum allowed.

Apache Jira: IMPALA-14006

CDPD-82644: Data corruption caused by concurrency issue in HIVE-27653

HIVE-27653 introduced a concurrency issue that could lead to data corruption. The change was reverted to prevent this issue. In some cases, deletion of the resource and addition of the finalizer label happened at the same time, causing Invalid Object errors in the controller.

This issue is fixed by ensuring that the newly created compute nodes of a canceled query are deleted, even if the associated standalone CRD resource is not available.

CDPD-82303: EXEC_TIME_LIMIT_S incorrectly includes planning time

The EXEC_TIME_LIMIT_S timer was triggered during the planning and admission(queuing) phases, which could cause queries to fail before any processing on backend started.

The issue was addressed by starting the EXEC_TIME_LIMIT_S only after the query is ready to run on the backend. This ensures the timer applies only to the actual processing phase.

Apache Jira: IMPALA-14001

CDPD-82364: Nested loop join rewrites disjunctive subquery incorrectly

Queries with a subquery inside an OR condition could return incorrect results due to an improper join predicate rewrite.

The issue was addressed by skipping the join rewrite when the subquery is part of a disjunctive (OR) expression.

Apache Jira: IMPALA-13991

Invalid cardinality calculation in sortnode's computestats

An error occurred during query execution due to an overflow in the calculation of row limits, causing unexpected failures.

The calculation was updated to prevent overflow and eliminating the error.

Apache Jira: IMPALA-14070

Review the known issues in this release of the Cloudera Data Warehouse on cloud service.

DWX-21083: Frequent permission denied red popup for restricted users

If you have limited permissions, you may encounter a permission denied red popup while navigating the Cloudera Data Warehouse user interface.

This error message does not affect functionality and can be safely ignored.

None

This release of the Cloudera Data Warehouse service on cloud has the following behavior changes: