They provide SQL integration with any database via several connectors (native, JDBC, SQL Alchemy…).

Other modes like MapReduce, Java, Shell, Sqoop are also available. Here is a list of the existing connectors.

Connectors are pluggable and can new engines can be supported. Feel free to comment on the Hue list of github about it.


The Editor Configuration also describes the configuration steps.

Close to 100% of Hive and Impala grammar is supported which makes the autocomplete extremly powerful. Other languages defaults to a generic SQL grammar.

Coming Soon How to write your own SQL parser.

HiveServer2 API

Hive, Impala, SparkSQL

SQL Alchemy

SQL Alchemy is the prefered way if the HiveServer2 API is not supported by the database. More enterprise support will come with HUE-8740.

Python Connectors

MySQL, Oracle, PostgreSQL, Phoenix, Presto, Kylin, Redshift, BigQuery, Drill


Use the query editor with any JDBC compatible database. View the JDBC connector.

Note Going forward, SQL Alchemy is prefered as more “Python native”.

Solr SQL

Solr connector



The Job Browser is generic and can list any type of jobs, queries and provide bulk operations like kill, pause, delete… and access to logs and recommendations.


MapReduce, Pig, Java, Shell, Sqoop, DistCp Oozie connector

Spark / Livy

Based on the Livy REST API


Dashboards are generic and support Solr and any SQL:

The API was influenced by Solr but is now generic:

Dashboard API




When HS2, RDBMS, and JDBC Are Not Enough

If the built-in HiveServer2 (Hive, Impala, Spark SQL), RDBMS (MySQL, PostgreSQL, Oracle, SQLite), and JDBC interfaces don’t meet your needs, you can implement your own connector to the notebook app: Notebook Connectors. Each connector API subclasses the Base API and must implement the methods defined within; refer to the JdbcApi or RdbmsApi for representative examples.


Solr Dashboard API

A connector similar to Solr or SQL Alchemy binding would need to be developed HUE-7828