Skip to main content

SUSPEND or RESUME PIPE

Description​

Suspends or resumes a pipe:

  • When a load job is in progress (namely, in the RUNNING state), suspending (SUSPEND) the pipe for the job interrupts the job.
  • When a load job encounters errors, resuming (RESUME) the pipe for the job will continue to run the erroneous job.

This command is supported from v3.2 onwards.

Syntax​

ALTER PIPE [ IF EXISTS ] <pipe_name> { SUSPEND | RESUME [ IF SUSPENDED ] }

Parameters​

pipe_name​

The name of the pipe.

Examples​

Suspend a pipe​

Suspend the pipe named user_behavior_replica (which is in the RUNNING state) in the database named mydatabase:

USE mydatabase;
ALTER PIPE user_behavior_replica SUSPEND;

If you use SHOW PIPES to query the pipe, you can see that its state has changed to SUSPEND.

Resume a pipe​

Resume the pipe named user_behavior_replica in the database named mydatabase:

USE mydatabase;
ALTER PIPE user_behavior_replica RESUME;

If you use SHOW PIPES to query the pipe, you can see that its state has changed to RUNNING.

References​