You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2023/03/21 09:00:01 UTC

[jira] [Created] (HIVE-27160) Iceberg: Optimise delete (entire) data from table

Denys Kuzmenko created HIVE-27160:
-------------------------------------

             Summary: Iceberg: Optimise delete (entire) data from table
                 Key: HIVE-27160
                 URL: https://issues.apache.org/jira/browse/HIVE-27160
             Project: Hive
          Issue Type: Task
            Reporter: Denys Kuzmenko


Currently, in MOR mode, Hive creates "positional delete" files during deletes. With "Delete from ", the entire dataset in the table or partition is written as a "positional delete" file.

During the read operation, all these files are read again causing huge delay.

Proposal: apply "truncate" optimization in case of "delete *".



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