tencent cloud

$0 14-Day TrialExperience EdgeOne for acceleration and security protection!

Feedback

Data Lake Compute

ALTER TABLE SET LOCATION

Last updated: 2024-08-07 17:17:49

Description

Supported engines: Presto and SparkSQL
Applicable table: Native Iceberg table and external table.
Purpose: Change the storage path of data table.

Standard Statement

ALTER TABLE table_name [ PARTITION (partition_spec) ] SET LOCATION 'new location';

Parameter

table_name: Data table name
PARTITION (partition_spec): Specify the partitioning column.
partition_col_name: Partitioning column name
partition_col_value: Partitioning column value
'new location': New location of the table or partition on Tencent Cloud COS.

Example

ALTER TABLE tbl PARTITION (a='1', b='2') SET LOCATION '/path/to/part/ways';

ALTER TABLE tbl SET LOCATION '/path/to/part/ways';




Catalog

In The Article

ALTER TABLE SET LOCATION

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon