tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER DATABASEALTER DATABASE SET LOCATION

ALTER DATABASE SET LOCATION

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:11:31

Description

Supported engine: Presto.
Purpose: Change database storage path.

Standard Statement

ALTER (DATABASE|SCHEMA) database_name SET LOCATION hdfs_path

Parameter

[database_name]: database name.

Example

ALTER DATABASE db01 SET LOCATION 'cosn:///new/path'



Previous Topic: ALTER DATABASE SET DBPROPERTIESNext Topic: DROP DATABASE

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback