Scheduling DROP_PARTITIONS on vertica

prad33p2301

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?

VValdar

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/