What's New in Hue

Learn about the new features of Hue in Cloudera Runtime 7.1.9.

Ability to browse Ozone filesystem from Hue

You can now browse files and directories on the Ozone filesystem from Hue, just like how you browse files on S3 or ADLS Gen2. To enable browsing files on Ozone, you must first enable the Ozone File Browser. See Enabling browsing Ozone from Hue on CDP Private Cloud Base.

Ability to create Iceberg tables using Hue Importer

You can create Iceberg tables in Hue starting with 7.1.9. You can also create an Iceberg table by importing a CSV file and selecting the Iceberg table option on the Importer. For more information, see Creating Iceberg tables in Hue.

Hue supports Hive Hybrid Procedural SQL

You can run Hive Hybrid Procedural SQL (HPL/SQL) using the Hue query editor. To enable the HPL/SQL interpreter, see Enabling stored procedures for Hive on CDP Private Cloud Base. To run stored procedures from Hue, see How to run a stored procedure from Hue in CDP Private Cloud Base.

Hue supported on RHEL 9 with Python 3.9

Hue is now supported with Python 3.9 on RHEL 9 operating systems. RHEL 9 comes preinstalled with Python 3.9, so you do not have to install it separately. If you want to install Python 3.9 in a custom location, then see Installing standard Python 3.9 binary on RHEL 9 at a standard or custom location.

Hue supported on SLES 15

Hue is supported to run on SLES 15.

Hue supports connections to databases secured using TLS 1.2 and TCPS

Hue can connect to TLS-enabled MySQL, MariaDB, or PostgreSQL databases and TCPS-enabled Oracle database. To connect to a TLS 1.2/TCPS-enabled database while adding the Hue service to a cluster, see Configure TLS 1.2 for Hue. You can also enable TLS1.2/TCPS on an existing database and then configure Hue to connect to it. See Set up and configure TLS 1.2 for Hue.

For more information about Oracle TCPS, see How to connect CDP components to a TCPS-enabled Oracle database.

Hue Query Processor supports MySQL and Oracle as backend databases

Earlier, the Hue Query Processor only used the PostgreSQL as its backend database. You can now use MySQL and Oracle as a backend databases for the Hue Query Processor on CDP Private Cloud Base. For information on how to add the Query Processor service with all the supported backend databases, see Adding Query Processor service to a cluster.

Ability to control caching behavior of the web page

You can enable web page-caching to ensure that your browser fetches latest resources while you are exploring data using Hue. Hue uses Cache-Control, Pragma, and Expires HTTP headers. To enable cache control, see Enabling cache-control HTTP headers when using Hue.

The “enable_queries_list” configuration has been removed from Hue jobbrowser safety valve section

The enable_queries_list configuration in the Hue's Advanced Configuration Snippet displayed or hid the Queries tab on the Job Browser page. This configuration has been removed. The Queries tab is displayed by default. You can override the query_store configuration and hide the Queries tab. For more information, see Hue configurations in CDP Runtime.

Ability to set the file size for upload using Hue File Browser

You can set the permitted scope of a file that your users can upload using the Hue File Browser by setting the following parameter in the Hue Advanced Configuration in Cloudera Manager:
[filebrowser]
max_file_size_upload_limit=[***FILE-SIZE-IN-BYTES***] \\default is -1 (no limit)

For more information, see Hue configurations in CDP Runtime.

Increased the download limit on the Solr dashboard

Earlier, you could download only 1000 records from the Solr Search dashboard. Hue now supports downloading up to 15000 records. You can configure the download limit using the following Advanced Configuration Snippet:
[search]
download_limit=[***DOWNLOAD-LIMIT***]

For more information, see Hue configurations in CDP Runtime.

Hue Query Processor scan frequency decreased to 5 minutes

The Hue Query Processor scans the event processor pipeline to retrieve the Hive query history and query details and displays them on the Job Browser page. The scan frequency has been decreased from 2 milliseconds to 5 minutes to optimize resource utilization. As a result, you may notice a delay in viewing the query history and query details on the Job Browser page for queries that finish executing in less than 5 minutes. However, you can still view the query history from the Query history tab below the query editor. See Configuring the Hue Query Processor scan frequency.

Query Processor API to force data cleanup

Hue Query Processor cleans up queries older than a set number of days as per the set schedule. However, to manually clean up queries on an as needed basis, you can use the Query Processor API. When you call this API, it also runs a VACUUM command on the Query Processor tables. All queries that were run before the epoch time are cleared. For more information, see Ways to clean up old queries from the Query Processor tables.

Improvements and enhancements

SparkSQL improvements

Hue now has a dedicated autocomplete and syntax checker for Spark SQL. Hue supports all Spark SQL statement types and it is up-to-date with version 3.3.1 of the SparkSQL syntax.

The UDF library for Spark SQL has also been integrated with the autocomplete code, as well as in the right assist panel. The inline help includes all built-in functions of Spark SQL 3.3.1.

Additionally, numerous improvements have been made in the Hue backend integration with SparkSQL, including caching of session details and an overall performance boost.

Added an option to download documents from the Hue web interface
You can now download saved documents when you search for them from the search bar or from the left-assist panel by right-clicking on the document.
Keyboard shortcut for showing and hiding left and right-assist panels
You can press command + . (Macintosh) or Ctrl + . (Windows) to hide and show the left and right-assist panels. Hiding the left and right-assist panels provides a larger area for writing queries and viewing results.