Hi Team,
We are onboarding on Pinot.
Faced a strange issue that two tables out of 4 in Pinot got deleted for an unknown reason. We might have done something wrong.
Any idea about the possible reason for tables deletion. Also any logs I can refer to check this deletion operation. Any help would be appreciated. Thanks
r
Rong R
02/10/2022, 4:18 PM
when table is being deleted, the deep store segment files will be put in retention for 7 days (default cluster setting)
usually they are moved from your PinotFS base/<table_name>/<segment_name> to /base/deleted_segments/<table_name>/<segment_name>
Rong R
02/10/2022, 4:19 PM
you could probably look at the deep store deleted segment and try to find out when that deletion operation occurs, then backtrack into the controller log at that time.
a
Awadesh Kumar
02/10/2022, 4:29 PM
Thanks Rong for the insights. Any reason of default table deletion? is there any configuration that we can do to stop the default table deletion?
r
Rong R
02/10/2022, 4:31 PM
there's no default table deletion. it can only happen if someone specifically deleted the table via controller API.