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,,,
