[jira] [Resolved] (HIVE-21750) INSERT OVERWRITE with empty result set does not clear transactional table

["Attila Turoczy (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-21750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Attila Turoczy resolved HIVE-21750.
-----------------------------------
    Resolution: Duplicate

https://issues.apache.org/jira/browse/HIVE-16051

> INSERT OVERWRITE with empty result set does not clear transactional table
> -------------------------------------------------------------------------
>
>                 Key: HIVE-21750
>                 URL: https://issues.apache.org/jira/browse/HIVE-21750
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 4.0.0
>            Reporter: Todd Lipcon
>            Priority: Critical
>
> The following query:
> {code}
> INSERT OVERWRITE TABLE t SELECT 1 WHERE FALSE
> {code}
> should serve to truncate a table by producing an empty base data directory. In fact no new base directory is created, so the table is not cleared. (at least with an insert_only table, I didn't test full-ACID)
> This bug does not seem to happen with non-transactional tables.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)