Fokko commented on issue #12442: URL: https://github.com/apache/iceberg/issues/12442#issuecomment-2711856445
@dvnageshpatil If you have a timestamp value: ```sql ts = '2024-10-22T19:25:00' ``` Then the transforms will produce: ```sql month(ts) = '2024-10-00' year(ts) = '2024-00-00' ``` In this case, the `year` information is useless since it is also encoded in the `month`. Therefore, just adding a `month` partition transform will do it 👍 If you want to learn more about partitioning, please check out the [partitioning docs](https://iceberg.apache.org/docs/nightly/partitioning/). I hope this helps! I'll close this issue for now, feel free to re-open it if there are any further questions. -- 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-unsubscr...@iceberg.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org For additional commands, e-mail: issues-h...@iceberg.apache.org