[jira] [Created] (IMPALA-11971) Simple syntax to Compact and Overwrite Iceberg Tables and Partitions

["Manish Maheshwari (Jira)" <ji...@apache.org>]

Manish Maheshwari created IMPALA-11971:
------------------------------------------

             Summary: Simple syntax to Compact and Overwrite Iceberg Tables and Partitions
                 Key: IMPALA-11971
                 URL: https://issues.apache.org/jira/browse/IMPALA-11971
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
            Reporter: Manish Maheshwari


Impala supports overwriting iceberg tables. Overwriting iceberg tables / partitions can be used as an effective way to 
 * compact small files
 * rewrite partitions according to latest spec
 * merge deltas due to deletes and updates (if any) due to Merge-on-read strategy
 * delete orphan files in table/partition

Doing all of this as part of an overwrite partition is not intuitive. We should support a syntax verb like `compact` or `consolidate` or `tune` to do these operations 
{code:java}
alter table compact table;
alter table compact table partition <>;
alter table compact table partition <>;{code}



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org