Hello
select count(*) not leverage metadata with where condition on partition column
this query uses the metadata correctly and answers fast as mentioned in this link
https://delta.io/blog/2023-04-19-faster-aggregations-metadata/:
select count(*) from table
but this query is not:
select count(*) from table where partition_col = part_value
spark version: 3.3.2
delta version: 2.3