kylin能够正常启动,sample.sh
脚本也能够正常运行,同时在hive中能够查到所建立的三张表如下图所示,下图是运行了sample.sh后的hive中的default
database中的tables,可以看见生成了官方文档上所描述的三张表:

<http://apache-kylin.74782.x6.nabble.com/file/n5163/hive.png> 

但是在运行build kylin_sales_cube 的时候,却一直在Create Intermediate Flat Hive Table
这里运行,并且log 无信息,如下所示:

<http://apache-kylin.74782.x6.nabble.com/file/n5163/runing.png> 
<http://apache-kylin.74782.x6.nabble.com/file/n5163/output.png> 

按照文档,hive的元数据库我使用mysql替换了derby数据库,同时也将mysql-connector-java-x.x.xx.jar文件拷贝到$Hive_Home/lib目录中,

运行sample.sh 后,remote mysql 中生成了如下的信息:

<http://apache-kylin.74782.x6.nabble.com/file/n5163/mysql.png> 

检查kylin.log 文件部分信息,没有Error错误,内容如下:

SET hive.support.concurrency=false;
SET mapreduce.job.split.metainfo.maxsize=-1;
INSERT OVERWRITE TABLE
kylin_intermediate_kylin_sales_cube_desc_20120101000000_20160608000000
SELECT
KYLIN_SALES.PART_DT
,KYLIN_SALES.LEAF_CATEG_ID
,KYLIN_SALES.LSTG_SITE_ID
,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME
,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME
,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME
,KYLIN_SALES.LSTG_FORMAT_NAME
,KYLIN_SALES.PRICE
,KYLIN_SALES.SELLER_ID
FROM DEFAULT.KYLIN_SALES as KYLIN_SALES 
INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS
ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND
KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID
WHERE (KYLIN_SALES.PART_DT >= '2012-01-01' AND KYLIN_SALES.PART_DT <
'2016-06-08')
;

"
2016-06-30 11:25:14,255 INFO  [pool-6-thread-1]
threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 1 actual running,
1 ready, 24 others
2016-06-30 11:25:40,090 DEBUG [http-bio-7070-exec-7] service.AdminService:90
: Get Kylin Runtime Config
2016-06-30 11:25:40,151 DEBUG [http-bio-7070-exec-6]
controller.UserController:64 : authentication.getPrincipal() is
org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN;
Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
2016-06-30 11:25:40,227 DEBUG [http-bio-7070-exec-6]
controller.ProjectController:97 : authentication.getPrincipal() is
org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN;
Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
2016-06-30 11:26:14,241 INFO  [pool-6-thread-1]
threadpool.DefaultScheduler:106 : Job Fetcher: 1 running, 1 actual running,
0 ready, 24 others
2016-06-30 11:26:46,633 DEBUG [http-bio-7070-exec-2] service.AdminService:90
: Get Kylin Runtime Config
2016-06-30 11:26:46,708 DEBUG [http-bio-7070-exec-6]
controller.UserController:64 : authentication.getPrincipal() is
org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN;
Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
2016-06-30 11:26:46,786 DEBUG [http-bio-7070-exec-6]
controller.ProjectController:97 : authentication.getPrincipal() is
org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN;
Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
2016-06-30 11:27:14,238 INFO  [pool-6-thread-1]
threadpool.DefaultScheduler:106 : Job Fetcher: 1 running, 1 actual running,
0 ready, 24 others

下面贴出可能涉及到的配置文件信息:

hive-sive.xml 配置如下:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
 
<value>jdbc:mysql://remote_ip:3306/hive?createDatabaseIfNotExist=true</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hive</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>hive</value>
</property>
hbase-site.xml

<configuration>
     <property>
          <name>hbase.rootdir</name>
          <value>hdfs://localhost:9000/hbase</value>
    </property>
     <property>
        <name>hbase.zookeeper.property.clientPort</name>
        <value>2182 </value>
    </property>
</configuration>
kylin.properties

[email protected]
kylin.rest.servers=localhost:7070
kylin.hdfs.working.dir=/home/hadoop/kylin/kylin_hdfs_working_dir
kylin.job.remote.cli.working.dir=/home/../kylin/kylin_job_working_dir
kylin.job.jar=/home/../kylin/lib/kylin-job-1.5.0-SNAPSHOT.jar
kylin.coprocessor.local.jar=/home/../kylin/lib/kylin-coprocessor-1.5.0-SNAPSHOT.jar
and 我运行了find-hive-dependency.sh & kylin]$ find-hbase-dependency.sh
都没有问题,却一直停留在运行的第一步。

--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/kylin-stay-running-in-step1-when-Create-Intermediate-Flat-Hive-Table-tp5163.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Reply via email to