Automatic delete in vertica

phmandawaphmandawa
in General Discussion

 

Hi,

 

We are planning to delete the data present in the table every month. Is there any way to do it automatically each month?

Comments

  • eli_revacheli_revach

    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 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...