SQL Assist and Autocomplete Improvements

05 November 2015 in Querying / Browsing - 3 minutes read

We’ve recently made some nice improvements to the autocomplete and assist panel that should really boost the experience when working with the notebooks or editing SQL queries in the Hive and Impala query editors.

One of the major improvements is support for complex types; structs, maps and arrays, both in the assist and autocomplete. See more of the improvements below or take a look at the following video demo.

 

A longer more detailed version is available here.

 

Complex in a simple way…

The assist panel now support complex types for Hive and Impala. Just click on the column and it’ll expand any of the structs, maps and arrays.

We’ve made the assist panel resizable, which is very handy when you have long table or column names or deep nested structures.

 

If you find what you’re looking for in the panel you can double-click the item to insert it at the cursor in the active editor. You can also drag-and-drop it anywhere in the editor if you prefer another location. It knows about the structure and will insert the reference with all the parents up to and including the column name.

 

Ctrl+space is your friend!

You can use ctrl+space anywhere in the editor to activate the autocomplete. It will make suggestion based on the schema and it will also take the contents of the statement that you’re editing into account. Apart from the SQL keywords, tables and columns it will even suggest user-defined aliases.

 

It knows about complex types for Hive and Impala and will make the appropriate suggestions based on the reference that you’re currently editing.

 

I heard you like exploded views! The autocomplete will help you with these, it keeps track of the exploded views as well as exploded views of exploded views of exploded views of…

 

Values and HDFS paths

We’ve even added sample values to the mix. It’s currently only available for Impala and it will suggest a subset of all the values, this is really nice when working with for instance map keys or to give you an idea of the data.

 

Last but not least, the autocomplete can now suggest HDFS paths. Just type ‘/’ in one of the notebook snippets and it will automatically open the autocomplete panel with the list of folders and files at that location, of course you can also activate it with ctrl+space when editing an existing path.

 

We’ll keep improving the assist and autocomplete experience (support for HBase, any JDBC database, HDFS…) and hope that these new features will be useful for you!

Feel free to send feedback on the hue-user list or @gethue!


comments powered by Disqus

More recent stories

25 December 2019
A more collaborating Datawarehousing Experience with SQL query sharing via links or gists
Read More
05 December 2019
Hue 4.6 and its improvements are out!
Read More
13 November 2019
Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
Read More