Zeepelin

参考

http://zeppelin.apache.org/docs/0.8.2/quickstart/install.html#install

http://zeppelin.apache.org/docs/0.8.2/interpreter/hive.html

http://zeppelin.apache.org/docs/0.8.2/interpreter/jdbc.html#apache-hive

 

介绍

基于web的笔记本，支持数据驱动、交互式数据分析和协作文档，支持SQL、Scala等

 

下载

从Apache官网下载zeppelin-0.8.2-bin-all.tgz二进制安装包

 

配置

修改文件zeppelin-site.xml，如下

<property>
  <name>zeppelin.server.addr</name>
  <value>192.168.1.99</value>
  <description>Server binding address</description>
</property>

<property>
  <name>zeppelin.server.port</name>
  <value>7777</value>
  <description>Server port.</description>
</property>

 

启动

配置完环境变量后启动

zeppelin-daemon.sh start

 

界面

 

整合Hive

属性Properties

Property	Value
hive.driver	org.apache.hive.jdbc.HiveDriver
hive.url	jdbc:hive2://localhost:10000
hive.user	hiveUser
hive.password	hivePassword

依赖Dependencies（要从Hive中找到hive-jdbc-2.3.4.jar，Hadoop中hadoop-common-2.7.7.jar）

Artifact	Exclude
org.apache.hive:hive-jdbc:0.14.0
org.apache.hadoop:hadoop-common:2.6.0

配置Configuration

Property	Default	Description
default.driver	org.apache.hive.jdbc.HiveDriver	Class path of JDBC driver
default.url	jdbc:hive2://localhost:10000	Url for connection
default.user		( Optional ) Username of the connection
default.password		( Optional ) Password of the connection
default.xxx		( Optional ) Other properties used by the driver
${prefix}.driver		Driver class path of %hive(${prefix})
${prefix}.url		Url of %hive(${prefix})
${prefix}.user		( Optional ) Username of the connection of %hive(${prefix})
${prefix}.password		( Optional ) Password of the connection of %hive(${prefix})
${prefix}.xxx		( Optional ) Other properties used by the driver of %hive(${prefix})

 

 

未完待续。。。