Editor

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.

SQL

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.

See How to write your own SQL parser. Integrating Apache Calcite, ZetaSql… would make SQL users even happier with a lot more Databases!

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

JDBC

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

Others

Jobs

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.

Oozie

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

Spark / Livy

Based on the Livy REST API

Dashboard

Dashboards are generic and support Solr and any SQL:

The API was influenced by Solr but is now generic:

Dashboard API

SQL

SQL API

Implementations:

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

Solr Dashboard API

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