tencent cloud

Data Lake Compute

ALTER TABLE ... DROP IDENTIFIER FIELDS

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

Description

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

Statement

ALTER TABLE dempts DROP IDENTIFIER FIELD empno, name

Example

ALTER TABLE tb1 DROP IDENTIFIER FIELDS id, location.lon



Help and Support

Was this page helpful?

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

Feedback