Good to know the issue is solved, thanks for the update! 2016-08-30 20:52 GMT+08:00 Roberto Tardío Olmos <[email protected] >:
> I think the mistake was due to the coexistence of versions 1.5.2 and 1.5.3, > which we updated a few days ago, including HBase coprocessor. We have > solved by reinstalling Kylin 1.5.2. > > El 30/08/2016 a las 14:50, Roberto Tardío Olmos escribió: > > Thanks, > > I think the mistake was due to the coexistence of versions 1.5.2 and 1.5.3, > which actulizamos few days ago, including HBase coprocessor. We have > solved reinstating Kylin 1.5.2. > > Regards, > > El 28/08/2016 a las 7:56, hongbin ma escribió: > > can you pastebin the cube desc and the look up table's hive schema? > > On Wed, Aug 24, 2016 at 3:17 PM, Yiming Liu <[email protected]> > wrote: > >> Please double check the cube definition which is a json file. >> >> 2016-08-24 15:13 GMT+08:00 Jose Raul Perez Rodriguez < >> [email protected]>: >> >>> Yes, seems logical, but I haven't defined any date/time/timestamp >>> column, that is what makes this error pretty baffling for me. Thanks >>> Yiming. >>> >>> >>> On 24/08/16 03:24, Yiming Liu wrote: >>> >>> The exception means the cube has defined one column with type: >>> date/time/datetime/timestamp, but the value of that column is NULL. >>> >>> 2016-08-23 18:06 GMT+08:00 Jose Raul Perez Rodriguez < >>> [email protected]>: >>> >>>> Hi, >>>> >>>> When I build cubes with *derived columns* always get the same error at >>>> "Build Dimension Dictionary" step. >>>> >>>> kylin version: 1.5.3 >>>> >>>> error: >>>> >>>> java.lang.NullPointerException >>>> at org.apache.kylin.common.util.DateFormat.isAllDigits(DateForm >>>> at.java:121) >>>> at org.apache.kylin.common.util.DateFormat.stringToMillis(DateF >>>> ormat.java:104) >>>> at org.apache.kylin.common.util.DateFormat.stringToMillis(DateF >>>> ormat.java:91) >>>> at org.apache.kylin.dict.lookup.LookupStringTable.convertRow(Lo >>>> okupStringTable.java:86) >>>> at org.apache.kylin.dict.lookup.LookupStringTable.convertRow(Lo >>>> okupStringTable.java:34) >>>> at org.apache.kylin.dict.lookup.LookupTable.initRow(LookupTable >>>> .java:76) >>>> at org.apache.kylin.dict.lookup.LookupTable.init(LookupTable.ja >>>> va:67) >>>> at org.apache.kylin.dict.lookup.LookupStringTable.init(LookupSt >>>> ringTable.java:79) >>>> at org.apache.kylin.dict.lookup.LookupTable.<init>(LookupTable. >>>> java:55) >>>> at org.apache.kylin.dict.lookup.LookupStringTable.<init>(Lookup >>>> StringTable.java:65) >>>> at org.apache.kylin.cube.CubeManager.getLookupTable(CubeManager >>>> .java:619) >>>> at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegm >>>> ent(DictionaryGeneratorCLI.java:61) >>>> at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegm >>>> ent(DictionaryGeneratorCLI.java:42) >>>> at org.apache.kylin.engine.mr.steps.CreateDictionaryJob.run(Cre >>>> ateDictionaryJob.java:56) >>>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) >>>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90) >>>> at org.apache.kylin.engine.mr.common.HadoopShellExecutable.doWo >>>> rk(HadoopShellExecutable.java:63) >>>> at org.apache.kylin.job.execution.AbstractExecutable.execute(Ab >>>> stractExecutable.java:112) >>>> at org.apache.kylin.job.execution.DefaultChainedExecutable.doWo >>>> rk(DefaultChainedExecutable.java:57) >>>> at org.apache.kylin.job.execution.AbstractExecutable.execute(Ab >>>> stractExecutable.java:112) >>>> at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRun >>>> ner.run(DefaultScheduler.java:127) >>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool >>>> Executor.java:1142) >>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo >>>> lExecutor.java:617) >>>> at java.lang.Thread.run(Thread.java:745) >>>> >>>> result code:2 >>>> >>>> >>>> The curious thing is that I don't use any Date column, so it is pretty >>>> baffling. And only happens with cubes using derived columns. >>>> >>>> >>>> Any idea will be helpful, >>>> >>>> >>>> Thanks >>>> >>>> >>>> >>> >>> >>> -- >>> With Warm regards >>> >>> Yiming Liu (刘一鸣) >>> >>> >>> >> >> >> -- >> With Warm regards >> >> Yiming Liu (刘一鸣) >> > > > > -- > Regards, > > *Bin Mahone | 马洪宾* > > > -- > *Roberto Tardío Olmos* > *Big Data & Business Intelligence Consultant* > > Avenida de Brasil, 17, Planta 16. 28020 Madrid Fijo: 91.788.34.10 > > > -- > *Roberto Tardío Olmos* > *Big Data & Business Intelligence Consultant* > > Avenida de Brasil, 17, Planta 16. 28020 Madrid Fijo: 91.788.34.10 > -- Best regards, Shaofeng Shi
