Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)
avatar
Expert Contributor

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

1,017 Views
0 Kudos
Version history
Last update:
‎08-17-2019 08:13 AM
Updated by:
Contributors