title: Hue 4.7 and its improvements are out!
author: Hue Team
type: post
date: 2020-04-10T02:36:35+00:00
url: /blog/hue-4-7-and-its-improvements-are-out/
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
- Version 4.7
Release
Hi Data Explorers,
The Hue Team is glad to thanks all the contributors and release Hue 4.7!

The focus of this release was to keep building on top of 4.6, modularize the tech stack, improve SQL integrations and prepare major features of Hue 5. Some highlights:
This release comes with 650+ commits and 100+ bug fixes! For all the changes, check out the release notes.
Go grab it and give it a spin!
Here is a selection of the improvements:
SQL
- Foreign Keys are showing-up in the SQL left assist
- The autocomplete grammar was updated with: INTEGER, CTAS, STREAM keyword, EXPLAIN, LOAD, SHOW MATERIALIZED VIEW, ALTER MATERIALIZED VIEW, DROP MATERIALIZED VIEW
- Materialized views are showing-up with the proper eye icon
- Hive LLAP/Tez sessions management was revamped in order to support more than one query running concurrently
- The Drag & Drop from the SQL left assist flakiness was fixed
- SQL samples now also work with mutable tables (e.g. ORC format tables with INSERT, DELETE, UPDATE..)
- How to build SQL Autocompletes tutorial has been updated
- SQL Autocomplete parsers are now available as a JavaScript component pluggable via a classic
npm install

Collaboration
- Queries snippets can be shared via a Gist with their own Slack previews
- Queries can be shared via public links
- The link sharing modal was restyled to be friendlier


Infra

Admin
- Configuration settings can be searched via a filter
- The delete flow of a user now disables instead of deleting (to avoid losing the saved documents and queries)
- User admin page now displays ACTIVE and SUPERUSER statuses
- The number of active users metric per API instance was revamped

Progress
- HUE-8768 The new version of the Editor with multi execution contexts and more robustness got 200+ commits
- HUE-8758 SQL connectors configuration instead of using hue.ini is close to a MVP
- HUE-8824 The Optimizations and Catalogs API were made public
- HUE-8738 The Celery Task Server and SQL task got updated for Python 3
Any feedback or question? Feel free to comment here or on the Forum and quick start SQL querying!
Onwards!