ludlows opened a new issue, #11438:
URL: https://github.com/apache/iceberg/issues/11438
### Apache Iceberg version
1.6.1 (latest release)
### Query engine
Spark
### Please describe the bug 🐞
given an iceberg table created by the following sql:
```sql
CREATE TABLE icbtest.test0(
`pk_id` int,
val string,
start_dt string,
end_dt string
) USING iceberg
partitioned by (truncate(6, end_dt))
;
```
after that, we run the `rewriteDataFiles` procedure by the sql:
```sql
set spark.sql.caseSensitive=false;
call
my_catalog.system.rewrite_data_files(table=>'local.ods_icbtest.wm_test0', where
=> " END_DT > '202008' ");
```
the following exception is raised
since the `where` sql is always case sensitive, and `set
spark.sql.caseSensitive=false` does not take effects.
### Willingness to contribute
- [X] 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
- [ ] 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
