SHOW-PARTITIONS
SHOW-PARTITIONS
Name
SHOW PARTITIONS
Description
This statement is used to display partition information for tables in Internal catalog or Hive Catalog
grammar:
SHOW [TEMPORARY] PARTITIONS FROM [db_name.]table_name [WHERE] [ORDER BY] [LIMIT];
illustrate:
When used in Internal catalog:
- Support the filtering of PartitionId, PartitionName, State, Buckets, ReplicationNum, LastConsistencyCheckTime and other columns
- TEMPORARY specifies to list temporary partitions
when used in Hive Catalog: Will return all partitions' name. Support multilevel partition table
Example
- Display all non-temporary partition information of the specified table under the specified db
SHOW PARTITIONS FROM example_db.table_name;
Display all temporary partition information of the specified table under the specified db
SHOW TEMPORARY PARTITIONS FROM example_db.table_name;
Display the information of the specified non-temporary partition of the specified table under the specified db
SHOW PARTITIONS FROM example_db.table_name WHERE PartitionName = "p1";
Display the latest non-temporary partition information of the specified table under the specified db
SHOW PARTITIONS FROM example_db.table_name ORDER BY PartitionId DESC LIMIT 1;
Keywords
SHOW, PARTITIONS