Hi, The log contains a complete Hive command to be run. It looks that step failed. You can find that Hive command and try to run that by yourself in Hive CLI to see if it reports any errors.
Thanks, Silas On 1 Mar 2018, at 9:43 AM, [email protected]<mailto:[email protected]> wrote: ________________________________ [email protected]<mailto:[email protected]> 发件人： [email protected]<mailto:[email protected]> 发送时间： 2018-02-26 10:02 收件人： user<mailto:[email protected]> 主题： 回复: about kylin Sample problem “Kylin provides a script for you to create a sample Cube; the script will also create five sample hive tables: 1. Run ${KYLIN_HOME}/bin/sample.sh ; Restart kylin server to flush the caches; 2. Logon Kylin web with default user ADMIN/KYLIN, select project “learn_kylin” in the project dropdown list (left upper corner); 3. Select the sample cube “kylin_sales_cube”, click “Actions” -> “Build”, pick up a date later than 2014-01-01 (to cover all 10000 sample records);” Do this step log in the following error. The environment is on Cloudera QuickStart VM 5.12 ，on VMWare, and the resources are given to 4cpu 8G memory N SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY WHERE (KYLIN_SALES.PART_DT >= '2014-01-01' AND KYLIN_SALES.PART_DT < '2018-01-01') ; " --hiveconf hive.merge.mapredfiles=false --hiveconf hive.merge.mapfiles=false --hiveconf hive.stats.autogather=true --hiveconf hive.auto.convert.join.noconditionaltask=true --hiveconf dfs.replication=2 --hiveconf hive.auto.convert.join.noconditionaltask.size=100000000 --hiveconf hive.auto.convert.join=true --hiveconf hive.exec.compress.output=true --hiveconf mapreduce.job.split.metainfo.maxsize=-1 at org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:92) at org.apache.kylin.source.hive.CreateFlatHiveTableStep.createFlatHiveTable(CreateFlatHiveTableStep.java:53) at org.apache.kylin.source.hive.CreateFlatHiveTableStep.doWork(CreateFlatHiveTableStep.java:71) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125) at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:64) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125) at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:144) 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) 2018-02-07 06:24:00,234 INFO [Scheduler 1859819760 Job 90d1f92f-5797-4222-bef0-409e4534690d-139] execution.ExecutableManager:421 : job id:90d1f92f-5797-4222-bef0-409e4534690d-00 from RUNNING to ERROR 2018-02-07 06:24:00,318 INFO [Scheduler 1859819760 Job 90d1f92f-5797-4222-bef0-409e4534690d-139] execution.ExecutableManager:421 : job id:90d1f92f-5797-4222-bef0-409e4534690d from RUNNING to ERROR 2018-02-07 06:24:00,318 DEBUG [Scheduler 1859819760 Job 90d1f92f-5797-4222-bef0-409e4534690d-139] execution.AbstractExecutable:259 : no need to send email, user list is empty ________________________________ [email protected]<mailto:[email protected]> 发件人： [email protected]<mailto:[email protected]> 发送时间： 2018-02-08 11:34 收件人： user<mailto:[email protected]> 主题： about kylin Sample's problem “Kylin provides a script for you to create a sample Cube; the script will also create five sample hive tables: 1. Run ${KYLIN_HOME}/bin/sample.sh ; Restart kylin server to flush the caches; 2. Logon Kylin web with default user ADMIN/KYLIN, select project “learn_kylin” in the project dropdown list (left upper corner); 3. Select the sample cube “kylin_sales_cube”, click “Actions” -> “Build”, pick up a date later than 2014-01-01 (to cover all 10000 sample records);” Do this step log in the following error. The environment is on Cloudera QuickStart VM 5.12 ，on VMWare, and the resources are given to 4cpu 8G memory N SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY WHERE (KYLIN_SALES.PART_DT >= '2014-01-01' AND KYLIN_SALES.PART_DT < '2018-01-01') ; " --hiveconf hive.merge.mapredfiles=false --hiveconf hive.merge.mapfiles=false --hiveconf hive.stats.autogather=true --hiveconf hive.auto.convert.join.noconditionaltask=true --hiveconf dfs.replication=2 --hiveconf hive.auto.convert.join.noconditionaltask.size=100000000 --hiveconf hive.auto.convert.join=true --hiveconf hive.exec.compress.output=true --hiveconf mapreduce.job.split.metainfo.maxsize=-1 at org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:92) at org.apache.kylin.source.hive.CreateFlatHiveTableStep.createFlatHiveTable(CreateFlatHiveTableStep.java:53) at org.apache.kylin.source.hive.CreateFlatHiveTableStep.doWork(CreateFlatHiveTableStep.java:71) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125) at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:64) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125) at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:144) 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) 2018-02-07 06:24:00,234 INFO [Scheduler 1859819760 Job 90d1f92f-5797-4222-bef0-409e4534690d-139] execution.ExecutableManager:421 : job id:90d1f92f-5797-4222-bef0-409e4534690d-00 from RUNNING to ERROR 2018-02-07 06:24:00,318 INFO [Scheduler 1859819760 Job 90d1f92f-5797-4222-bef0-409e4534690d-139] execution.ExecutableManager:421 : job id:90d1f92f-5797-4222-bef0-409e4534690d from RUNNING to ERROR 2018-02-07 06:24:00,318 DEBUG [Scheduler 1859819760 Job 90d1f92f-5797-4222-bef0-409e4534690d-139] execution.AbstractExecutable:259 : no need to send email, user list is empty ________________________________ [email protected]<mailto:[email protected]>
