Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

STOP PIPELINE

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 |
+-------------------+---------+