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

Yaqian Zhang edited comment on KYLIN-4121 at 9/16/19 11:45 AM:
---------------------------------------------------------------

Verified.

Test Evidence:

1、Use hive view table:fact table KYLIN_SALES_VIEW and lokkup table 
KYLIN_CAL_DT_VIEW create model and build cube.Two intermediate tables were 
generated during the construction process.

!image-2019-09-16-19-18-59-663.png|width=483,height=460!

2、The intermediate table is deleted after the build is completed.

!image-2019-09-16-19-26-31-446.png|width=434,height=579!


was (Author: zhangyaqian):
Verified.

Test Evidence:

1、Use hive view table:fact table KYLIN_SALES_VIEW and lokkup table 
KYLIN_CAL_DT_VIEW create model and build cube.Two intermediate tables were 
generated during the construction process.

!image-2019-09-16-19-18-59-663.png!

2、The intermediate table is deleted after the build is completed.

!image-2019-09-16-19-26-31-446.png!

> Cleanup hive view intermediate tables after job be finished
> -----------------------------------------------------------
>
>                 Key: KYLIN-4121
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4121
>             Project: Kylin
>          Issue Type: Improvement
>          Components: Job Engine
>            Reporter: Shaofeng SHI
>            Assignee: wangrupeng
>            Priority: Major
>             Fix For: v3.0.0-beta
>
>         Attachments: image-2019-09-16-19-18-59-663.png, 
> image-2019-09-16-19-26-31-446.png
>
>
> Reported by community user:
> I have a cube with a fact table join a lookup table  in hive, and both are 
> hive view. I submit a job one time per hour.
>  
> Kylin can drop the intermediate fact table , but doesn't drop the 
> intermediate lookup table .
>  
> I check the source code , and find out that , at '13 step: Hive Cleanup' ,  
> the source code has been commented.
>  
>  
> It is a legacy issue. Now KYLIN-3515 has fixed that, so the cleanup can be 
> enabled.



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Reply via email to