This is a limitation of HCatalog, don't see it plan to fix; The patch in https://issues.apache.org/jira/browse/HIVE-10851 is just showing a meaningful message saying "View currently not supported".
2015-12-24 15:29 GMT+08:00 yu feng <[email protected]>: > Do not plan to fix it ?(Resolution:Won't Fix) > If you calculate cardinality for the underlying table, it can not reflect > the real cardinality in view, maybe we need some other solution. > > 2015-12-24 15:17 GMT+08:00 Shi, Shaofeng <[email protected]>: > > > This is an known issue of Hive, already recorded in > > https://issues.apache.org/jira/browse/KYLIN-916 > > The workaround is to load and then calculate cardinality for the > > underlying table which is not a view; > > > > On 12/24/15, 3:11 PM, "yu feng" <[email protected]> wrote: > > > > >I load a view in onew project, However, calculat cardinality always > error > > >like this: > > > > > >java.io.IOException: java.lang.NullPointerException > > > at > > > >org.apache.hive.hcatalog.mapreduce.HCatInputFormat.setInput(HCatInputForma > > >t.java:97) > > > at > > > >org.apache.hive.hcatalog.mapreduce.HCatInputFormat.setInput(HCatInputForma > > >t.java:51) > > > at > > > >org.apache.kylin.job.hadoop.cardinality.HiveColumnCardinalityJob.run(HiveC > > >olumnCardinalityJob.java:79) > > > 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.HadoopShellExecutable.doWork(HadoopShellExecut > > >able.java:62) > > > at > > > >org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutab > > >le.java:107) > > > at > > > >org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChai > > >nedExecutable.java:51) > > > 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: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: java.lang.NullPointerException > > > at java.lang.Class.forName0(Native Method) > > > at java.lang.Class.forName(Class.java:191) > > > at > > > >org.apache.hive.hcatalog.mapreduce.FosterStorageHandler.<init>(FosterStora > > >geHandler.java:59) > > > at > > > >org.apache.hive.hcatalog.common.HCatUtil.getStorageHandler(HCatUtil.java:4 > > >17) > > > at > > > >org.apache.hive.hcatalog.common.HCatUtil.getStorageHandler(HCatUtil.java:3 > > >80) > > > at > > > >org.apache.hive.hcatalog.mapreduce.InitializeInput.extractPartInfo(Initial > > >izeInput.java:158) > > > at > > > >org.apache.hive.hcatalog.mapreduce.InitializeInput.getInputJobInfo(Initial > > >izeInput.java:137) > > > at > > > >org.apache.hive.hcatalog.mapreduce.InitializeInput.setInput(InitializeInpu > > >t.java:86) > > > at > > > >org.apache.hive.hcatalog.mapreduce.HCatInputFormat.setInput(HCatInputForma > > >t.java:95) > > > ... 12 more > > > > > > > > >This is because it can not find serde jar for this view(table), do > someone > > >has idea about it,,, > > > > > -- Best regards, Shaofeng Shi
