I need to find year-week part of a date. When I used YYYY-WW format, sometimes it gives wrong results. For example, 2021-01-01 returns 2021-53 but it’s real value is 2020-53. After some digging in dremio-oss code, I figured out jodatime is used, and it has a weekyear (x) format. When I tried to use it in dremio, it is not a supported format. Is it possible to add “x” as supported format.
By the way, I solved my problem temporarily by creating a new user defined function.