[
https://issues.apache.org/jira/browse/KYLIN-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15315319#comment-15315319
]
Dayue Gao commented on KYLIN-1758:
----------------------------------
Hi Shaofeng,
Please also note that `createLookupHiveViewMaterializationStep` should use
`JoinedFlatTable.generateHiveSetStatements` when building hive command,
otherwise it will not pick the correct queue configuration.
> 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)
