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