You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Todd Lipcon (JIRA)" <ji...@apache.org> on 2019/05/17 19:57:00 UTC

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

Todd Lipcon created HIVE-21750:
----------------------------------

             Summary: 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


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
(v7.6.3#76005)