[KYLIN-1077] Support Hive View as Lookup Table

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.1
• Fix Version/s: v1.5.2.1
• Labels: newbie
• Assignee: wangxianbin
• Reporter: Francesco Palmiotto
• Created: 14/Oct/15 12:07
• Updated: 01/Sep/16 10:16
• Resolved: 01/Sep/16 10:16

Description

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

Issue Links

• is broken by: KYLIN-1789 Couldn't use View as Lookup when join type is "inner"
• is duplicated by: KYLIN-1508 NPE error ERROR - Build Cube - Step 3 if LOOKUP table is Hive View - : java.lang.NullPointerException at org.apache.kylin.source.hive.HiveTable.getSignature
• is duplicated by: KYLIN-1510 Need to build a cube which has LOOKUP table referring Hive View
• is related to: KYLIN-1508 NPE error ERROR - Build Cube - Step 3 if LOOKUP table is Hive View - : java.lang.NullPointerException at org.apache.kylin.source.hive.HiveTable.getSignature