[GitHub] [iceberg] rdblue commented on issue #6853: Iceberg partition date/day equality problem when created on timestamp

["rdblue (via GitHub)" <gi...@apache.org>]

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: issues-unsubscribe@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org