tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLEALTER TABLE ... SET IDENTIFIER FIELDS

ALTER TABLE ... SET IDENTIFIER FIELDS

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:19:05

Description

Supported engine: SparkSQL
Applicable table: External and native Iceberg tables
Purpose: Add identifier fields.

Statement

ALTER TABLE dempts SET IDENTIFIER FIELD empno, name

Example

ALTER TABLE tb1 SET IDENTIFIER FIELDS id, location.lon



Previous Topic: ALTER TABLE ... WRITE DISTRIBUTED BY PARTITIONNext Topic: ALTER TABLE ... DROP IDENTIFIER FIELDS

Help and Support

Was this page helpful?

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

Feedback