- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 05:39 AM
Hello! I am trying to understand time travel feature. I see with "DESCRIBE HISTORY" command that all the transaction history on a specific table is recorded by version and timestamp. However, I understand that this occupies a lot of storage especially if a table is updated every day. Is there a way to remove history or reduce the retention period? What is the minimun and maximum retention period you can have with time travel? I tried the below commands but "DESCRIBE HISTORY" didn't bring different results.
ALTER TABLE table_name
SET TBLPROPERTIES ('delta.logRetentionDuration'='interval 1 HOURS', 'delta.deletedFileRetentionDuration'='interval 1 HOURS')
VACUUM table_name
- Labels:
-
Time travel