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