yunlou11 commented on issue #9562:
URL: https://github.com/apache/iceberg/issues/9562#issuecomment-2540814281
> Yes, Nessie GC tool will clean up the expired or unreferenced data files
as well along with Iceberg metadata files.
Thank you.
```
select * from nessie.robot.ods_robot_data.snapshots;
```
lists hundreds of snapshots, but
```text
java -jar /root/helm/nessie/nessie-gc-0.99.0.jar gc --cutoff
reference-name-regex=PT1H --jdbc-url jdbc:postgresql: ...
```
delete 0 files like below:
```text
...
... 0 files considered expired, 5290 files considered live, 0 files are
newer than max-file-modification-time ...
```
even after execute
```sql
CALL nessie.system.rewrite_data_files(table =>
'nessie.robot.ods_robot_data', options =>
map('target-file-size-bytes','536870912'))
CALL nessie.system.rewrite_manifests('nessie.robot.ods_robot_data')
```
delete 0 files forever.
How expire iceberg snapshots with nessie-gc ? Thank you.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
