tencent cloud

ALTER TABLE DROP PARTITION
Download PDF
Last updated: 2024-08-07 17:16:26
ALTER TABLE DROP PARTITION
Last updated: 2024-08-07 17:16:26
Download PDF

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')



Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback