title: Cloudera Enterprise 5.7 brings a faster and prettier SQL in Hue author: admin type: post date: 2014-04-25T22:32:36+00:00 url: /cloudera-enterprise-5-7-brings-a-faster-and-prettier-hue-for-sql/ sf_remove_promo_bar:
Cloudera Enterprise 5.7 brings a lot of changes (more than 1500) to HUE (the Web interface for querying and browsing data). The emphasize on performances and security continues from 5.5 as well as the improvement of the SQL user experience.
The app is now single page and offers speed and more accessible statistics and data preview. See more of the improvements below or take a look at the following video demo.
{{< youtube MykO9McaxCk >}}
Fresh restart
The front-end has been rewritten to be slicker and more user-friendly. More information is displayed and navigating across tabs is seamless as it no longer entails a page refresh.
Single page app: first, now the initial page loads very quickly and fetches asynchronously the list of tables, table statistics, data sample, partition list. We are not blocking anymore until everything is queried in Hive. Subsequent navigation clicks will trigger only 1 or 2 calls to the server, instead of reloading all the page resources again. As an added bonus, the browser history now works on all the pages.

Caching: The new assist caches all the Hive metadata. The pages listing tables and database also point to the same cache, as well as the editor autocomplete. This means that now the fetching of thousand of Hive tables and databases will only happen once. On the Hive side, these calls have even been optimized for taking seconds instead of previously minutes (HIVE-7575).
Don’t freeze my browser: on top of the caching, Hue is now much smarter and only displays the elements visible on the screen. For example if the user has a list of 5000 tables, only tens of them will actually be rendered (the rendering is the costly part).
(Read more here).
The most used app in HUE is getting a
##
idle_session_timeout secondslogin_splash_htmlkey_file_passwordxmlsec_binaryResult in the Grid Widget can be plotted like in the SQL editor. This is ideal for clicking visualizing the rows returned by the search query.
Hue supports Solr Suggesters and makes your data easier to search! Suggester assists the user by proposing an auto-completable list of queries:
{{< youtube RupOQCy5DdA >}}
(Read more here).
Right click on a file or directory to access their disk space consumed, quotas and number of directories and files.
(Read more here).
Next CDH version (5.8) of Hue will be rebased on Hue 3.10 that was released this May. On top of hundreds of improvements it brings a revamp of the SQL editor and the home page!
If you have any questions or feedback, feel free to comment here, on the hue-user list or via @gethue!