To troubleshoot, first questions is does kylin_poc_db.kylin_intermediate_kylin_sales_cube_desc_20120101000000_20140928124000 really exist? It should be created in Step 1. If it's not there, then perhaps something was wrong in Step 1 (even though it looks successful).
On Tue, Jul 12, 2016 at 2:32 AM, Niasari, Mehrdad <[email protected]> wrote: > When I run sample.sh, it can create the intermediate table in step 1 in > hive, but it cannot find it in step2. > I’m using beeline to connect to hiveserver2 instead of hive cli. > Also I’m using kylin-1.5.2.1 and Hive 1.2.1.2.3.2.0-2950 > > > I read some discussion about it,(*here* > <http://mail-archives.apache.org/mod_mbox/kylin-dev/201601.mbox/%3CCAPprPdTuLk1fV-ee%2BV54Gs%2Bh0f-6aV-Os5%3DBgBBNKRumxwS21A%40mail.gmail.com%3E>) > and it seems it has something to do with hive.metastore.uri. I checked my > hive-site.xml and hcatalog configurations and everything seems fine. > How can I debug this issue? > I also checked hive-classpath, but how to make sure it has the correct > value? > > It’s becoming a big issue for me. Any help would be really appreciated. > Thanks, > Mehrdad > > java.lang.RuntimeException: java.io.IOException: > NoSuchObjectException(message:kylin_poc_db.kylin_intermediate_kylin_sales_cube_desc_20120101000000_20140928124000 > table not found) > at > org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:86) > at > org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.setupMapper(FactDistinctColumnsJob.java:111) > at > org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.run(FactDistinctColumnsJob.java:91) > at org.apache.kylin.engine.mr.MRUtil.runMRJob(MRUtil.java:91) > at > org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:121) > at > org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:114) > at > org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50) > at > org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:114) > at > org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:124) > 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) > > > > > _______________________________________________________________________ > > If you received this email in error, please advise the sender (by return > email or otherwise) immediately. You have consented to receive the attached > electronically at the above-noted email address; please retain a copy of > this confirmation for future reference. > > Si vous recevez ce courriel par erreur, veuillez en aviser l'expéditeur > immédiatement, par retour de courriel ou par un autre moyen. Vous avez > accepté de recevoir le(s) document(s) ci-joint(s) par voie électronique à > l'adresse courriel indiquée ci-dessus; veuillez conserver une copie de > cette confirmation pour les fins de reference future. > >
