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

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

youngxinler commented on issue #6853:
URL: https://github.com/apache/iceberg/issues/6853#issuecomment-1452913391

   >My question is; if we couldn't make use of year or month values directly while querying, then whats the point of creating partitions on those segments? Honestly would like to know, when and how it would be leveraged/actually used.
   
   IMO: partitions on those segments is useful,  it also works on partition query to filter files,  I also think that when using date equality comparison, the format should be converted first, otherwise the equal condition will cause ambiguity,  it's better that should use from_unixtime(ts / 1000, 'YYYY') = '2021' or cast(ts as date) = '20210101'  to get equal date data.


-- 
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