Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
DROP PIPELINE
On this page
The DROP PIPELINE
clause deletes a pipeline from your SingleStore cluster.
Syntax
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_
tables associated with the Pipelines feature.schema -
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 Permission Matrix for the required permission.
Caution
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.
Example
SHOW PIPELINES;
+-------------------------+---------+
| Pipelines_in_mydatabase | State |
+-------------------------+---------+
| quickstart_kafka | Running |
+-------------------------+---------+
DROP PIPELINE quickstart_kafka;Query OK, 0 rows affected (0.00 sec)
SHOW PIPELINES;Empty set (0.00 sec)
Last modified: November 14, 2023