Step 7构建基础长方体上的Kylin构建错误

Question

我正在尝试按照这个link上的说明来创建样本立方体。第7步构建失败，并显示以下错误消息。任何帮助我们都将不胜感激

EMR: 5.4.0 Hbase: 1.3.0 kylin: 2.0.0

java.lang.IllegalArgumentException: Map input splits are 0 bytes, something is wrong!
at org.apache.kylin.engine.mr.common.AbstractHadoopJob.getTotalMapInputMB(AbstractHadoopJob.java:573)
at org.apache.kylin.engine.mr.steps.CuboidJob.run(CuboidJob.java:134)
at org.apache.kylin.engine.mr.MRUtil.runMRJob(MRUtil.java:102)
at org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:123)
at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:124)
at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:64)
at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:124)
at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:142)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

结果码:2

Answer 1

可能是日期列为空，或者记录不在开始日期和结束日期之间。

打开日志文件夹中的kylin.log，检查存储中间数据的查询是否在配置单元检查结果中执行该查询(如下查询)

""""INSERT OVERWRITE TABLE kylin_intermediate_cube2_70c3e71d_f9a8_4ed1_91a9_d12dd649a9b1 SELECT                                                          
BMS_TRANSACTIONS1.MAX_SEQ                                                                                                                            
,BMS_TRANSACTIONS1.TRX_TYPE                                                                                                                          
FROM BMS.BMS_TRANSACTIONS1 as BMS_TRANSACTIONS1                                                                                                      
WHERE (BMS_TRANSACTIONS1.TRX_DATE >= '2012-04-09' AND BMS_TRANSACTIONS1.TRX_DATE < '2017-07-27')                                                     
;     """