VeloDB Cloud
SQL Manual
SQL Statements
Database Administration
SET-DEFAULT-STORAGE-VAULT

Description

This statement is used to set the default storage vault in Doris. The default storage vault is used to store data for internal or system tables. If the default storage vault is not set, Doris will not function properly. Once the default storage vault is set, it cannot be removed.

Syntax

SET vault_name DEFAULT STORAGE VAULT

Note:

  1. Only ADMIN users can set the default storage vault.

Example

  1. Set the storage vault named 's3_vault' as the default storage vault.

    SET s3_vault AS DEFAULT STORAGE VAULT;

Related Commands

Keywords

SET, DEFAULT, STORAGE, VAULT