Will drop a partition affect ongoing queries?

jiahe1224jiahe1224 Vertica Customer
edited November 2022 in General Discussion

My goal is to query the latest partitioned data, let's assume,
In the first second, load new data
In the 3rd second, there is a query, assuming the query takes 5 seconds
In the 5th second, the new data loading is completed, and then the old partition is dropped

Will the ongoing query be affected when the old partition is dropped in the last step? Is it so that the drop will not be performed until the query is complete?

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file