KYLIN基于CDH入门实战（2）之kylin安装

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 

跑完以后，重启kylin，选择learn_kylin项目

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

配置完成！