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 pipeline_name [IF RUNNING];
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)
Was this article useful?