[
https://issues.apache.org/jira/browse/KYLIN-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shaofeng SHI closed KYLIN-1758.
-------------------------------
Resolved in release 1.5.2.1 (2016-06-07)
> 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)
