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?
Question
Scheduling DROP_PARTITIONS on vertica
+1
+1Hi 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/
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
