kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: Intermediate table not found
Date Sat, 30 Jan 2016 07:14:27 GMT
Looks kylin didnt pick up the correct hive conf, thus didnt look into the
right hive metastore and failed to find the table.

To diagnose, run 'bin/find-hive-dependencies.sh' and check if reported
classpath contains the right hive conf folder.



On Thursday, January 28, 2016, jyzheng <jyzheng@iflytek.com> wrote:

>
>
> I’m a newbie for kylin. After installing, I run sample.sh, then build the
> cube, but get the wrong message:
>
>
>
> java.io.IOException:
> NoSuchObjectException(message:default.kylin_intermediate_kylin_sales_cube_desc_19700101000000_20160101000000_38b1539f_1f69_406d_89ed_96f3ca776841
> table not found)
>
>          at
> org.apache.hive.hcatalog.mapreduce.HCatInputFormat.setInput(HCatInputFormat.java:97)
>
>          at
> org.apache.hive.hcatalog.mapreduce.HCatInputFormat.setInput(HCatInputFormat.java:51)
>
>          at
> org.apache.kylin.job.hadoop.cube.FactDistinctColumnsJob.setupMapper(FactDistinctColumnsJob.java:101)
>
>          at
> org.apache.kylin.job.hadoop.cube.FactDistinctColumnsJob.run(FactDistinctColumnsJob.java:77)
>
>          at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
>
>          at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
>
>          at
> org.apache.kylin.job.common.MapReduceExecutable.doWork(MapReduceExecutable.java:120)
>
>          at
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
>
>          at
> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:51)
>
>          at
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
>
>          at
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:130)
>
>          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)
>
> Caused by:
> NoSuchObjectException(message:default.kylin_intermediate_kylin_sales_cube_desc_19700101000000_20160101000000_38b1539f_1f69_406d_89ed_96f3ca776841
> table not found)
>
>          at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1569)
>
>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>          at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
>          at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
>          at java.lang.reflect.Method.invoke(Method.java:606)
>
>          at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:106)
>
>          at com.sun.proxy.$Proxy49.get_table(Unknown Source)
>
>          at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1008)
>
>          at
> org.apache.hive.hcatalog.common.HCatUtil.getTable(HCatUtil.java:191)
>
>          at
> org.apache.hive.hcatalog.mapreduce.InitializeInput.getInputJobInfo(InitializeInput.java:105)
>
>          at
> org.apache.hive.hcatalog.mapreduce.InitializeInput.setInput(InitializeInput.java:86)
>
>          at
> org.apache.hive.hcatalog.mapreduce.HCatInputFormat.setInput(HCatInputFormat.java:95)
>
>          ... 13 more
>
>
>
> result code:2
>
> [Issue 975 <https://issues.apache.org/jira/browse/KYLIN-975>] suggests "kylin.job.hive.database.for.intermediatetable"
> = default. But I also get this error message.
>
>
>
> When I run `show tables` command, I can get the table
> kylin_intermediate_kylin_sales_cube_desc_1970***, and can also get its
> described info.
>
>
>
> Kylin version = 1.2
>
> Hive version = 0.13.1-cdh5.3.2
>
> Hbase version = 0.98.6+cdh5.3.2
>
> Hadoop version = 2.5.0-cdh5.3.2
>
>
>

Mime
View raw message