What’s new in Hue in CDH 5.8

What’s new in Hue in CDH 5.8

Cloudera Enterprise 5.8 brings the latest Hue 3.10, the Web UI that makes Hadoop easier to use.

 

The focus on performances on the user experience continues from C5.7, with a revamped SQL Editor that will make you productive with Hive and Impala queries. This new version is also available for a quick try in one click on demo.gethue.com!

Here is a description of the main improvements.

New SQL Editor

Hue now has a generic editor that supports any languages but currently focuses on SQL. It is a single page app that is much slicker than before and simpler to use. Here is a list of the new functionalities and a video demo that show them in action:

  • Switch between queries without any page reload
  • Live history of running and past queries
  • Query result grid is simplified and lets you refine your results
  • Code editor has more operations like autocomplete values, search and replace, fold code, go to line number
  • Drag & Drop saved queries into workflows

Grid result view

The new look of the editor

 

Read more about it here…

 

New home page

Hue documents can now be managed via an intuitive directory and file-based interface. Rather than utilizing the tag-based system from older versions of Hue, users can create their own directories and subdirectories and drag and drop documents within the simple filebrowser interface. Users can import and export documents or directories directly from the Home Page. Users can easily share a folder or document with other users or groups by selecting the desired item(s) and selecting “Share” in the contextual menu or in the top right icon menu.

 

Create Directory

 

Read more about it here…

 

CM database wizard

In order to support the native Load Balancer for High Availability and 10x more performances, Hue needs to be configured with a robust database like MySQL, PostgreSQL or Oracle. The setup can now be done directly from the CM interface which will let you enter the properties and test the connection of the Hue service. Additional new Hue instances will automatically be configured for you.

cm-db-wizard

 

Sentry Solr UI

The Sentry app now let’s you edit Apache Solr Collection privileges via a Web UI (instead of a configuration file). Apache Sentry allows you to define via privileges who can access or update data. It previously only had editing capabilities for Hive tables. It becomes now much easier to control the authorization of all your Solr indexes and leverage the Dynamic Search dashboards.

solr-secu

Read more about it here…

 

Idle Session Timeout

An additional security feature for Hue administrators to enforce and manage idle session timeouts in Hue. We’ve also improved the experience of re-authenticating into Hue when a user’s session is timed out by introducing a new login modal that prevents the user from losing his current work.

loginmodal

Read more about it here…

Next Up!

More SQL improvements and optimizations are in the pipeline. In the top three, a brand new SQL autocomplete will assist users even with their giant queries, large query results browsing and export will scale and queries can be scheduled to run repetitively in just a click.

If you have any questions, feel free to comment here, on the hue-user list or via @gethue!

2 Comments

  1. Khaled Idriss 6 months ago

    Hello, Does HUE Search Dashboards support sum, avg when building dashboards, I want to use other aggregate functions (Sum, Avg, Max, Min,…) rather than count in Y-Axis
    , I am using Cloudera 5.8 and HUE 3.10

Leave a reply

Your email address will not be published. Required fields are marked *

*