kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: fail Build Dimension Dictionary
Date Tue, 30 Aug 2016 15:21:27 GMT
Good to know the issue is solved, thanks for the update!

2016-08-30 20:52 GMT+08:00 Roberto Tardío Olmos <roberto.tardio@stratebi.com
>:

> 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 <liuyiming.vip@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.work@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.work@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 | 马洪宾*
>
>
> --
> *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

Mime
View raw message