Apache Zepplin使用Hive Interpreter查询

1.Hadoop

a).配置core-site.xml

hadoop文件core-site.xml中配置信息如下，重启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.xml

修改hive-site.xml中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 metastore -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 databases

use database

show tables

agg query