[
https://issues.apache.org/jira/browse/IMPALA-12337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17838834#comment-17838834
]
Baike Xia commented on IMPALA-12337:
------------------------------------
HI [~boroknagyz] I took a closer look at your suggestions, as well as existing
implementations of ROLLBACK and EXPIRE_SNAPSHOTS. I want to implement
REMOVE_ORPHAN_FILES using ALTER TABLE EXECUTE first, and we can create a new
jira for ROLLBACK, EXPIRE_SNAPSHOTS, and REMOVE_ORPHAN_FILES based on
VACUUM.What do you think?
> Delete orphan files for Iceberg table
> -------------------------------------
>
> Key: IMPALA-12337
> URL: https://issues.apache.org/jira/browse/IMPALA-12337
> Project: IMPALA
> Issue Type: New Feature
> Components: Catalog, Frontend
> Reporter: Baike Xia
> Assignee: Baike Xia
> Priority: Major
> Labels: catalog-2024, impala-iceberg
>
> Removes all files from a table’s data directory that are not linked from
> metadata files and that are older than the value of older_than parameter.
> Deleting orphan files from time to time is recommended to keep size of a
> table’s data directory under control.
> {code:java}
> ALTER TABLE test_table EXECUTE remove_orphan_files(older_than = 1431691200)
> {code}
> See the syntax for expire_snapshot:IMPALA11362
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]