kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jyzheng" <jyzh...@iflytek.com>
Subject Intermediate table not found
Date Thu, 28 Jan 2016 10:43:58 GMT
 

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_de
sc_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(FactDist
inctColumnsJob.java:101)

         at
org.apache.kylin.job.hadoop.cube.FactDistinctColumnsJob.run(FactDistinctColu
mnsJob.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.j
ava:120)

         at
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable
.java:107)

         at
org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChaine
dExecutable.java:51)

         at
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable
.java:107)

         at
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultS
cheduler.java:130)

         at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11
45)

         at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:6
15)

         at java.lang.Thread.run(Thread.java:745)

Caused by:
NoSuchObjectException(message:default.kylin_intermediate_kylin_sales_cube_de
sc_19700101000000_20160101000000_38b1539f_1f69_406d_89ed_96f3ca776841 table
not found)

         at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMeta
Store.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(RetryingHMSHandle
r.java:106)

         at com.sun.proxy.$Proxy49.get_table(Unknown Source)

         at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreC
lient.java:1008)

         at
org.apache.hive.hcatalog.common.HCatUtil.getTable(HCatUtil.java:191)

         at
org.apache.hive.hcatalog.mapreduce.InitializeInput.getInputJobInfo(Initializ
eInput.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