[jira] [Comment Edited] (KYLIN-1077) Support Hive View as Lookup Table

["wangxianbin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15268731#comment-15268731 ] 

wangxianbin edited comment on KYLIN-1077 at 5/3/16 1:45 PM:
------------------------------------------------------------

[~Shaofengshi], job id can help with the concurrent issue, however, it bring the minus character which is not allowed in hive, thanks point this out, for completely solving the issue, maybe eliminate the minus character is also a good idea.


was (Author: whenwin):
[~Shaofengshi], job id can help with the concurrent issue, however, it bring the "-" character which is not allowed in hive, thanks point this out, for completely solving the issue, maybe eliminate the "-" character is also a good idea.

> Support Hive View as Lookup Table
> ---------------------------------
>
>                 Key: KYLIN-1077
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1077
>             Project: Kylin
>          Issue Type: Improvement
>    Affects Versions: v1.1
>            Reporter: Francesco Palmiotto
>            Assignee: wangxianbin
>              Labels: newbie
>             Fix For: v1.5.2
>
>         Attachments: 0001-KYLIN-1077-Support-Hive-View-as-Lookup-Table.patch, KYLIN-1077-Support-Hive-View-as-Lookup-Table.patch
>
>
> If we use a view as a lookup table the cube building job fails when executing the 3rd step (Build Dimension Dictionary) with this log:
> java.io.IOException: java.lang.NullPointerException
> 	at org.apache.kylin.dict.lookup.HiveTable.getSignature(HiveTable.java:72)
> 	at org.apache.kylin.dict.DictionaryManager.buildDictionary(DictionaryManager.java:202)
> 	at org.apache.kylin.cube.CubeManager.buildDictionary(CubeManager.java:166)
> 	at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:52)
> 	at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:41)
> 	at org.apache.kylin.job.hadoop.dict.CreateDictionaryJob.run(CreateDictionaryJob.java:52)
> 	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(HadoopShellExecutable.java:62)
> 	at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
> 	at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:51)
> 	at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
> 	at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:130)
> 	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)
> Caused by: java.lang.NullPointerException
> result code:2



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)