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
[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
[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.