kylin安装及配置

1.1. KYLIN安装

1.1.1.  安装环境

安装环境：

jdk-8u65-linux-x64.tar.gz

hadoop-2.6.2.tar.gz

hadoop-native-64-2.6.0.tar

zookeeper-3.4.6.tar.gz

hbase-1.1.5-bin.tar.gz

apache-hive-2.1.1-bin.tar.gz

apache-kylin-1.5.0-HBase1.1.3-bin.tar.gz

 

Hadoop版本http://hadoop.apache.org/releases.html

Hbase版本http://apache.fayea.com/hbase/

Hive版本http://mirror.bit.edu.cn/apache/hive/

使用的kylin版本：https://archive.apache.org/dist/kylin/

 

参考文档：

http://blog.csdn.net/it_taojingzhan/article/details/51789739

http://blog.csdn.net/blackenn/article/details/52234420

http://blog.csdn.net/wtq1993/article/details/53088968

 

http://mirror.bit.edu.cn/apache/zookeeper/zookeeper-3.4.6/zookeeper-3.4.6.tar.gz

wget http://archive.apache.org/dist/hbase/1.1.5/hbase-1.1.5-bin.tar.gz

wgethttp://apache.communilink.net/hive/hive-2.0.0/apache-hive-2.0.0-bin.tar.gz 

wgethttp://ftp.nchu.edu.tw/Unix/Database/MySQL/Downloads/Connector-J/mysql-connector-java-5.1.36.tar.gz 

 

wget https://dist.apache.org/repos/dist/release/kylin/apache-kylin-1.5.2.1/apache-kylin-1.5.2.1-HBase1.x-bin.tar.gz

 

 准备环境：

请参考以上hadoop，hive,hbase,zookeeper环境搭建

 

1.1.2.  Kylin1.x安装

1.1.2.1.     解压缩到/usr/local目录

[root@localhost65 download]# tar -zxf apache-kylin-1.5.0-HBase1.1.3-bin.tar.gz -C/usr/local/

[root@localhost65 download]# cd /usr/local/

[root@localhost65 local]# ls

apache-hive-1.2.2-bin              bin           hbase        jdk1.8.0_65 sbin                             vmware-tools-distrib

apache-hive-2.1.1-bin              etc           hbase-1.1.5  lib         share                            zookeeper-3.4.6

apache-kylin-1.5.0-HBase1.1.3-bin  games         hbase-1.3.1  lib64       src

apache-kylin-1.6.0-bin             hadoop-2.6.2  include     libexec     VMwareTools-9.6.1-1378637.tar.gz

[root@localhost65 local]#

[root@localhost65 local]# cdapache-kylin-1.5.0-HBase1.1.3-bin/

[root@localhost65 apache-kylin-1.5.0-HBase1.1.3-bin]#ls

bin commit_SHA1  conf  ext file:  lib  logs pid  sample_cube  tomcat

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

 

1.1.2.2.     配置kylin环境变量

[root@localhost65 local]# cdapache-kylin-1.5.0-HBase1.1.3-bin/

[root@localhost65 apache-kylin-1.5.0-HBase1.1.3-bin]#ls

bin commit_SHA1  conf  ext file:  lib  logs pid  sample_cube  tomcat

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#vim /etc/profile

exportKYLIN_HOME=/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin

exporthive_dependency=/hadoop/hive/conf:/hadoop/hive/lib/*:/hadoop/hive/hcatalog/share/hcatalog/hive-hcatalog-core-2.0.0.jar #添加hive依赖包

exportKYLIN_CONF=$KYLIN_HOME/conf

exportPATH=$KYLIN_HOME/bin:$PATH

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

使用kylin的环境变量生效：

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# source /etc/profile

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

查看环境变量是否生效:

[root@localhost65 hbase-1.1.5]# echo $KYLIN_HOME

/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

1.1.2.3.     修改kylin.sh文件

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# $KYLIN_HOME/bin/kylin.sh

vi/home/grid/kylin/bin/kylin.sh
需要对此脚本做两点修改：
export KYLIN_HOME=/home/grid/kylin # 改成绝对路径
 exportHBASE_CLASSPATH_PREFIX=${tomcat_root}/bin/bootstrap.jar:${tomcat_root}/bin/tomcat-juli.jar:${tomcat_root}/lib/*:$hive_dependency:$HBASE_CLASSPATH_PREFIX#在路径中添加$hive_dependency

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

1.1.2.4.     修改kylin.properties文件

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# ls

bin commit_SHA1  conf  ext file:  lib  logs pid  sample_cube  tomcat

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# cd conf/

[root@localhost65 conf]# ls

kylin_hive_conf.xml  kylin_job_conf.xml  kylin.properties

[root@localhost65 conf]# vim kylin.properties

# List of web servers in use, this enablesone web server instance to sync up with other servers.

kylin.rest.servers=192.168.3.65:7070

 

kylin.job.jar=$KYLIN_HOME/lib/kylin-job-1.5.0-SNAPSHOT.jar

kylin.coprocessor.local.jar=$KYLIN_HOME/lib/kylin-coprocessor-1.5.0-SNAPSHOT.jar

 

[root@localhost65 conf]#

 

1.1.2.5.     检查配置环境

检查环境是否OK  ，因为kylin要使用hive表,hdfs，hbase表，并且可以进行submit job

执行$KYLIN_HOME/bin/check-env.sh 看看是否正常

正常情况下，只会输出kylin环境变量地址

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# $KYLIN_HOME/bin/check-env.sh

KYLIN_HOME is set to/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

1.1.2.6.     启动kylin服务

$KYLIN_HOME/bin/kylin.sh start 将kylin进程run起来

Run起来后会输出日志，同时在$KYLIN_HOME/logs也会打出日志

 

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# $KYLIN_HOME/bin/kylin.shstart

KYLIN_HOME is set to/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/../

kylin.security.profile is set to testing

 

Logging initialized using configuration infile:/usr/local/apache-hive-2.1.1-bin/conf/hive-log4j2.properties Async: true

HIVE_CONF is set to: /usr/local/apache-hive-2.1.1-bin/conf,use it to locate hive configurations.

HCAT_HOME is set to:/usr/local/apache-hive-2.1.1-bin/hcatalog, use it to find hcatalog path:

hive dependency:/usr/local/apache-hive-2.1.1-bin/conf:/usr/local/apache-hive-2.1.1-bin/lib/jamon-runtime-2.3.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/geronimo-jaspic_1.0_spec-1.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/netty-all-4.0.23.Final.jar:/usr/local/apache-hive-2.1.1-bin/lib/snappy-0.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-common-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-common-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jasper-runtime-5.5.23.jar:/usr/local/apache-hive-2.1.1-bin/lib/findbugs-annotations-1.3.9-1.jar:/usr/local/apache-hive-2.1.1-bin/lib/super-csv-2.2.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/hamcrest-core-1.3.jar:/usr/local/apache-hive-2.1.1-bin/lib/guice-servlet-3.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/jsp-api-2.1-6.1.14.jar:/usr/local/apache-hive-2.1.1-bin/lib/ant-1.9.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-dbcp-1.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-protocol-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/curator-recipes-2.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/maven-scm-provider-svnexe-1.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-math-2.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/servlet-api-2.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-shims-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-common-1.1.1-tests.jar:/usr/local/apache-hive-2.1.1-bin/lib/antlr-2.7.7.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-llap-client-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/datanucleus-core-4.1.6.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-cli-1.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/jsp-api-2.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/activation-1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jetty-sslengine-6.1.26.jar:/usr/local/apache-hive-2.1.1-bin/lib/groovy-all-2.4.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/bonecp-0.8.0.RELEASE.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-compress-1.9.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-server-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-logging-1.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-hadoop-compat-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jasper-compiler-5.5.23.jar:/usr/local/apache-hive-2.1.1-bin/lib/velocity-1.5.jar:/usr/local/apache-hive-2.1.1-bin/lib/gson-2.2.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/protobuf-java-2.5.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/antlr-runtime-3.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/json-20090211.jar:/usr/local/apache-hive-2.1.1-bin/lib/metrics-jvm-3.1.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-llap-tez-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/guice-assistedinject-3.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/stax-api-1.0.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-hplsql-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/ST4-4.0.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/ant-1.6.5.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-shims-common-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-httpclient-3.0.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/htrace-core-3.1.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/junit-4.11.jar:/usr/local/apache-hive-2.1.1-bin/lib/libfb303-0.9.3.jar:/usr/local/apache-hive-2.1.1-bin/lib/curator-framework-2.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/curator-client-2.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-compiler-2.7.6.jar:/usr/local/apache-hive-2.1.1-bin/lib/opencsv-2.3.jar:/usr/local/apache-hive-2.1.1-bin/lib/ant-launcher-1.9.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/asm-3.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/netty-3.7.0.Final.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-service-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/snappy-java-1.0.5.jar:/usr/local/apache-hive-2.1.1-bin/lib/regexp-1.3.jar:/usr/local/apache-hive-2.1.1-bin/lib/guava-14.0.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/derby-10.10.2.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/tephra-api-0.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/accumulo-fate-1.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/log4j-1.2-api-2.4.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jackson-core-2.4.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-ant-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jsp-2.1-6.1.14.jar:/usr/local/apache-hive-2.1.1-bin/lib/geronimo-jta_1.1_spec-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/mysql-connector-java-5.1.10.jar:/usr/local/apache-hive-2.1.1-bin/lib/datanucleus-api-jdo-4.2.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/maven-scm-provider-svn-commons-1.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/javolution-5.5.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/fastutil-6.5.6.jar:/usr/local/apache-hive-2.1.1-bin/lib/jsr305-3.0.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-annotations-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-hadoop2-compat-1.1.1-tests.jar:/usr/local/apache-hive-2.1.1-bin/lib/jackson-annotations-2.4.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/httpclient-4.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/paranamer-2.3.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-contrib-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jsp-api-2.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/maven-scm-api-1.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/asm-commons-3.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/slider-core-0.90.2-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/tephra-hbase-compat-1.0-0.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-storage-api-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/joda-time-2.5.jar:/usr/local/apache-hive-2.1.1-bin/lib/metrics-core-2.2.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/jetty-all-7.6.0.v20120127.jar:/usr/local/apache-hive-2.1.1-bin/lib/aopalliance-1.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/twill-zookeeper-0.6.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/jackson-jaxrs-1.9.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/datanucleus-rdbms-4.1.7.jar:/usr/local/apache-hive-2.1.1-bin/lib/twill-common-0.6.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-orc-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/zookeeper-3.4.6.jar:/usr/local/apache-hive-2.1.1-bin/lib/javax.inject-1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jetty-util-6.1.26.jar:/usr/local/apache-hive-2.1.1-bin/lib/jersey-server-1.14.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-serde-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/avro-1.7.7.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-lang-2.6.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-shims-0.23-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-io-2.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-procedure-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/twill-discovery-core-0.6.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-exec-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/metrics-core-3.1.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/twill-api-0.6.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/disruptor-3.3.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/jersey-client-1.9.jar:/usr/local/apache-hive-2.1.1-bin/lib/geronimo-annotation_1.0_spec-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-llap-common-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/mail-1.4.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-collections-3.2.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-pool-1.5.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/jetty-all-server-7.6.0.v20120127.jar:/usr/local/apache-hive-2.1.1-bin/lib/tempus-fugit-1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jetty-6.1.26.jar:/usr/local/apache-hive-2.1.1-bin/lib/log4j-core-2.4.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/twill-core-0.6.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/joni-2.1.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-accumulo-handler-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/org.abego.treelayout.core-1.0.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/httpcore-4.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/accumulo-core-1.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/log4j-api-2.4.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-codec-1.4.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-beeline-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar:/usr/local/apache-hive-2.1.1-bin/lib/jcommander-1.32.jar:/usr/local/apache-hive-2.1.1-bin/lib/tephra-core-0.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/accumulo-start-1.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/javax.servlet-3.0.0.v201112011016.jar:/usr/local/apache-hive-2.1.1-bin/lib/guice-3.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/jackson-databind-2.4.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/parquet-hadoop-bundle-1.8.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/asm-tree-3.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/libthrift-0.9.3.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-testutils-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-vfs2-2.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/log4j-web-2.4.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jta-1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/servlet-api-2.5-6.1.14.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-el-1.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/stringtemplate-3.2.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/accumulo-trace-1.6.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-hbase-handler-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jackson-xc-1.9.2.jar:/usr/local/apache-hive-2.1.1-bin/lib/antlr4-runtime-4.5.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-prefix-tree-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-jdbc-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/twill-discovery-api-0.6.0-incubating.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-client-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-cli-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-metastore-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/ivy-2.4.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/transaction-api-1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/plexus-utils-1.5.6.jar:/usr/local/apache-hive-2.1.1-bin/lib/metrics-json-3.1.0.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-hwi-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-llap-ext-client-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/javax.jdo-3.2.0-m3.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-llap-server-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/commons-lang3-3.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-service-rpc-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jline-2.12.jar:/usr/local/apache-hive-2.1.1-bin/lib/jcodings-1.0.8.jar:/usr/local/apache-hive-2.1.1-bin/lib/jpam-1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hive-shims-scheduler-2.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/hbase-hadoop2-compat-1.1.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/jdo-api-3.0.1.jar:/usr/local/apache-hive-2.1.1-bin/lib/eigenbase-properties-1.1.5.jar:/usr/local/apache-hive-2.1.1-bin/lib/janino-2.7.6.jar:/usr/local/apache-hive-2.1.1-bin/hcatalog/share/hcatalog/hive-hcatalog-core-2.1.1.jar

hbase dependency:/usr/local/hbase-1.1.5/lib/hbase-common-1.1.5.jar

KYLIN_JVM_SETTINGS is -Xms1024M -Xmx4096M-XX:MaxPermSize=128M -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps-Xloggc:/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/..//logs/kylin.gc-XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=64M

KYLIN_DEBUG_SETTINGS is not set, will notenable remote debuging

KYLIN_LD_LIBRARY_SETTINGS is not set,Usually it's okay unless you want to specify your own native path

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/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/..//logs/kylin.log

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

注意：启动过程如上表示kylin启动成功！如果有其它错误信息，表示启动kylin有问题，根据日志记录（日记在kylin安装包目录中$KYLIN_HOME /logs目录下）查找问题。

 

 

1.1.2.7.     关闭kylin服务

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]# $KYLIN_HOME/bin/kylin.shstop

KYLIN_HOME is set to/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/../

stopping Kylin:17960

[root@localhost65apache-kylin-1.5.0-HBase1.1.3-bin]#

 

 

1.1.2.8.     浏览器测试

正常情况下，http://localhost:7070/kylin (ip请换成你自己的) ，访问该地址即可访问kylin

默认帐号密码是ADMIN/KYLIN

 

通过web访问，如果正常，表示kylin配置成功!可以进行其它操作了。

 

1.1.2.9.     启动集群中所有服务

首先关闭所有服务，然后按照顺序依次启动各服务。

Hadoop+zookeeper+hbase+hive+kylin集群使用命令：

 

Zookeeper命令：

/usr/local/zookeeper-3.4.6/bin/zkServer.shstop

/usr/local/zookeeper-3.4.6/bin/zkServer.shstart

/usr/local/zookeeper-3.4.6/bin/zkCli.sh

 

Hadop命令：

/usr/local/hadoop-2.6.2/sbin/stop-all.sh

/usr/local/hadoop-2.6.2/sbin/start-all.sh

/usr/local/hadoop-2.6.2/sbin/mr-jobhistory-daemon.shstart historyserver

/usr/local/hadoop-2.6.2/bin/hdfs dfsadmin –report

jps

 

Mysql命令：

service mysqld stop

service mysqld restart

service mysqld status

rm -rf /var/lib/mysql/mysql.sock

 

 

Hbase命令：

/usr/local/hbase-1.3.1/bin/stop-hbase.sh

/usr/local/hbase-1.3.1/bin/start-hbase.sh

 

Hive命令：

/usr/local/apache-hive-2.1.1-bin/bin/schematool-dbType mysql –initSchema

/usr/local/apache-hive-2.1.1-bin/hive

 

kylin命令：

/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/check-env.sh

/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/kylin.shstop

/usr/local/apache-kylin-1.5.0-HBase1.1.3-bin/bin/kylin.shstart

 

/usr/local/apache-kylin-1.5.2-bin/bin/kylin.shstop

/usr/local/apache-kylin-1.5.2-bin/bin/kylin.shstart