Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Will drop a partition affect ongoing queries?

jiahe1224jiahe1224
edited November 17 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.