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
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
