tencent cloud

Data Lake Compute

ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:18:21

Description

Supported engine: SparkSQL
Applicable table: External and native Iceberg tables
Purpose: Change data distribution policy of partitioned table.

Statement

ALTER TABLE table_identifier
WRITE DISTRIBUTED BY PARTITION
[ LOCALLY ORDERED BY
{col_name [ASC|DESC] [NULLS FIRST|LAST]}[, ...]]

Example

ALTER TABLE dempts WRITE DISTRIBUTED BY PARTITION;
ALTER TABLE dempts WRITE DISTRIBUTED BY PARTITION LOCALLY ORDERED BY id;




Help and Support

Was this page helpful?

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

Feedback