[ https://issues.apache.org/jira/browse/KYLIN-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15315378#comment-15315378 ]
Shaofeng SHI commented on KYLIN-1758: ------------------------------------- Thanks Dayue, you're correct; I'm adding this. > createLookupHiveViewMaterializationStep will create intermediate table for > fact table > -------------------------------------------------------------------------------------- > > Key: KYLIN-1758 > URL: https://issues.apache.org/jira/browse/KYLIN-1758 > Project: Kylin > Issue Type: Bug > Components: Job Engine > Affects Versions: v1.5.2 > Environment: hadoop2.4, hbase1.1.2 > Reporter: Xingxing Di > Assignee: Shaofeng SHI > Priority: Critical > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)