The goal of the Editor is to open-up data to more users by making self service querying easy and productive.

Editor’s Layout



It is available in Editor or Notebook mode and with the Dashboard. The Editor focuses on Apache Hive and Apache Impala but is also compatible with:


Where is the data?

Find or import your data

Use the left metadata assists to browse your existing data without losing your editor. The top search will look through your saved queries and matching tables, columns and databases. Objects can be tagged for a quick retrieval or assigning a more “humane” name.

Ad-hoc import of data

If the data does not exist yet, just drag & drop it to trigger the Create Table wizard and to import it in just two steps.

Query Assistance

When you found your data, the Editor’s autocomplete is extremely powerful as they support 90-100% of the language syntax and will highlight any syntax or logical error. The right assistant provides quick previews of the datasets, which columns or JOINs are popular and recommendations on how to type optimized queries. After the querying, refine your results before exporting to S3/HDFS/ADLS or downloaded as CSV/Excel.

  • If multiple statements are present in the editor, the position of the cursor will determine what is the active statement that will be executed. In order to execute multiple statements (e.g. a series of CREATE tables) in sequence, they need to be manually highlighted or all selected via selected all shortcut (e.g. CTRL/CMD + A).

Risk alert educating the user on writing more optimized queries

Look at more functionalities here.


Variables can have default values

Parameterize your queries, read more about it.



Point Hue to any SQL engines by simplify putting the hostnames and ports in the hue.ini, e.g. for HiveServer2, Impala:

  # Host where HiveServer2 is running.

  # Host of the Impala Server (one of the Impalad)

       name=MySql JDBC
       ## Specific options for connecting to the server.
       ## The JDBC connectors, e.g. mysql.jar, need to be in the CLASSPATH environment variable.
       ## If 'user' and 'password' are omitted, they will be prompted in the UI.
       options='{"url": "jdbc:mysql://localhost:3306/hue", "driver": "com.mysql.jdbc.Driver", "user": "root", "password": "root"}'

Look at more configurations here.



Links available in record explorer via double click:





This is a quick way to submit any Jar or Python jar/script to a cluster via the Scheduler or Editor.


Hue relies on Livy for the interactive Scala, Python and R snippets.

Livy got initially developed in the Hue project but got a lot of traction and was moved to its own project on livy.io. Here is a tutorial on how to use a notebook to perform some Bike Data analysis.

Make sure that the Notebook and interpreters are set in the hue.ini, and Livy is up and running:

  # Host address of the Livy Server.


 ## Show the notebook menu or not

    # Define the name and how to connect and execute the language.

      # The name of the snippet.
      # The backend connection to use to communicate with the server.



Pig is supported via the Pig Editor.

Other engines

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.