The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Automatic delete in vertica
Hi,
We are planning to delete the data present in the table every month. Is there any way to do it automatically each month?
0
Comments
Hi ,
database vendors don't like to take the chance and responsibility for your data in case of a bug's and stuff like this , this is the main reason why you will not see this capability in any of the main databases vendors products .
The answer to your question is :NO ,vertica like other database vendors do not provide such capabilities out of the box , however very you can get it by develop very simple cron script that will drop your the relevent monthly partition each moth .
I hope you will find it useful
Thanks