Drops one or more partitions from an existing table.
Drops one or more table partitions.
Just like with columns dropping of partitions is a non-blocking and non-waiting operation. While being atomic for a single partitions, dropping of multiple partitions is in itself non-atomic. Drop partition will bail on the first failure and will not continue with the list.
The last partition (active partition) cannot be removed. This will be implemented in a future release.
Partition name must match the name of the directory for the given partition.
Naming convention for partition directories is as follows:
|Table Partition||Partition format|
Drops partitions based on a boolean expression on the designated timestamp column.