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: [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]
