Updated on 2022-11-18 GMT+08:00

SHOW PARTITIONS

Syntax

SHOW PARTITIONS [catalog_name.][db_name.]table_name [PARTITION (partitionSpecs)];

Description

This statement is used to list all specified partitions.

Example

SHOW PARTITIONS test PARTITION(hr = '12', ds = 12);
SHOW PARTITIONS test PARTITION(ds > 12);