SHOW-PARTITIONS

Name

SHOW PARTITIONS

Description

This statement is used to display partition information

grammar:

  1.   SHOW [TEMPORARY] PARTITIONS FROM [db_name.]table_name [WHERE] [ORDER BY] [LIMIT];

illustrate:

  1. Support the filtering of PartitionId, PartitionName, State, Buckets, ReplicationNum, LastConsistencyCheckTime and other columns
  2. TEMPORARY specifies to list temporary partitions

Example

  1. Display all non-temporary partition information of the specified table under the specified db
  1.   SHOW PARTITIONS FROM example_db.table_name;

  1. Display all temporary partition information of the specified table under the specified db

    1. SHOW TEMPORARY PARTITIONS FROM example_db.table_name;

  2. Display the information of the specified non-temporary partition of the specified table under the specified db

    1.  SHOW PARTITIONS FROM example_db.table_name WHERE PartitionName = "p1";

  3. Display the latest non-temporary partition information of the specified table under the specified db

    1. SHOW PARTITIONS FROM example_db.table_name ORDER BY PartitionId DESC LIMIT 1;

Keywords

  1. SHOW, PARTITIONS

Best Practice