--- title: Hue 4.2 and its Self Service BI improvements are out! author: admin type: post date: 2018-04-04T17:30:45+00:00 url: /hue-4-2-and-its-self-service-bi-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 - Release --- Hi Big Data Explorers,   The Hue Team is glad to thanks all the contributors and release Hue 4.2! [][1] Last Hue version compatible with Python 2.6, next will be 2.7 only as a major upgrade is coming next. The focus of this release was to keep making progress on the self service BI theme and prepare the ground for next release that will include an upgraded backend and a revamped Dashboard and more improvements to the Data Catalog and Query Assistance. This release comes with 1200 commits and 500+ bug fixes! Go grab the tarball and give it a spin!


Download

Here is a list of the main improvements. For all the changes, check out the [release notes][2] and for a quick try open-up [demo.gethue.com][3]. # Summary 3 main areas of focus Cloud
  • ADLS Browser
  • Analytic DB
  • Top Search UX
  • SQL Syntax checker
  • Impala Query Browser
  • Supportability
  • SAML update
  • Documentation revamp
  • Metric page
  •   # Cloud [ADLS Browser][4] (similar to HFS & [S3 Browser][5])
  • Exploring ADLS in file browser
  • Create Hive Tables Directly From ADLS
  • Save Query Results to ADLS
  • [][6] # Analytical DB ## Data Catalog Search
  • Available in the top bar
  • Since 5.11 but getting simpler
  • Search Tables, Columns and Saved queries
  • Example of searches:
  • table:customer → Find the customer table
  • table:tax* tags:finance → List all the tables starting with tax and tagged with ‘finance’
  • [][7]   ## Syntax Checker * Warn before executing * Can suggest simple fix [][8][][9]   ## Impala Query Browser Goal: built-in Troubleshooting for: * Queries * Profiles * Plans * Memory [Read more in this blog post.][10]   [][11]   # Dashboard Apache Solr dynamic Dashboards:
  • Dashboard autocomplete
  • More Like This
  • Collection page
  • [][12] [][13]   # Supportability
  • SAML update (with idle session fix)
  • Documentation revamp
  • Thread page
  • [][14]
  • Bug fixes
  •   # Demo use case: Customer 360 In this [Self Service analytics Customer 360 demo][15] we use the [Editor][16] to query credit card transaction data that is saved in an object store in the cloud ([here S3][5]) and in a Kudu table. The demos leverages the Data Catalog search and tagging as well as the Query Assistant. [][17] Onwards!   As usual thank you to all the project contributors and for sending feedback and participating on the [hue-user][18] list or [@gethue][19]! p.s.: in case the Dropbox link doesn't work on the network you are currently in, here's a [mirror of the release][20].   [1]: https://cdn.gethue.com/uploads/2015/08/hue-logo-copy.png [2]: http://cloudera.github.io/hue/docs-4.2.0/release-notes/release-notes-4.2.0.html [3]: http://demo.gethue.com/ [4]: https://gethue.com/browsing-adls-data-querying-it-with-sql-and-exporting-the-results-back-in-hue-4-2/ [5]: https://gethue.com/introducing-s3-support-in-hue/ [6]: https://cdn.gethue.com/uploads/2017/11/image2.png [7]: https://cdn.gethue.com/uploads/2018/01/top_search.png [8]: https://cdn.gethue.com/uploads/2018/01/syntax_checkerhigh.png [9]: https://cdn.gethue.com/uploads/2018/01/checker_help.png [10]: https://gethue.com/browsing-impala-query-execution-within-the-sql-editor/ [11]: https://cdn.gethue.com/uploads/2017/11/General.png [12]: https://cdn.gethue.com/uploads/2018/01/solr_more_like_this.png [13]: https://cdn.gethue.com/uploads/2018/01/dashboard_autocomplete.png [14]: https://cdn.gethue.com/uploads/2018/01/hue_metric_page.png [15]: https://gethue.com/self-service-bi-doing-a-customer-360-by-querying-and-joining-salesforce-marketing-and-log-datasets/ [16]: https://gethue.com/sql-editor/ [17]: https://cdn.gethue.com/uploads/2017/10/customer-360-datasets.png [18]: http://groups.google.com/a/cloudera.org/group/hue-user [19]: https://twitter.com/gethue [20]: https://cdn.gethue.com/downloads/releases/4.2.0/hue-4.2.0.tgz