ALTER TABLE DROP PARTITION
Drops one or more partitions from an existing table.
Similar to dropping columns, dropping of partitions is a non-blocking and non-waiting operation. While atomic for single partitions, dropping multiple partitions is in itself non-atomic. The operation will exit on the first failure and will not continue through a list of partitions if one fails to be dropped.
caution
Use DROP PARTITION
with care, as QuestDB cannot recover data from dropped
partitions! Backup your database to avoid
unintended data loss.
#
Syntax
#
Drop partition by nameThe partition name must match the name of the directory for the given partition. The naming convention is detailed in Partitions.
#
Examples#
Drop partitions using boolean expressionDrops partitions based on a boolean expression on the designated timestamp column.