Hi All,
We are encountering issues with cube build job when running getting the
following error. Could you please help us.
[pool-4-thread-8]:[2015-07-06
13:11:00,766][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:222)]
- job id:73f345f7-8217-46e0-a9c6-4bd2757c50e9-00 from READY to RUNNING
[pool-4-thread-8]:[2015-07-06
13:11:00,767][INFO][org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:50)]
- executing:hive -e "DROP TABLE IF EXISTS
kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9;
CREATE EXTERNAL TABLE IF NOT EXISTS
kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9
(
GA_TALEND_ITEMSALES_STOREID string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177'
STORED AS SEQUENCEFILE
LOCATION
'/tmp/kylin-73f345f7-8217-46e0-a9c6-4bd2757c50e9/kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9';
SET mapreduce.job.split.metainfo.maxsize=-1;
SET mapreduce.job.max.split.locations=2000;
SET dfs.replication=2;
SET hive.exec.compress.output=true;
SET hive.auto.convert.join.noconditionaltask = true;
SET hive.auto.convert.join.noconditionaltask.size = 300000000;
INSERT OVERWRITE TABLE
kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9
SELECT
FACT_TABLE.STOREID
FROM GA_TALEND.ITEMSALES as FACT_TABLE
INNER JOIN GA_TALEND.STORE as LOOKUP_1
ON FACT_TABLE.STOREID = LOOKUP_1.STORECODE
;
"
[pool-4-thread-8]:[2015-07-06
13:11:18,495][ERROR][org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:56)]
- job:73f345f7-8217-46e0-a9c6-4bd2757c50e9-00 execute finished with exception
java.io.IOException: OS command error exit with 2 -- hive -e "DROP TABLE IF
EXISTS
kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9;
CREATE EXTERNAL TABLE IF NOT EXISTS
kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9
(
GA_TALEND_ITEMSALES_STOREID string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177'
STORED AS SEQUENCEFILE
LOCATION
'/tmp/kylin-73f345f7-8217-46e0-a9c6-4bd2757c50e9/kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9';
SET mapreduce.job.split.metainfo.maxsize=-1;
SET mapreduce.job.max.split.locations=2000;
SET dfs.replication=2;
SET hive.exec.compress.output=true;
SET hive.auto.convert.join.noconditionaltask = true;
SET hive.auto.convert.join.noconditionaltask.size = 300000000;
INSERT OVERWRITE TABLE
kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_8217_46e0_a9c6_4bd2757c50e9
SELECT
FACT_TABLE.STOREID
FROM GA_TALEND.ITEMSALES as FACT_TABLE
INNER JOIN GA_TALEND.STORE as LOOKUP_1
ON FACT_TABLE.STOREID = LOOKUP_1.STORECODE
;
"
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
line
at
org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:91)
at
org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:52)
at
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
at
org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50)
at
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
at
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:132)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
[pool-4-thread-8]:[2015-07-06
13:11:18,504][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:171)]
- Saving resource /execute_output/73f345f7-8217-46e0-a9c6-4bd2757c50e9-00
(Store kylin_metadata@hbase)
[pool-4-thread-8]:[2015-07-06
13:11:18,524][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:171)]
- Saving resource /execute_output/73f345f7-8217-46e0-a9c6-4bd2757c50e9-00
(Store kylin_metadata@hbase)
[pool-4-thread-8]:[2015-07-06
13:11:18,528][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:222)]
- job id:73f345f7-8217-46e0-a9c6-4bd2757c50e9-00 from RUNNING to ERROR
