You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

DROP PIPELINE

The DROP PIPELINE clause deletes a pipeline from your MemSQL cluster. If the pipeline is currently running, it will stop it before deleting it.

Syntax

DROP PIPELINE pipeline_name;

Remarks

  • After a pipeline has been dropped, any data related to the pipeline will also be deleted from the information_schema tables associated with the Pipelines feature.

  • The background tasks of a pipeline runs in its resource pool. Therefore, a resource pool used by a pipeline cannot be dropped. For more information on resource pools, see Setting Resource Limits.

Example

memsql> SHOW PIPELINES;
+-------------------------+---------+
| Pipelines_in_mydatabase | State   |
+-------------------------+---------+
| quickstart_kafka        | Running |
+-------------------------+---------+
1 row in set (0.00 sec)

memsql> DROP PIPELINE quickstart_kafka;
Query OK, 0 rows affected (0.00 sec)

memsql> SHOW PIPELINES;
Empty set (0.00 sec)