February 29, 2024

This release of the Cloudera Data Warehouse (CDW) service on CDP Public Cloud has the following behavior changes:

Summary:

Change in value for the hive.map.groupby.sorted property

Before this release:

The value of the hive.map.groupby.sorted property was set to 'true'.

After this release:

The value of the hive.map.groupby.sorted property is changed to 'false' to disable optimization. The change was introduced to address data correctness issues noticed in query results on tables with CLUSTER BY and SORT BY.

For more information, see HIVE-27876.