Apache Zepplin使用Hive Interpreter查询

1.Hadoop

a).配置core-site.

hadoop文件core-site. 中配置信息如下，重启HDFS

<property>    <name>hadoop.proxyuser.hadoop.hosts</name>    <value>*</value></property><property>    <name>hadoop.proxyuser.hadoop.groups</name>    <value>*</value></property>

b).启停HDFS

## 启动HDFS./hadoop/sbin/start-dfs.sh## 停止HDFS./hadoop/sbin/stop-dfs.sh

c).HDFS退出安全模式

./hadoop/bin/hdfs dfsadmin -safemode leave

2.Hive

a).配置hive-site.

修改hive-site. 中thrift相关配置项

## 配置host和port<property>    <name>hive.server2.thrift.port</name>    <value>10000</value></property><property>    <name>hive.server2.thrift.bind.host</name>    <value>hostname</value></property>## 访问权限<property>    <name>hive.scratch.dir.permission</name>    <value>755</value></property>

b).启动

## 启动server2./hive/bin/hive --service server2## 启动thrift服务./hive/bin/hive --service  store -p 9083

3.Zeppline配置Hive Interpreter

a).创建Hive Interpreter

Interpreter Name: hive
Interpreter Group: jdbc

b).配置Hive Interpreter

hive.driver: org.apache.hive.jdbc.HiveDriver
hive.url: jdbc:hive2://hostname:10000
dependencies: hive-jdbc-.jar,hive-service-.jar,hadoop-common-.jar,protobuf-java-.jar

4.查询

show data s

use data

show tables

agg query