Re: fail Build Dimension Dictionary

[Jose Raul Perez Rodriguez]

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 <mailto: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(DateFormat.java:121)
        at
    org.apache.kylin.common.util.DateFormat.stringToMillis(DateFormat.java:104)
        at
    org.apache.kylin.common.util.DateFormat.stringToMillis(DateFormat.java:91)
        at
    
org.apache.kylin.dict.lookup.LookupStringTable.convertRow(LookupStringTable.java:86)
        at
    
org.apache.kylin.dict.lookup.LookupStringTable.convertRow(LookupStringTable.java:34)
        at
    org.apache.kylin.dict.lookup.LookupTable.initRow(LookupTable.java:76)
        at
    org.apache.kylin.dict.lookup.LookupTable.init(LookupTable.java:67)
        at
    
org.apache.kylin.dict.lookup.LookupStringTable.init(LookupStringTable.java:79)
        at
    org.apache.kylin.dict.lookup.LookupTable.<init>(LookupTable.java:55)
        at
    
org.apache.kylin.dict.lookup.LookupStringTable.<init>(LookupStringTable.java:65)
        at
    org.apache.kylin.cube.CubeManager.getLookupTable(CubeManager.java:619)
        at
    
org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:61)
        at
    
org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:42)
        at org.apache.kylin.engine.mr
    
<http://org.apache.kylin.engine.mr>.steps.CreateDictionaryJob.run(CreateDictionaryJob.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
    
<http://org.apache.kylin.engine.mr>.common.HadoopShellExecutable.doWork(HadoopShellExecutable.java:63)
        at
    
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:112)
        at
    
org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:57)
        at
    
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:112)
        at
    
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:127)
        at
    
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at
    
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.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 (刘一鸣)