Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ Common HetuEngine SQL Syntax/ HetuEngine DDL SQL Syntax/ SHOW PARTITIONS
Updated on 2024-12-13 GMT+08:00
View PDF
Share

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