[jira] [Commented] (KYLIN-2987) Skip moving to Trash when drop an intermediate hive table or redistribute a hive table

[" Kaige Liu (JIRA)" <ji...@apache.org>]

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

 Kaige Liu commented on KYLIN-2987:
-----------------------------------

Hi [~yaho], seems this patch does not work. According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertOverwrite
auto.purge=true only works for MANAGED table, but KYLIN intermediate hive tables are created as EXTERNAL table.

> Skip moving to Trash when drop an intermediate hive table or redistribute a hive table
> --------------------------------------------------------------------------------------
>
>                 Key: KYLIN-2987
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2987
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: Zhong Yanghong
>            Assignee: Zhong Yanghong
>            Priority: Trivial
>             Fix For: v2.3.0
>
>         Attachments: APACHE-KYLIN-2987.patch
>
>
> At kylin side, we can add auto.purge=true when creating intermediate table.
> However, to make ‘auto.purge’ effective for “insert overwrite table”, we still need one patch for hive.
> https://issues.apache.org/jira/browse/HIVE-15880



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)