Community Articles

Find and share helpful community-sourced technical articles.
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,125 Views
0 Kudos