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_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.