---
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][1]. 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][2]
* Extendable to any programming language
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][3]
* [JDBC support (beta)][4]
* Result manipulation
* Share
* Excel, csv downloads
* Export to an HDFS file or new table
* [Drag & Drop a saved query into a workflow][5]
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][6] or engage the community on the [hue-user][7] list. The next iteration in Hue 3.11 (~Q3 2016) will polish even more the user experience so any feedback (bug, feature..) is [welcomed][8]!
Grid result viewResult widget view
[1]: https://gethue.com/category/sql/
[2]: http://impala.io
[3]: https://gethue.com/sql-editor-for-solr-sql/
[4]: https://gethue.com/custom-sql-query-editors/
[5]: https://gethue.com/drag-drop-saved-hive-queries-into-your-workflows/
[6]: https://github.com/cloudera/hue/tree/master/desktop/libs/notebook/src/notebook/connectors
[7]: http://groups.google.com/a/cloudera.org/group/hue-user
[8]: https://twitter.com/gethue
[9]: https://cdn.gethue.com/uploads/2016/06/editor-grid.png
[10]: https://cdn.gethue.com/uploads/2016/06/editor-map.png