Will drop a partition affect ongoing queries?
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?