Scheduling DROP_PARTITIONS on vertica
I have a table which holds 6 months of data and also partitioned by a Date only column in the table. Is there a way for scheduling DROP_PARTITIONS on vertica from within management console?
0
The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.
Join us there to post discussion topics, learn about
product releases, share tips, access the blog, and much more.
I have a table which holds 6 months of data and also partitioned by a Date only column in the table. Is there a way for scheduling DROP_PARTITIONS on vertica from within management console?
Answers
Hi prad33p2301,
You can put your logic into a stored procedure then schedule it in-database:
https://docs.vertica.com/24.1.x/en/extending/stored-procedures/executing-stored-procedures/triggers/scheduled-execution/