Hue 4 SQL Editor improvements

18 July 2017 in Version 4 / Querying - 2 minutes read

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

13 November 2019
Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
Read More
31 October 2019
Missing some color? How to improve or add your own SQL syntax Highlighter
Read More
24 October 2019
How to create a HBase table on Kerberized Hadoop clusters
Read More