2016-06-30-new-sql-editor.md 3.0 KB


title: New SQL Editor author: admin type: post date: 2016-06-30T17:49:47+00:00 url: /new-sql-editor/ 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 categories:
  • Querying ---

Here is the new SQL Editor!

Hue now has a generic editor that supports any languages but currently focuses on SQL. It is a single page app that is much faster than before and simpler to use. Here is a list of some important functionalities and a video demo that show them in action:

  • No page reload when switching between queries
  • Live history of running and past queries
  • Enhanced support for Hive and Impala
  • Extendable to any programming language

{{< youtube LvTWPgkrdvM >}}

Summary

  • Metadata Browsing
    • Support listing and filtering thousands of databases or tables
    • Quick links to table browsers
    • Statistics
  • Query edition
    • Smart autocomplete
    • Format a query, search and replace
    • Parameterization
    • Expanded view, fixed column/row headers, jump to a column..
    • Bar, pie, marker map, gradient map, scater plots charting
    • Links to jobs and logs
    • Solr SQL support
    • JDBC support (beta)
  • Result manipulation

 

We hope that this new editor makes you SQL on Hadoop even more productive! If you want to connect with other databases and engines, feel free to write a new connector or engage the community on the hue-user list. The next iteration in Hue 3.11 (~Q3 2016) will polish even more the user experience so any feedback (bug, feature..) is welcomed!

 

Grid result view

 

Result widget view