[jira] [Commented] (KYLIN-1758) createLookupHiveViewMaterializationStep will create intermediate table for fact table

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

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

Shaofeng SHI commented on KYLIN-1758:
-------------------------------------

Thanks for the reporting, this is a critical issue; please hold, will check this soon.

> 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: Dong Li
>            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)