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 <liuyiming....@gmail.com> wrote:
> Please double check the cube definition which is a json file. > > 2016-08-24 15:13 GMT+08:00 Jose Raul Perez Rodriguez < > joseraul.w...@gmail.com>: > >> 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 < >> joseraul.w...@gmail.com>: >> >>> 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 | 马洪宾*