Antalya 25.8.12.20747 fails to find Date values on tripdata using where condition #1303
Description
Describe the bug
The following query on tripdata stored in parquet fails to find any data. The release version is 25.8.12.20747.
SELECT min(pickup_date), max(pickup_date), count(), avg(passenger_count)
FROM ice_2.`nyc.tripdata`
WHERE pickup_date = toDate('2016-02-26')
┌─min(pickup_date)─┬─max(pickup_date)─┬─count()─┬─avg(passenger_count)─┐
1. │ 1970-01-01 │ 1970-01-01 │ 0 │ nan │
└──────────────────┴──────────────────┴─────────┴──────────────────────┘
If you turn pickup_date into a string it works fine. I get the same answer when reading the data from MergeTree so the problem is clearly related to Parquet and/or Iceberg.
SELECT min(pickup_date), max(pickup_date), count(), avg(passenger_count)
FROM ice_2.`nyc.tripdata`
WHERE toString(pickup_date) = '2016-02-26'
┌─min(pickup_date)─┬─max(pickup_date)─┬─count()─┬─avg(passenger_count)─┐
1. │ 2016-02-26 │ 2016-02-26 │ 437798 │ 1.6378421098314748 │
└──────────────────┴──────────────────┴─────────┴──────────────────────┘
I have appended the trace logs for the query.
To Reproduce
Steps to reproduce the behavior:
- Run the above query in the my-clickhouse test server in Altinity.Cloud.
Expected behavior
The query should return the same results in both cases.
Screenshots
N/A
Key information
Provide relevant runtime details.
- Project Antalya Build Version:
- Altinity.Cloud altinity-antalya environment.
- Kubernetes provider: EKS
- Object storage, AWS S3
- Iceberg catalog: Altinity Ice REST Catalog
Additional context
Add any other context about the problem here.