When I set retentionTimeValue to 1 day for a table...
# getting-starteda
Alice
04/11/2022, 11:53 AMWhen I set retentionTimeValue to 1 day for a table, segments older than 1 day will be deleted and moved to Deleted Segments folder . Then how long will the data stay there? Is there a default duration?
k
kaushal aggarwal
04/11/2022, 12:02 PMI am also trying to understand same thing, I want to retain data for 6 months, any clearity on how to do this, would be appreciated!
m
Mark Needham
04/11/2022, 12:03 PM
the default time in the deleted segments folder is 7 days
Mark Needham
04/11/2022, 12:03 PM
for a 6 mth retention you can set the retention period to 6 mths in the segment config
Mark Needham
04/11/2022, 12:05 PM
Copy code
"segmentsConfig": {
"retentionTimeUnit": "DAYS",
"retentionTimeValue": "60",
},k
kaushal aggarwal
04/11/2022, 12:06 PMOkay thanks.
a
Alice
04/11/2022, 12:12 PMCan I change the default time in the deleted segments folder? @User
m
Mark Needham
04/11/2022, 12:13 PM
I think it's hardcoded
Mark Needham
04/11/2022, 12:14 PM
at least that's how it seems from my code reading
Mark Needham
04/11/2022, 12:14 PM
maybe create a GitHub issue if you need it to be configurable - https://github.com/apache/pinot/issues
a
Alice
04/11/2022, 12:15 PMI see. Thanks.
n
Neha Pawar
04/11/2022, 4:03 PM
there is a config. let me dig it up
Neha Pawar
04/11/2022, 4:04 PM
Copy code
controller.deleted.segments.retentionInDays🙌 1
a
Alice
04/12/2022, 1:41 AMThanks @User