Options
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
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/