Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

DROP PIPELINE

Syntax

SQL

DROP PIPELINE [IF EXISTS] 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.
This command causes implicit commits. Refer to COMMIT for more information.
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 Set Resource Limits.
Refer to the Permissions Matrix for the required permissions.

Warning

If a pipeline is dropped and recreated, the pipeline will start reading from the earliest offset in the data source, once the pipeline is started. This may cause duplicate records to be inserted into the destination table(s).

Example

SQL

SHOW PIPELINES;

+-------------------------+---------+
| Pipelines_in_mydatabase | State   |
+-------------------------+---------+
| quickstart_kafka        | Running |
+-------------------------+---------+

SQL

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

SQL

SHOW PIPELINES;
Empty set (0.00 sec)