[ 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)