Support Questions
Find answers, ask questions, and share your expertise

How do I get independent service Zeppelin to see Hive?

Expert Contributor

I am using HDP- but I need Zeppelin 0.8, so I have installed it as an independent service. When I run:

show tables

I get nothing back and I get 'table not found' when I run Spark2 SQL commands. These tables exist in the 0.7 Zeppelin.

Can anyone tell me what I am missing?

The steps I performed to create the zep0.8 are as follows:

maven clean package -DskipTests -Pspark-2.1 -Phadoop-2.7-Dhadoop.version=2.7.3 -Pyarn -Ppyspark -Psparkr -Pr -Pscala-2.11

Copied zeppelin-site.xml and shiro.ini from /usr/hdp/ to /home/ed/zeppelin/conf.

created /home/ed/zeppelin/conf/ in which I put the following:

export JAVA_HOME=/usr/jdk64/jdk1.8.0_112
export HADOOP_CONF_DIR=/etc/hadoop/conf
export ZEPPELIN_JAVA_OPTS="-Dhdp.version="

Copied /etc/hive/conf/hive-site.xml to /home/ed/zeppelin/conf