kbendick commented on issue #4997: URL: https://github.com/apache/iceberg/issues/4997#issuecomment-1150602784
I just tried and you can use the string without cast. That might help for the interval one. ``` spark-sql> select '2022-01-01' - interval 1 days; 2021-12-31 00:00:00 Time taken: 2.867 seconds, Fetched 1 row(s) ``` So is it not possible to do `select * from db.tbl WHERE dt between '2022-06-06' - interval 1 days AND '2022-06-06'`; I'm thinking the removal of the explicit cast might help out (as you can see the case in the filter in the second plan). -- 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]
