Hue 4 SQL Editor improvements

Published on 18 July 2017 in Version 4 / Querying - 2 minutes read - Last modified on 04 February 2020

Aloha SQL experts!

For Hue 4 we've made numerous improvements to the Hive and Impala SQL editors greatly improving the SQL editor user experience. When working with Hive and Impala queries Hue will now provide you with autocomplete suggestions based on popularity as well as risk evaluation from Navigator Optimizer.

A brand new assist panel has been added on the right hand side, containing details about the active statement as well as documentation for UDFs.

Enriched autocomplete

The autocompleter will suggest popular tables, columns, filters, joins, group by, order by etc. based on metadata from Navigator Optimizer. A new “Popular” tab has been added to the autocomplete result dropdown which will be shown when there are popular suggestions available.

 

Popular joins, showing the popularity score when selected

 

Autocomplete results suggesting popular aggregate function on the left and popular filters on the right

Risk and suggestions

While editing, Hue will run your queries through Navigator Optimizer in the background to identify potential risks that could affect the performance of your query. If a risk is identified an exclamation mark is shown above the query editor and suggestions on how to improve it is displayed in the lower part of the right assistant panel.

Data where you need it when you need it

You can now find your Hue documents, HDFS and S3 files and more in the left assist panel, right-clicking items will show a list of actions, you can also drag-and-drop a file to get the path in your editor and more.

The left assist showing details for a Hue document

The Functions panel on the right side will let you browse and filter functions for Hive, Impala and Pig. Double-click or drag to insert it in the editor.

The new Functions panel in the right assist panel

Improved multi-query editing

The right Assistant panel will identify and display the active tables in the statement that you're editing, this gives you a quick overview and you can find details such as samples and columns by hovering over a table.

The new Assistant panel showing the tables in the active statement

When you have multiple statements it's enough to put the cursor in the statement you want to execute, the active statement is indicated with a blue gutter marking.

 

As usual you can send feedback and participate on the hue-user list or @gethue!

 


comments powered by Disqus

More recent stories

23 June 2020
Monitoring Hue activity with Grafana Dashboards
Read More
22 June 2020
Automated checks for JavaScript modules compatible licenses and non absolute paths with Continuous Integration
Read More
19 May 2020
How to grant Ranger permissions for a new user on a Secure Cluster
Read More