Help Center/Data Lake Insight/HetuEngine SQL Syntax Reference/HetuEngine SQL Syntax/DDL Syntax/SHOW PARTITIONS
Updated on 2025-08-06 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);
Parent topic:DDL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
