On this page

SHOW PARTITIONS

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

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);
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback