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)