Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

DROP PIPELINE

The DROP PIPELINE clause deletes a pipeline from your SingleStore DB 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

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

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

SHOW PIPELINES;
Empty set (0.00 sec)