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.
SHOW STAGE FILES
On this page
The SHOW STAGE FILES command returns a list of files in the Stage.
Syntax
SHOW STAGE FILES [ { IN GROUP { ID '<deployment_ID>' | '<deployment_name>' } | IN { ID '<deployment_ID>' | '<deployment_name>' } } ]
[ AT '<path>' ] [ LIKE '<pattern>' ]
[ ORDER BY '<key>' [ ASC | DESC ],... ]
[ LIMIT <limit> ] [ RECURSIVE ] [ EXTENDED ]Arguments
-
deployment_,ID deployment_: The ID or name of the deployment in which the Stage is attached.name -
path: A path in the Stage. -
pattern: Specifies a pattern similar to the SQLLIKEclause and returns files with names that match the specified pattern.Uses %as the wildcard character. -
key: Key used to sort the result set. -
limit: An integer value.
Remarks
-
The
LIMITclause limits the number of results to the specified number. -
By default, the result is sorted in the ascending order.
-
The
INandIN GROUPclauses specify the ID or name of the deployment (cluster group) in which the Stage is attached. -
Specify the
RECURSIVEclause to list the files recursively. -
Specify the
EXTENDEDclause to return more information on the files.
Example
The following command lists the files at the specified path with additional information:
SHOW STAGE FILES IN 's2-group' AT "/data/" EXTENDED;
Last modified: