Editor

The goal of Hue’s Editor is to be make data querying easy and productive. It is available in Editor or Notebook mode.

The Editor focuses on Apache Hive and Apache Impala (incubating) but is also compatible with:

Here is a video of the Editor in action (in Hue 3 interface and not Hue 4):

SQL

Main features:

Editor’s Layout

 

Configure by just pointing Hue to your HiveServer2, Impala etc.. in the hue.ini, e.g.

[beeswax]
  # Host where HiveServer2 is running.
  hive_server_host=localhost

[impala]
  # Host of the Impala Server (one of the Impalad)
  server_host=localhost

[notebook]
  [interpreters]]
    [[[mysql]]]
       name=MySql JDBC
       interface=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.

Pig

Read more about it on http://gethue.com/hadoop-tutorial-language-assistant-in-pig-editor-with/.

 

Spark

Batch

This is a quick way to submit any Jar or Python jar/script to a cluster. Read more on http://gethue.com/how-to-schedule-spark-jobs-with-spark-on-yarn-and-oozie/.

Interactive

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.

Other engines

Other modes like MapReduce, Java, Shell, Sqoop are also available. A tutorial about how to create a connector for any engine you want is in progress.