Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community BlogsRead the Announcement
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,251 Views
0 Kudos
Version history
Last update:
‎08-17-2019 08:13 AM
Updated by:
Contributors