Fixed Issues in Hue

Cloudera Runtime 7.1.9 SP2 resolves identified Hue functional errors and includes technical patches to improve service stability and performance.

CDPD-99210: Hue web UI login failure with AllowAllBackend authentication

Previously, logging in to the Hue web UI failed when you used the desktop.auth.backend.AllowAllBackend authentication configuration. This issue is now resolved by correcting the authentication handling to ensure that you can successfully log in to the Hue web UI when this configuration is active.

CDPD-23994: Table browser error due to mixed data type columns in Hue

Previously, the table page in Hue displayed a ‘<’ not supported between instances of 'str' and 'int' comparison error. This occurred within the Autocomplete and Describe APIs when columns contained mixed data types, which caused sorting and description operations to fail when both strings and integers were present. This issue is now fixed by correcting how the Autocomplete and Describe APIs handle and sort mixed data types, ensuring that the table page displays correctly without errors.

CDPD-71855: UI timeouts when describing columns for Hive and Impala views

Previously, using viewSQL to perform get_table_columns_stats on an Impala or Hive view resulted in an AnalysisException and UI timeouts after 5 seconds. This occurred because Impala and Hive do not support column statistics on views, causing SHOW COLUMN STATS operations to fail when describing view columns. This issue is now fixed by skipping the column description operations for views in Hive and Impala.

CDPD-91439: Support for Python-OracleDB connectivity in Hue

Previously, Hue experienced database connectivity incompatibilities due to limitations with the deprecated cx_Oracle driver. This issue is now fixed by transitioning Hue to use the new python-oracledb library. This change enables official support for modern Python-OracleDB connectivity, ensures compatibility with newer versions like Python 3.11, and secures the Oracle database integration within Hue.

CDPD-90906: Database connection stability in metrics module

Previously, a cx_Oracle.DatabaseError: DPI-1010: not connected error in the metrics module when the Cloudera Manager metrics API queried active users. This issue caused database connections to be lost. This issue is now fixed. The resolution improves connection stability and robustness against database disconnect errors.

CDPD-81025: QueryProcessor improvements with Oracle and MySQL queries

Previously, when querying large datasets using Oracle or MySQL backends, the QueryProcessor failed to correctly apply the SQL limit clause. This resulted in the system fetching all data records instead of the restricted set required for pagination. As a result, the user interface experienced significant loading delays and performance issues when displaying query results. This issue is now resolved.

CDPD-71098: Complex Hive or Impala data type sampling in Hue

Previously, sampling complex Hive or Impala data types in Hue did not work correctly. This issue is now fixed. The resolution enables accurate sampling and autocomplete functionality for nested complex types, which improves the query experience.