Fixed Issues in Cloudera Data Explorer (Hue)

Fixed issues for Cloudera Data Explorer (Hue) are addressed in Cloudera Runtime 7.3.2, its service packs and cumulative hotfixes.

Cloudera Runtime 7.3.2.10000 SP1

CDPD-97016: Incorrect table values during CSV import in Data Explorer: 7.3.2.10000; Previously, importing CSV files to create Hive tables contained quoted fields with commas through the Data Explorer Importer caused field parsing errors. This issue resulted in malformed table values and corrupted data ingestion. This issue is now resolved, by updating the SQL table creation logic to handle quoted CSV fields correctly and applying the appropriate storage format during import.
CDPD-95672: Directory rename failure in Data Explorer: 7.3.2.10000; Previously, attempting to rename a directory in Data Explorer by using the Data Explorer user interface failed, which caused the directory to disappear from the user interface. This issue is now fixed by updating the path handling and user interface feedback during directory renames, ensuring that directories are renamed correctly and remain visible.
CDPD-98406: Excessive Gunicorn debug log generation: 7.3.2.10000; Previously, Gunicorn log listeners generated debug-level records for access and metrics even when Data Explorer debug mode was disabled. This behavior caused unnecessary log clutter. This issue is now fixed by ensuring Gunicorn log output honors the Data Explorer debug mode setting.
CDPD-90751: Reverse tabnabbing security vulnerability in external links: 7.3.2.10000; Previously, external links using the target="_blank" link attribute without the rel="noopener" or rel="noreferrer" property values created a reverse tabnabbing security vulnerability. This issue is now fixed.
CDPD-101177: Data Explorer File upload failure to S3 in Data Explorer: 7.3.2.10000; Previously, file uploads to AWS S3 through Data Explorer might fail in both RAZ and non-RAZ environments because the storage connector incorrectly attempted to use a legacy configuration path. This issue is resolved by ensuring the storage connector uses the correct configuration path for the boto3 SDK.
CDPD-101696: Query Processor failure with Oracle database: 7.3.2.10000; Previously, retrieving queries when using an Oracle database failed due to a parameter binding issue in the Query Processor. This issue is now fixed by correcting the parameter binding logic during query retrieval.
CDPD-45130: Truncating excessive length queries to prevent database indexing errors: 7.3.2.10000; Previously, large or complex SQL statements, such as lengthy INSERT queries, were indexed by the Query Processor. This resulted in increased load times for the Job Browser. You can now configure query truncation by using the hue.query-processor.query.max-length property in the Query Processor configuration under dasConf section. By default, no truncation is performed to ensure backward compatibility.

CDPD-95666: Persistent loading indicator for unpermitted directories: 7.3.2.10000; Previously, selecting a folder or file without read permissions in Microsoft Azure environments caused a persistent loading bar to appear across file systems, including Amazon S3 and HDFS. The user interface remained in a loading state and failed to display an alert message indicating missing permissions. This issue is now fixed.

Cloudera Runtime 7.3.2.100 CHF 1

CDPD-104785: Arbitrary file read on Data Explorer hosts through the localfile importer feature: 7.3.2.100; Previously, a local file inclusion vulnerability existed on the Data Explorer host type through the localfile importer feature. This occurred because two indexer API endpoints accepted unvalidated paths, allowing unauthorized file reads through the path parameter. This issue is now fixed.
CDPD-98620: Azure Blob File System upload authentication failure: 7.3.2.100; Previously, you experienced intermittent file upload failures by using the Data Explorer user interface. This issue occurred because the token signature parameter value corrupted by collapsing consecutive slashes. As a result, Azure Blob File System storage rejected the authentication request with a 403 Client Error message. This issue is now fixed.
CDPD-91439: Support for Python-OracleDB connectivity in Data Explorer: 7.3.2.100; Previously, Data Explorer experienced database connectivity incompatibilities due to limitations with the deprecated cx_Oracle driver. This issue is now fixed by transitioning Data Explorer 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 Data Explorer.
CDPD-92510: Inaccurate table update timestamps in Data Explorer: 7.3.2.100; Previously, the "Data last updated on" timestamp for Iceberg tables in Data Explorer displayed incorrect information when tables were altered by using Spark. This occurred because the timestamp was sourced from the transient_lastDdlTime table property, which does not update correctly during Spark operations. This issue is now fixed by updating the metadata source to use Iceberg snapshot timestamps.
CDPD-92857: Export all failures in secured multi-tenant clusters: 7.3.2.100; Previously, the export all feature in Data Explorer failed in secured multi-tenant clusters that used tenant colocation policies. This resulted in access errors during the export process. This issue is now resolved. The export all functionality now follows tenant boundaries and cluster security policies.
CDPD-68779: Error while browsing S3 buckets or ADLS containers from the left-assist panel: 7.3.2.100; Previously, when attempting to browse S3 buckets or ADLS containers from the left-assist panel in Data Explorer without the required permissions, the system displayed a generic error message: Failed to retrieve buckets:1:0: syntax error. This is now fixed. When RAZ is enabled, the left-assist panel now opens the home directory if the required permissions are available. In non-RAZ environments, the left-assist panel opens the path configured in the Data Explorer configuration file.
CDPD-100816: Data Explorer File Browser workflow submission button failure: 7.3.2.100; Previously, the Submit button component in the Data Explorer File Browser application failed to function, which prevented submitting workflows. This issue is now fixed by restoring the required path reference dependency.
CDPD-96460: Impala query profile row count display error: 7.3.2.100; Previously, the Data Explorer Impala editor component displayed incorrect row count values for large tables because it incorrectly parsed the RowsReturned metric property from the EXCHANGE node component inside the Impala query profile log. This issue is fixed by implementing a threshold-based bucketing approach that displays approximate row count indicators, such as 1000 rows or 10000+ rows, to prevent inaccurate query metadata displays.

Cloudera Runtime 7.3.2

Cloudera Runtime 7.3.2 resolves Impala issues and incorporates fixes from the service packs and cumulative hotfixes from 7.3.1.100 through 7.3.1.706. For a comprehensive record of all fixes in Cloudera Runtime 7.3.1.x, see Fixed Issues.

CDPD-73189: Not all tables are loading in the left assist panel: 7.3.2; Previously, in the Data Explorer left assist panel, only the initial 5,000 tables were loaded because the default value of max_catalog_sql_entries was set to 5000. Increasing this configuration in the Cloudera Data Explorer (Hue) Safety Valve only allowed loading up to 10,000 tables due to the max_rows parameter being hardcoded to 10000. This issue is now resolved by fixing the hardcoded limitation. You can now load more than 10,000 tables in the left assist panel.
CDPD-71098: Complex Hive or Impala data type sampling fails in Data Explorer: 7.3.2; Previously, sampling complex Hive or Impala data types in Data Explorer 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.
CDPD-48151: Manual table creation using the importer: 7.3.2; Previously, a JavaScript error occurred when you used the Manually option in the importer to create a table. This issue prevented fields from being displayed. This issue is now fixed. To create a table without importing data, you can also use the SQL editor.
CDPD-47230: Missing SQL information in Table Browser for Hive views: 7.3.2; Previously, the viewSQL feature in the Table Browser displayed an empty window for views created by using Hive. This issue occurred when the source type was set to Hive, while the feature worked correctly for Impala. This issue is now fixed. You can now view the SQL information for Hive views in the Table Browser as expected.
CDPD-92829: Job Browser error and traceback exposure: 7.3.2; Previously, Job Browser displayed an error if the POST format parameter contained empty or invalid values. This issue caused a JSON serialization failure and exposed sensitive system information. This issue is now fixed. The resolution includes validated parameter inputs and improved error handling to prevent the exposure of sensitive system information.
CDPD-77831: Workflow log icon fails to redirect in Data Explorer: 7.3.2; Previously, the log icon in the Task tab for workflows did not redirect to the logs. When you clicked the icon during a workflow run, the UI remained on the same page without displaying an error, although a TypeError related to lodash.trimRight occurred in the background. This issue is now fixed. You can now access workflow logs through the UI as expected.
CDPD-74389: File and folder creation fails in Data Explorer S3 file browser: 7.3.2; Previously, you could not create files or folders in the Data Explorer S3 File Browser on the AWS-Fedramp-RAZ environment. These actions failed to complete without displaying an error message in the UI. This issue is now fixed.
CDPD-90906: Database connection errors in metrics module: 7.3.2; Previously, the metrics module encountered the cx_Oracle.DatabaseError: DPI-1010: disconnect error 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-89478: Oozie UI displays start and end times incorrectly after upgrade: 7.3.2; Previously, the Oozie UI intermittently displayed the start time and end time fields in reverse order. Additionally, the Run button remained inactive until you clicked Save, even if you made no changes. This issue is resolved by correcting the field display order and ensuring that the Run button is active for schedules without requiring an unnecessary save action.
CDPD-58142: Query pre-population fail in the SQL editor: 7.3.2; Previously, when you clicked Re-Execute to rerun a query from the Job Browser > Queries > Query Details page, the query did not appear in the SQL editor as expected. This issue occurred because the editor loaded multiple times, overwriting the query text. Additionally, the page change was not reflected in the URL. This issue is now fixed. The SQL editor now correctly populates and retains the query text when you navigate from the Job Browser.
CDPD-65749: Table Browser navigation error with Knox: 7.3.2; Previously, clicking the back button when navigating the Table Browser directory structure through Knox resulted in a 404 Error. This issue is now fixed. The resolution improves navigation stability and ensures the UI correctly displays the previous page.
OPSAPS-73942: Query processor service configuration failure during upgrade: 7.3.2; Previously, the upgrade wizard failed during the configuration validation phase if the Query processor service was installed. This issue occurred because the service version could not be upgraded directly, resulting in a warning that the service must be removed. This issue is now resolved.
CDPD-81025: Performance issues when querying large datasets with Oracle or MySQL queries: 7.3.2; Previously, when querying large datasets using Oracle or MySQL backends, the QueryProcessor failed to correctly apply the SQL limit clause. This caused the system to fetch 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.