DROP PIPELINE
The DROP PIPELINE
clause deletes a pipeline from your SingleStoreDB cluster. If the pipeline is currently running, it will stop it before deleting it.
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_schema
tables associated with the Pipelines feature.This command causes implicit commits. See 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.
See 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. This may cause duplicate records to be inserted into the destination table(s).
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)