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 format or the Hive format, when Hive support is enabled.