DROP PIPE

DROP PIPE drops a pipe and the related jobs and metadata. Executing this statement on a pipe does not revoke the data that has been loaded via this pipe. This command is supported from v3.2 onwards.

Syntax

DROP PIPE [IF EXISTS] [db_name.]<pipe_name>

Parameters

db_name

The name of the database to which the pipe belongs.

pipe_name

The name of the pipe.

Examples

Drop the pipe named user_behavior_replica in the database named mydatabase:

USE mydatabase;
DROP PIPE user_behavior_replica;

References

• CREATE PIPE
• ALTER PIPE
• SHOW PIPES
• SUSPEND or RESUME PIPE
• RETRY FILE