shivdeep-singh3 opened a new issue, #12491:
URL: https://github.com/apache/iceberg/issues/12491
### Apache Iceberg version
1.6.1
### Query engine
Spark
### Please describe the bug 🐞
When querying iceberg table on a partitioned column, the partition pruning
only works when the data type of the partition column and the filter matches-
Table create statement-
`spark.sql("""CREATE TABLE adhoc_ttl_15days.test_ice_table (entityid STRING,
day string) USING iceberg PARTITIONED BY (day) LOCATION 'gs://bucket/loc1'
TBLPROPERTIES ( 'engine.hive.enabled' = 'true', 'engine.hive.lock-enabled' =
'false', 'format' = 'iceberg/parquet', 'format-version' = '2',
'write.format.default' = 'parquet', 'write.parquet.compression-codec' =
'gzip')
| """)`
Query on partition column with string value-
<img width="1414" alt="Image"
src="https://github.com/user-attachments/assets/dc7ebb30-e0cb-405b-9f71-6847be5d0d65";
/>
Query on partition column with int value-
<img width="1390" alt="Image"
src="https://github.com/user-attachments/assets/71e55922-cadb-4c2b-9f4c-2ea762b2638b";
/>
In the case of int filter value, entire data is being scanned.
Spark Version- 3.5.2
### Willingness to contribute
- [ ] I can contribute a fix for this bug independently
- [x] I would be willing to contribute a fix for this bug with guidance from
the Iceberg community
- [x] I cannot contribute a fix for this bug at this time
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org
