You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2016/06/04 12:22:59 UTC

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

     [ https://issues.apache.org/jira/browse/KYLIN-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI resolved KYLIN-1758.
---------------------------------
       Resolution: Fixed
    Fix Version/s: v1.5.2.1

> 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
>             Fix For: v1.5.2.1
>
>
> 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)