[KYLIN-1758] createLookupHiveViewMaterializationStep will create intermediate table for fact table

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: v1.5.2
• Fix Version/s: v1.5.2.1
• Component/s: Job Engine
• Environment: hadoop2.4, hbase1.1.2
• Assignee: Shao Feng Shi
• Reporter: Xingxing Di
• Created: 02/Jun/16 11:31
• Updated: 01/Sep/16 10:18
• Resolved: 04/Jun/16 12:22

Description

In our model, the fact table is a hive view. When i build cube(I selected one partition for one day's data), the job was trying to create intermediate table by sql :
DROP TABLE IF EXISTS kylin_intermediate_OLAP_OLAP_FLW_PCM_MAU;
CREATE TABLE IF NOT EXISTS kylin_intermediate_OLAP_OLAP_FLW_PCM_MAU
LOCATION '/team/db/kylin15/kylin_metadata15/kylin-65c7ee9a-3024-4633-927c-19e992ed155a/kylin_intermediate_OLAP_OLAP_FLW_PCM_MAU'
AS SELECT * FROM OLAP.OLAP_FLW_PCM_MAU;

1. There is no partition string in where string (I selected only one partition), which cause a very very big MR.

2. Note that, our lookup table is not a view.

Issue Links

• is duplicated by: KYLIN-1991 look up table materialization will include fact table