[IMPALA-11362] Add expire snapshots functionality for Iceberg tables

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Resolved
• Affects Version/s: Impala 4.1.0
• Fix Version/s: Impala 4.2.0
• Component/s: Frontend
• Labels: impala-iceberg
• Epic Color: ghx-label-12
• Assignee: Tamas Mate
• Reporter: Zoltán Borók-Nagy
• Created: 16/Jun/22 09:15
• Updated: 25/Oct/22 09:25
• Resolved: 11/Aug/22 11:40

Description

We want to support the following table maintenance features:

ALTER TABLE test_table EXECUTE expire_snapshots("older_than", <timestamp-expr>);
ALTER TABLE test_table EXECUTE expire_snapshots("retain_last", <integer-literal>);
ALTER TABLE test_table EXECUTE expire_snapshots("snapshot_id", <integer-literal>);

They would invoke the corresponding Iceberg APIs, see:
https://github.com/apache/iceberg/blob/master/api/src/main/java/org/apache/iceberg/actions/ExpireSnapshots.java

Issue Links

• is duplicated by: IMPALA-11347 Iceberg expire snapshot functionality