Show Partitions

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See SHOW PARTITIONS.

SHOW PARTITIONS [db_name.]table_name [PARTITION part_spec]

part_spec:
  : (part_col_name1=val1, part_col_name2=val2, ...)

List the partitions of a table, filtering by given partition values. Listing partitions is supported only for tables created using the Delta Lake format or the Hive format, when Hive support is enabled.