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:

%jdbc(hive)

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

%jdbc(hive)
SELECT * FROM db_name;

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

Copy Hive jar files to /usr/hdp/current/zeppelin-server/interpreter/jdbc (or create a soft link).
On the Interpreters page in the Zeppelin Web UI, restart the JDBC interpreter.

The JDBC interpreter connects via Thrift.