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

SQDB-cluster-relative-file-path

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 defined storageClusterPath as a subdirectory named staging_area. This staging_area directory contains two subdirectories: content, intended for user-uploaded data, and temp, 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.