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);
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.