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 anALTER
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)