Fei's Blog
0%

Zeppelin Connects Hive

Posted on In ,

Make sure that Hive can be accessed remotely using HiveServer2

* `bash-4.2$ beeline`
* `beeline> !connect jdbc:hive2://svr-A3-A-U2:10000 hive hive`
* if unable to access, check the following configuration in `HIVE_HOME/conf/hive-site.xml`
    
1
2
3
4
5
6
7
8
9
10
<property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
        <description>ername to use against metastoredatabase</description>
</property>
<property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>123456</value>
        <description>password to use against metastoredatabase</description>
</property>

Move configuration file

$HIVE_HOME/conf/hive-site.xml to $ZEPPELIN_HOME/conf/hive-site.xml

Configure the Hive Interpreter as following

1
2
3
4
5
6
7
8
9
Properties
name	value
common.max_count	1000
default.driver	org.apache.hive.jdbc.HiveDriver
default.url	jdbc:hive2://svr-A3-A-U2:10000
hive.password	hive
hive.url	jdbc:hive2://svr-A3-A-U2:10000
hive.user	hive
zeppelin.interpreter.localRepo	/var/lib/hadoop-hdfs/zeppelin/zeppelin/local-repo/2BX55P5UD



1
2
3
4
Dependencies
artifact	exclude
org.apache.hadoop:hadoop-common:2.6.0-cdh5.5.1
org.apache.hive:hive-jdbc:1.1.0-cdh5.5.1

Test connection

1
2
3
4
5
%hive
use default

%hive
show tables