You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2024/05/16 11:31:00 UTC

[jira] [Commented] (IMPALA-12337) Delete orphan files for Iceberg table

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

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

Hey [~xiabaike], sure, ALTER TABLE EXECUTE remove_orphan_files() is completely fine with me. Then later we can see if there's any need to make these statements top-level.

> 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org