Editor

Hue’s Editor goal is to brings data querying productivity up.

It focuses on SQL but is generic and connects to other engines like Pig, MapReduce, Spark or any type of database. It is available in Editor or Notebook mode.

SQL Editor

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

Read more about it here…

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"}'

sql-editor

 

Pig Editor

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

 

Spark

Batch

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.

Multiple Snippet Types