tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLEALTER TABLE DROP PARTITION

ALTER TABLE DROP PARTITION

PDF
Focus Mode
Font Size
Last updated: 2024-08-07 17:16:26

Description

Supported engines: Presto and SparkSQL
Applicable table: External tables
Purpose: Delete a partitioning column of a data table.

Standard Statement

ALTER TABLE table_name DROP [IF EXISTS] PARTITION (partition_spec) [,PARTITION (partition_spec), ...]

partition_spec:
  : partition_column = partition_col_value, partition_column = partition_col_value, ...

Parameter

table_name: Name of the target table partition_column: Partitioning column name partition_col_value: Partitioning column value

Example

ALTER TABLE page_view DROP PARTITION (dt='2008-08-08', country='us')

ALTER TABLE `page_view` DROP
PARTITION (`dt` = '2008-08-08', `country` = 'us'),
PARTITION (`dt` = '2008-08-08', `country` = 'us'),
PARTITION (`dt` = '2008-08-08', `country` = 'us')



Previous Topic: SHOW PARTITIONSNext Topic: ALTER TABLE ADD PARTITION FIELD

Help and Support

Was this page helpful?

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

Feedback