1.下载kylin
URL:http://mirrors.hust.edu.cn/apache/kylin/apache-kylin-2.0.0/apache-kylin-2.0.0-bin-cdh57.tar.gz
2. 解压kylin
[root@kylin kylin]# tar -zxvf apache-kylin-2.0.0-bin-cdh57.tar.gz
3. 配置kylin
3.1修改kylin.properties#在文件结尾添加本节点的ip:
kylin.rest.servers=172.16.16.222:7070
3.2添加kylin环境变量
[root@kylin kylin]# vi /etc/profile
export JAVA_HOME=/usr/java/jdk1.8.0_45
export JRE_HOME=$JAVA_HOME/jre
export CLASSPATH=$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATH
#export PATH=$JAVA_HOME/bin:$JRE_HOME/bin:$PATH
export HCAT_HOME=/opt/cloudera/parcels/CDH/lib/hive-hcatalog/share/hcatalog
export HADOOP_HOME=/opt/cloudera/parcels/CDH-5.7.5-1.cdh5.7.5.p0.3/lib/hadoop
export HBASE_HOME=/opt/cloudera/parcels/CDH-5.7.5-1.cdh5.7.5.p0.3/lib/hbase
export HIVE_HOME=/opt/cloudera/parcels/CDH-5.7.5-1.cdh5.7.5.p0.3/lib/hive
#export KYLIN_HOME=/usr/software/kylin/apache-kylin-1.6.0-cdh5.7-bin
export KYLIN_HOME=/usr/software/kylin/apache-kylin-2.0.0-bin
export PATH=$JAVA_HOME/bin:$HADOOP_HOME/bin:$HBASE_HOME/bin:HIVE_HOME/bin:$HCAT_HOME/bin:$PATH
4. 启动及访问kylin
#进入kylin目录
[root@kylin bin]# ./kylin.sh start
最后输出,表示启动成功:
A new Kylin instance is started by root,stop it using "kylin.sh stop"
Please visit http://<ip>:7070/kylin
You can check the log at /usr/software/kylin/apache-kylin-2.0.0-cdh5.7-bin/logs/kylin.log
检查kylin是否启动成功
[root@kylin bin]# netstat -nlp |grep 7070
tcp 0 0 0.0.0.0:7070 0.0.0.0:* LISTEN 31213/java
注意:
启动kylin的前提是CDH的hive和hbase已经启动。否则会报错。
打开浏览器访问kylin
http://172.16.16.222:7070/kylin/login
账号: ADMIN 密码:KYLIN
5. 安装问题
[root@kylin bin]# ./kylin.sh start
KYLIN_HOME is set to /usr/software/kylin/apache-kylin-2.0.0-cdh5.7-bin
mkdir: Permission denied: user=root, access=WRITE, inode="/":hdfs:supergroup:drwxr-xr-x
failed to create /kylin, Please make sure the user has right to access /kylin
原因:启动kylin,默认会在HDFS上创建/kylin目录,需要hdfs权限
解决: 打开cloudera manager的管理界面,选择HDFS--配置
去掉"检查HDFS权限"的勾选
6. 测试kylin自带实例
[root@kylin bin]# ./sample.sh
buid core
查看作业运行结果:
执行Query:
select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt
配置完成!