Hi, Mohammed
would you please run
* hive -e '*DROP TABLE IF EXISTS ...*'*
in your CLI to see if there is anything wrong which should be the root
cause.
BTW, the log is a known issue which will be fixed in the next release.
Yaseen Mohammed <[email protected]>于2015年7月7日周二 上午6:09写道：
> 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
>
>
>
