De-registers the target partition with the master aggregator, and drops the physical partition on the specified leaf.

DROP PARTITION partition_id ON 'leaf_host':leaf_port

Notes

• partition_id has the form db_name:partition_ordinal.
• This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands).

Example

memsql> DROP PARTITION memsql_demo:63 ON 'ip-10-0-1-25.ec2.internal':3306;
Query OK, 1 row affected (0.01 sec)

Was this Article Helpful?

Thanks For Your Feedback!