Outdated Version
You are viewing an older version of this section. View current production version.
STOP PIPELINE
The STOP PIPELINE statement stops a currently running pipeline in a MemSQL database. 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.
Syntax
STOP PIPELINE [IF RUNNING] pipeline_name;
STOP ALL PIPELINES;
Example
memsql> STOP PIPELINE mypipeline;
Query OK, 0 rows affected (0.04 sec)
To verify that the pipeline was successfully stopped, you can execute SHOW PIPELINES:
memsql> SHOW PIPELINES;
+-------------------+---------+
| Pipelines_in_mydb | State |
+-------------------+---------+
| mypipeline | Stopped |
+-------------------+---------+
1 row in set (0.00 sec)
