Why partition key invalid

[lengkristy]

Query engine

Spark sql for iceberg

Question

Hi,
I have a partition key in iceberg table. it's 'api_timestamp' column.

if I use this condition "where from_unixtime(UNIX_TIMESTAMP(api_timestamp) ,'yyyy-MM-dd') ='2025-06-01'", it will full scan. partition key is invalid.

I checked official documentation "https://iceberg.apache.org/spec/#partitioning", but don't find any information about the cause for full scan.

thanks