Kylin 的cube创建成功 但Build失败

Create and distribute table, cmd: 
hive -e "SET dfs.replication=2;
SET hive.exec.compress.output=true;
SET hive.auto.convert.join.noconditionaltask=true;
SET hive.auto.convert.join.noconditionaltask.size=100000000;
SET mapreduce.output.fileoutputformat.compress.type=BLOCK;
SET mapreduce.job.split.metainfo.maxsize=-1;

USE default;
DROP TABLE IF EXISTS kylin_intermediate_test_c27dc06c_7251_4cc4_b165_376fc0f60a80;
CREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_test_c27dc06c_7251_4cc4_b165_376fc0f60a80
(
DEFAULT_KYLIN_SALES_SELLER_ID bigint
,DEFAULT_KYLIN_SALES_USER_ID string
,DEFAULT_KYLIN_SALES_REGION string
,DEFAULT_KYLIN_CAL_DT_WEEK_BEG_DT date
)
STORED AS SEQUENCEFILE
LOCATION 'kylin/kylin_metadata/kylin-3e2731b3-69e8-4b96-9839-2952a6844225/kylin_intermediate_test_c27dc06c_7251_4cc4_b165_376fc0f60a80';
SET dfs.replication=2;
SET hive.exec.compress.output=true;
SET hive.auto.convert.join.noconditionaltask=true;
SET hive.auto.convert.join.noconditionaltask.size=100000000;
SET mapreduce.output.fileoutputformat.compress.type=BLOCK;
SET mapreduce.job.split.metainfo.maxsize=-1;
INSERT OVERWRITE TABLE kylin_intermediate_test_c27dc06c_7251_4cc4_b165_376fc0f60a80 SELECT
KYLIN_SALES.SELLER_ID
,KYLIN_SALES.USER_ID
,KYLIN_SALES.REGION
,KYLIN_CAL_DT.WEEK_BEG_DT
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
WHERE (KYLIN_SALES.PART_DT >= '2015-01-01' AND KYLIN_SALES.PART_DT < '2015-01-03')
;

"
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.

Logging initialized using configuration in file:/etc/hive/2.6.0.3-8/0/hive-log4j.properties
OK
Time taken: 1.125 seconds
OK
Time taken: 0.122 seconds
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: hdfs://kylin-master:8020./kylin/kylin_metadata/kylin-3e2731b3-69e8-4b96-9839-2952a6844225/kylin_intermediate_test_c27dc06c_7251_4cc4_b165_376fc0f60a80
网上说是HIVE问题 
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: hdfs://kylin-master:8020./kylin/kylin_metadata/kylin-3e2731b3-69e8-4b96-9839-2952a6844225/kylin_intermediate_test_c27dc06c_7251_4cc4_b165_376fc0f60a80)
但是在黑窗里的HIVE是可以正常创建和查询表 导入导出数据的。


李扬 - Apache Kylin committer & PMC member, Sr. Architect of eBay CCOE

赞同来自: fish zj220223

看起来这个路径很有问题。注意“:8020”后面的那个“.”是不应该出现的。排查配置文件看哪里配错了。 hdfs://kylin-master:8020./kylin/kylin_metadata  

dezai - 88

赞同来自:

恩 我发现了 已经解决掉了。 是 Kylin 1.6的版本 与之前的版本在 配置文件中的kylin.hdfs.working.dir默认值少了个 '/'   1.5 kylin.hdfs.working.dir=/kylin   1.6 kylin.hdfs.working.dir=kylin    

要回复问题请先登录注册