REMOVE
The REMOVE
function addresses the need to remove files from the database’s internal staging area.
Syntax
REMOVE <'SQDB-cluster-relative-file-path'>;
Parameters
Parameter |
Description |
---|---|
|
File path to remove - relative to the defined SQDB cluster staging area. |
Important Considerations
The SQDB cluster staging area’s root path is configured using the
stagingAreaRootPath
flag. By default, this area is created within the definedstorageClusterPath
as a subdirectory named staging_area. Thisstaging_area
directory contains two subdirectories:content
, intended for user-uploaded data, andtemp
, reserved for internal system operations.The command is limited to a single file deletion per execution.
File extensions are limited to supported FDWs.
The command execution is CPU based and does not use GPU Workers.
Up to 50 concurrent
PUT
/GET
/REMOVE
operation are supported per SQDB cluster.The feature is supported for the following drivers: PySQream, JDBC, ODBC
Permissions
The role must have the SUPERUSER
privilege.