[ 
https://issues.apache.org/jira/browse/IMPALA-12337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17951660#comment-17951660
 ] 

Zoltán Borók-Nagy commented on IMPALA-12337:
--------------------------------------------

For reference, this is how Hive implements orphan file removal: 
[https://github.com/apache/hive/blob/08067725bc6e8810579324736a0aac453c06bf7b/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/actions/HiveIcebergDeleteOrphanFiles.java]

> 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]

Reply via email to