跳到主要内容

REMOVE { internalStage | externalStage }

Removes files from either an external (external cloud storage) or internal stage.

Syntax​

REMOVE stage [ PATTERN = '<regex_pattern>' ]

Where:

internalStage​

internalStage ::= @<internal_stage_name>[/<file>]

externalStage​

externalStage ::= @<external_stage_name>[/<file>]

PATTERN = 'regex_pattern'​

A regular expression pattern string, enclosed in single quotes, specifying the file names to match.

Examples​

REMOVE @named_external_stage  PATTERN = 'ontime.*'