I have a delta table with 5 partitions, one of the partition being a runid column. When I try to delete using the runid underlying parquet files gets deleted, after using vacuum command. But this does not remove the runid partition. If I run the same vacuum command 4 times then it removes the runid partition.
For Hive we have drop partition but the same was not applicable for delta table!
Is this how the delete works in Delta table or is there any better way to delete the data and the partition for a runid from a managed delta table?