Apache Zeppelin Component Guide
Also available as:

Using the %jdbc Interpreter to Access Hive

The %jdbc interpreter supports access to Apache Hive data.

To use the JDBC interpreter for Hive access, specify the following directive:


Next, add the statement that accesses Hive; here is a sample paragraph:

SELECT * FROM db_name;

If you receive an error, you might need to complete the following two additional steps:

  1. Copy Hive jar files to /usr/hdp/current/zeppelin-server/interpreter/jdbc (or create a soft link).

  2. On the Interpreters page in the Zeppelin Web UI, restart the JDBC interpreter.

The JDBC interpreter connects via Thrift.