Skip to main content
Version: Stable-3.1

SET DEFAULT STORAGE VOLUME

Description

Sets a storage volume as the default storage volume. After creating a storage volume for an external data source, you can set it as the default storage volume of your StarRocks cluster. This feature is supported from v3.1.

CAUTION

  • Only users with the USAGE privilege on a specific storage volume can perform this operation.
  • The default storage volume cannot be dropped or disabled.
  • You must set the default storage volume for a shared-data StarRocks cluster because StarRocks stores the system statistics information in the default storage volume.

Syntax

SET <storage_volume_name> AS DEFAULT STORAGE VOLUME

Parameters

ParameterDescription
storage_volume_nameThe name of the storage volume to be set as the default storage volume.

Examples

Example 1: Set the storage volume my_s3_volume as the default storage volume.

MySQL > SET my_s3_volume AS DEFAULT STORAGE VOLUME;
Query OK, 0 rows affected (0.01 sec)

Relevant SQL statements