How to purge automatically when it reaches count to 1crore?
I have the same problem what we do?
Are you asking how to purge a table when you have a row count of 10 million, or purge when you've deleted 10 million records, or something else? The question is a bit vague
It should be automatically purged when deleted count reaches to 10 million across all tables, every time it should be less than 1 million
Vertica provides two methods for determining when deleted data is eligible to be purged:
If you want to purge based on delete vector row counts, you can set up a cron job that runs every so often that issues a purge command when the dv row counts >= 10 million.