zeppelin配置和使用hive

添加hive配置文件和jar包到zeppelin

[root@mihaoyu151 bin]# pwd
/opt/soft/zeppelin090/bin

[root@mihaoyu151 bin]# cd ../conf

[root@mihaoyu151 conf]# cp /opt/soft/hive110/conf/hive-site.xml /opt/soft/zeppelin090/conf

[root@mihaoyu151 conf]# cd ../interpreter/jdbc/
[root@mihaoyu151 jdbc]# ll
total 2060
-rw-r--r--. 1 501 wheel    2314 Mar 23  2020 ansi.sql.keywords
-rw-r--r--. 1 501 wheel    4828 Mar 23  2020 interpreter-setting.json
drwxr-xr-x. 2 501 wheel      55 Nov 15 13:40 META-INF
-rw-r--r--. 1 501 wheel    6573 Mar 23  2020 postgresql-native-driver-sql.keywords
-rw-r--r--. 1 501 wheel 2087995 Mar 23  2020 zeppelin-jdbc-0.9.0-preview1.jar

[root@mihaoyu151 jdbc]# cp /opt/soft/hadoop260/share/hadoop/common/hadoop-common-2.6.0-cdh5.14.2.jar  ./

[root@mihaoyu151 jdbc]# cp /opt/soft/hive110/lib/hive-jdbc-1.1.0-cdh5.14.2-standalone.jar ./

[root@mihaoyu151 jdbc]# ll
total 29188
-rw-r--r--. 1  501 wheel     2314 Mar 23  2020 ansi.sql.keywords
-rw-r--r--. 1 root root   3566660 Nov 15 13:51 hadoop-common-2.6.0-cdh5.14.2.jar
-rw-r--r--. 1 root root  24209431 Nov 15 13:52 hive-jdbc-1.1.0-cdh5.14.2-standalone.jar
-rw-r--r--. 1  501 wheel     4828 Mar 23  2020 interpreter-setting.json
drwxr-xr-x. 2  501 wheel       55 Nov 15 13:40 META-INF
-rw-r--r--. 1  501 wheel     6573 Mar 23  2020 postgresql-native-driver-sql.keywords
-rw-r--r--. 1  501 wheel  2087995 Mar 23  2020 zeppelin-jdbc-0.9.0-preview1.jar

启动hiveserver2和beeline

[root@mihaoyu151 ~]# nohup hive --service hiveserver2 &
[1] 2105
[root@mihaoyu151 ~]# nohup: ignoring input and appending output to ‘nohup.out’

[root@mihaoyu151 ~]# beeline -u jdbc:hive2://192.168.133.151:10000
which: no hbase in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/bin:/opt/soft/jdk180/bin:/opt/soft/zookeeper345/bin:/opt/soft/hadoop260/sbin:/opt/soft/hadoop260/bin:/opt/soft/jdk180/bin:/opt/soft/hadoop260/sbin:/opt/soft/hadoop260/bin:/opt/soft/zookeeper345/bin:/opt/soft/hive110/bin:/root/bin)
scan complete in 1ms
Connecting to jdbc:hive2://192.168.133.151:10000
Connected to: Apache Hive (version 1.1.0-cdh5.14.2)
Driver: Hive JDBC (version 1.1.0-cdh5.14.2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.14.2 by Apache Hive
0: jdbc:hive2://192.168.133.151:10000> 

启动zeppelin

[root@mihaoyu151 bin]# ./zeppelin-daemon.sh start
Log dir doesn't exist, create /opt/soft/zeppelin090/logs
Pid dir doesn't exist, create /opt/soft/zeppelin090/run
Zeppelin start                                             [  OK  ]

浏览器访问网址192.168.133.151:8000


创建Interpreter

添加配置
hive
选择jdbc

org.apache.hive.jdbc.HiveDriver
jdbc:hive2://192.168.133.151:10000
hive

返回首页

新建note

选择hive

输入
%hive
show databases;
运行

完成