Hi Mohammed, To get the detail error, you can copy and run the following command with the Linux user that you starts Kylin on the server, then you will see the detail error from Hive:
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(She llExecutable.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 ; " On 7/7/15, 6:09 AM, "Yaseen Mohammed" <[email protected]> wrote: >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.updateJ >obOutput(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(She >llExecutable.java:50)] - executing:hive -e "DROP TABLE IF EXISTS >kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_821 >7_46e0_a9c6_4bd2757c50e9; > >CREATE EXTERNAL TABLE IF NOT EXISTS >kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_821 >7_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_CB >E_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_821 >7_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(Sh >ellExecutable.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_821 >7_46e0_a9c6_4bd2757c50e9; > >CREATE EXTERNAL TABLE IF NOT EXISTS >kylin_intermediate_TST_CBE_19700101000000_2922789940817071255_73f345f7_821 >7_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_CB >E_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_821 >7_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(AbstractExecutab >le.java:107) > at >org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChai >nedExecutable.java:50) > at >org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutab >le.java:107) > at >org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(Defaul >tScheduler.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.put >Resource(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.put >Resource(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.updateJ >obOutput(ExecutableManager.java:222)] - job >id:73f345f7-8217-46e0-a9c6-4bd2757c50e9-00 from RUNNING to ERROR > >
