Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

DROP STAGE {FILE | FOLDER}

The DROP STAGE {FILE | FOLDER} command deletes a file or folder at the specified path within a Stage.

Syntax

DROP STAGE {FILE | FOLDER} '<stage_path>'
   [ { IN GROUP { ID '<deployment_ID>' | '<deployment_name>' } | IN { ID '<deployment_ID>' | '<deployment_name>' } } ]
   [RECURSIVE]

Arguments

  • stage_path: The path to the file or folder in the Stage. Folder paths must end with a trailing /.

  • deployment_ID, deployment_name: The ID or name of the deployment (cluster group) in which the Stage is attached.

Remarks

  • The IN and IN GROUP clauses specify the ID or the name of the deployment in which the Stage is attached.

  • To delete a folder, use the FOLDER '<stage_path>' ... [RECURSIVE] clause. The path must end with a trailing /.

  • The RECURSIVE clause is only supported in the DROP STAGE FOLDER command.

  • If the RECURSIVE clause is specified, the specified folder is deleted recursively, i.e., the contents of the specified folder are deleted before the folder itself is deleted.

  • To delete a file, use the FILE <stage_path> ... clause.

Examples

  • The following command deletes a file in the Stage attached to a deployment named s2-group:

    DROP STAGE FILE '/data/stats.csv' IN 's2-group';
  • The following command deletes a folder in the Stage attached to a deployment named s2-group:

    DROP STAGE FOLDER '/data/' IN 's2-group' RECURSIVE;

Last modified:

Was this article helpful?