SHOW PARTITIONS
Description
The SHOW PARTITIONS
statement is used to list partitions of a table. An optional
partition spec may be specified to return the partitions matching the supplied
partition spec.
Syntax
Parameters
table_identifier
-
Specifies a table name, which may be optionally qualified with a database name.
Syntax:[ database_name. ] table_name
partition_spec
-
An optional parameter that specifies a comma separated list of key and value pairs
for partitions. When specified, the partitions that match the partition spec are returned.
Syntax:PARTITION ( partition_col_name [ = partition_col_val ] [ , ... ] )