rdblue commented on issue #6853: URL: https://github.com/apache/iceberg/issues/6853#issuecomment-1433483721
Is this a problem? I think it is correct, although not necessarily intuitive. The filter is `trans_ts=date'2019-06-13'` but the only `trans_ts` in the table is `2019-06-13 17:22:30.000000 UTC`, which is NOT equal to `2019-06-13 00:00:00.000000`. I can see how this would be unexpected, because you thought that the timestamp would be converted to a date but instead the date is converted to a timestamp, and then the equals check runs. I think this is the same in both Trino and Spark because they both cast values to the wider type. In this case, timestamp rather than date. -- 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]
