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)