Skip to main content

SingleStoreDB v8.0

STOP PIPELINE

The STOP PIPELINE statement stops a currently running pipeline in a SingleStoreDB 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.

  • This command causes implicit commits. See COMMIT for more information.

  • 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.

  • See the Permission Matrix for the required permission.

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)
In this section: