Skip to main content
zzeng
Gold ⭐️⭐️
Gold ⭐️⭐️
March 21, 2018

How to execute HIVE LLAP queries from Zeppelin 0.7.0 in HDP 2.6.4

  • October 5, 2026 at 9:12 AM
  • 0 replies
  • 1391 views
  • Translate All

In Zeppelin 0.7.0 Document, it is said that library should use 0.13.

Reference :

How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

Hive Interpreter for Apache Zeppelin

However it is too old.

65409-4cpjf.png

For LLAP, it need to be newer one.

Properties :
hive2.driver = org.apache.hive.jdbc.HiveDriver
hive2.url = < can be obtained from ambari. check HiveServer2 Interactive JDBC URL >
eg.
hive2.url = jdbc:hive2://zzeng-hdp-3.example.com:2181,zzeng-hdp-1.example.com:2181,zzeng-hdp-2.example.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2


Dependencies :
org.apache.hive:hive-jdbc:2.2.0
org.apache.hadoop:hadoop-common:2.6.0

With this setting, I can access Hive LLAP now:

65410-g4yzk.png