You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

TEST PIPELINE

The TEST PIPELINE statement tests an existing pipeline in a MemSQL database. When a pipeline is tested, data extraction and transformation occurs, but no output is inserted into the destination table.

When testing a pipeline, it must first be stopped. An error will occur if the pipeline is currently running.

Syntax

TEST PIPELINE pipeline_name [LIMIT count];

Example

You can limit the number of data source offsets to test by specifying a LIMIT clause, such as LIMIT 1.

TEST PIPELINE mypipeline LIMIT 1;
+------+
| id   |
+------+
| foo  |
+------+
1 row in set (1.55 sec)