tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLESHOW PARTITIONS

SHOW PARTITIONS

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:16:15
List all partitions in the table.

Statement

SHOW PARTITIONS [db_name.]table_name [PARTITION(partition_spec)];

Parameter

TABLE [db_name.]table_name: Table name.
[PARTITION(partition_spec)]: Partition columns. Multiple partition column conditions are allowed.

Example

SHOW PARTITIONS db01.table PARTITION(ds='2010-03-03', hr='12');



Previous Topic: ALTER TABLE ADD PARTATIONNext Topic: ALTER TABLE DROP PARTITION

Help and Support

Was this page helpful?

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

Feedback