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: issues-unsubscr...@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org

Reply via email to