https://delta.io logo
r

Rajath Chandregowda

08/04/2023, 3:13 AM
hey everyone, I have my delta table in s3. I frequently run optimize and vaccum on the table. with this I'm able to get rid of stale parquet files. But I do i get rid of delta log and checkpoint files. It keeps on growing. I tried using the below flags, but was not successful, Am I missing anything here?
Copy code
ALTER TABLE table1
SET TBLPROPERTIES
('delta.logRetentionDuration' = 'interval 1 days', 
'delta.deletedFileRetentionDuration' = 'interval 1 days', 
'delta.checkpointRetentionDuration' = 'interval 1 days');
g

Guilhem de Viry

08/04/2023, 7:13 AM
Have you tried with
interval 1 day
?
r

Rajath Chandregowda

08/07/2023, 9:59 AM
interval 1 day
- this worked
👍 1