The STOP PIPELINE statement stops a currently running pipeline in a SingleStore database.

Syntax

STOP PIPELINE [IF RUNNING] pipeline_name [DETACH];
STOP ALL PIPELINES;

Remarks

• An error will occur if the pipeline isn’t already running, unless IF RUNNING is specified, in which case the command is ignored.
• To stop all pipelines in the current database, run STOP ALL PIPELINES.
• Use the DETACH option to temporarily stop a pipeline, without losing offsets, for performing an ALTER on the table that is loaded from an Avro pipeline. See Avro Schema Evolution with Pipelines for details.

Example

STOP PIPELINE mypipeline;

To verify that the pipeline was successfully stopped, you can execute SHOW PIPELINES:

SHOW PIPELINES;
****
+-------------------+---------+
| Pipelines_in_mydb | State   |
+-------------------+---------+
| mypipeline        | Stopped |
+-------------------+---------+

Was this Article Helpful?

Thanks For Your Feedback!