Show Partitions


This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See SHOW PARTITIONS.

SHOW PARTITIONS [db_name.]table_name [PARTITION 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.