[ https://issues.apache.org/jira/browse/HIVE-23490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17110364#comment-17110364 ]
David Lavati commented on HIVE-23490: ------------------------------------- Based on HIVE-19981 this can probably be achieved with {{REPL LOAD db FROM dir WITH ('HIVE_EXTERNALTABLE_PURGE_DEFAULT'='true')}} Will post my findings here. > REPL LOAD config to bootstrap external tables with purge > -------------------------------------------------------- > > Key: HIVE-23490 > URL: https://issues.apache.org/jira/browse/HIVE-23490 > Project: Hive > Issue Type: New Feature > Components: repl > Reporter: David Lavati > Assignee: David Lavati > Priority: Major > Fix For: 4.0.0 > > > When replicating data from e.g. an onprem HDFS cluster to cloud storage, a > common scenario is to load it as external table. However proper cleanup is > usually missing here, so when the user deletes a table on the source side, > it's ideal to purge it on the target side. -- This message was sent by Atlassian Jira (v8.3.4#803005)