1 下载
官方地址:
http://zeppelin.apache.org/
2 修改 conf/zeppelin-env.sh, export SPARK_HOME
3 修改conf/zeppelin-site.xml 中的 zeppelin.server.port
cp zeppelin-site.xml.template zeppelin-site.xml
vim zeppelin-site.xml
4 Starting Apache Zeppelin
bin/zeppelin-daemon.sh start
hjr:8089
5 测试
5.1 年龄的分布
val bankText = sc.textFile("/Zeppelin/bank-full.csv")
case class Bank(age:Integer, job:String, marital : String, education : String, balance : Integer)
val bank = bankText.map(s=>s.split(";")).filter(s=>s(0)!="\"age\"").map(
s=>Bank(s(0).toInt,
s(1).replaceAll("\"", ""),
s(2).replaceAll("\"", ""),
s(3).replaceAll("\"", ""),
s(5).replaceAll("\"", "").toInt
)
)
// Below line works only in spark 1.3.0.
// For spark 1.1.x and spark 1.2.x,
// use bank.registerTempTable("bank") instead.
bank.toDF().registerTempTable("bank")
%sql select age, count(1) from bank where age < 30 group by age order by age
5.2 动态输入maxAge参数
%sql select age, count(1) from bank where age < ${maxAge=30} group by age order by age
5.3 根据婚姻状况选项,查看年龄分布状况
%sql select age, count(1) from bank where marital="${marital=single,single|divorced|married}" group by age order by age
6 运行 Zeppelin Tutorial/Basic Features (Spark)
参考: