REMOVE Command

Description

The REMOVE command is used to delete files from the Singdata Lakehouse data lake Volume objects, and the actual storage files in the object storage will also be deleted.

Usage Scenarios

• It can be combined with Lakehouse scheduled tasks to regularly delete files that have been imported into the lakehouse.

Syntax

REMOVE 
    [ VOLUME volume_name | TABLE VOLUME table_name | USER VOLUME ]
    [ SUBDIRECTORY 'dir' | FILE 'file' ]

Parameter Description

• VOLUME/TABLE VOLUME/USER VOLUME: Refers to deleting data from external Volume, TABLE VOLUME, and USER VOLUME respectively.
• SUBDIRECTORY/FILE: Specifies the range of files to be downloaded, which can be subdirectories within the volume. Specifying a directory will delete all files under it (SUBDIRECTORY), and you can also use the FILE parameter to delete multiple files.

Example

Delete a specific directory in the volume

REMOVE VOLUME my_volume SUBDIRECTORY 'delta-format/uploaddelta';