SingleStore Managed Service

STOP PIPELINE

The STOP PIPELINE statement stops a currently running pipeline in a SingleStore DB 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 |
+-------------------+---------+
1 row in set (0.00 sec)