Skip to main content

SHOW STORAGE VOLUMES

Description

Shows the storage volumes in your StarRocks cluster. This feature is supported from v3.1.

tip

This operation does not require privileges.

Syntax

SHOW STORAGE VOLUMES [ LIKE '<pattern>' ]

Parameters

ParameterDescription
patternThe pattern used to match the storage volumes.

Return value

ReturnDescription
Storage VolumeThe name of the storage volume.

Examples

Example 1: Show all storage volumes in the StarRocks cluster.

MySQL > SHOW STORAGE VOLUMES;
+----------------+
| Storage Volume |
+----------------+
| my_s3_volume |
+----------------+
1 row in set (0.01 sec)

Relevant SQL statements