SQL Assist and Autocomplete Improvements

SQL Assist and Autocomplete Improvements

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.

Assist_complex

 

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.

Autocomplete_join_alias

 

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

Autocomplete_nested_struct

 

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…

Autocomplete_exploded

 

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.

Autocomplete_sample_values

 

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.

Autocomplete_hdfs

 

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!