--- title: 'Additional SQL improvements: Built-in Impala language reference, Improved column samples, Dark Mode' author: admin type: post date: 2018-10-17T14:57:54+00:00 url: /additional-sql-improvements-in-hue-4-3/ sf_thumbnail_type: - none sf_thumbnail_link_type: - link_to_post sf_detail_type: - none sf_page_title: - 1 sf_page_title_style: - standard sf_no_breadcrumbs: - 1 sf_page_title_bg: - none sf_page_title_text_style: - light sf_background_image_size: - cover sf_social_sharing: - 1 sf_related_articles: - 1 sf_sidebar_config: - left-sidebar sf_left_sidebar: - Sidebar-2 sf_right_sidebar: - Sidebar-1 sf_caption_position: - caption-right sf_remove_promo_bar: - 1 ampforwp-amp-on-off: - default categories: - Version 4 --- Hi SQL enthusiasts! We've made quite some improvements to the SQL experience in [Hue 4.3][1], in a previous [post][2] we showed some of the new exploration improvements and now we'd like to show some additional new features in the editor. After the introduction of the UDF reference panel we've received requests to also include documentation for SQL syntax. It's quite common to look at the [language reference][3] while writing certain statements and it's annoying to have to have multiple windows open. So, to give you the best experience possible we decided to include the complete Impala SQL language reference in Hue! ## Built-in Impala language reference You can find the Language Reference in the right assist panel. The right panel itself has a new look with icons on the left hand side and can be minimised by clicking the active icon. The filter input on top will only filter on the topic titles in this initial version. Below is an example on how to find documentation about joins in select statements.
The new language reference panel
][4]
## Improved column samples
It's quite handy to be able to look at column samples while writing a query to see what type of values you can expect. Hue now has the ability to perform some operations on the sample data, you can now view distinct values as well as min and max values. Expect to see more operations in coming releases.
Show distinct sample values
