Help Center/
MapReduce Service/
Component Operation Guide (LTS)/
Using HetuEngine/
HetuEngine SQL Syntax/
SQL Syntax/
DDL Syntax/
SHOW PARTITIONS
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);
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.
