DROP PARTITION
De-registers the target partition with the master aggregator, and drops the physical partition on the specified leaf.
Syntax
DROP PARTITION partition_id ON 'leaf_host':leaf_port [FORCE]
Remarks
partition_id
has the formdb_name:partition_ordinal
.FORCE
: this option is used to drop detached replica partitions.- This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands).
Example
DROP PARTITION memsql_demo:63 ON 'ip-10-0-1-25.ec2.internal':3306;