New in Cloudera Enterprise 5.8: SQL Editor and Other Productivity Improvements

Categories: CDH Hue Search Sentry

Cloudera Enterprise 5.8 includes the latest release of Hue (3.10), the web UI that makes Apache Hadoop easier to use.

As part of Cloudera’s continuing investments in user experience and productivity, Cloudera Enterprise 5.8 includes a new release of Hue that makes several common tasks much easier. In the remainder of this post, we’ll provide a summary of the main improvements. (Hue 3.10 is also available for a quick try in one click on

New SQL Editor

Hue’s new code editor is a single-page app that is much simpler to use than the previous editor. (Although the editor currently focuses on SQL, support for more languages is possible in the future.) Here is a list of some of the new features:

  • Ability to 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
  • Ability to drag & drop saved queries into workflows (learn more)


This video demo shows them in action:

Read more about the new SQL editor 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, you can create your own directories and subdirectories and drag and drop documents within the simple file browser interface. You can also import and export documents or directories directly from the home Page. Furthermore, 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.


Read more about it here.

Cloudera Manager Database Wizard

In order to support the native load balancer for HA and improved performance (up to 10x), Hue needs to be configured with a robust RDBMS like MySQL, PostgreSQL, or Oracle Database. That setup can now be done directly from the Cloudera Manager 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.


UI for Securing Solr Collections

The Apache 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 who can access or update Hive, Impala, or Solr data on a fine-grained/policy-based basis.) So, it is now much easier to control the authorization of all your Solr indexes and thus take advantage of Hue’s Dynamic Search dashboards.


Read more about it here.

Idle Session Timeout

Administrators can now 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 current work.


Read more about it here.

Next Up!

More SQL improvements and optimizations are in the pipeline, including new support for very large queries via SQL auto-complete, query browsing and export, and one-click auto-scheduling.

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