When using the new CONVERT_TZ function for timestamps, how will windowed queries align when creating and intermediate stream with a converted timestamp and creating a CTAS with a window on that?
Previously they were aligned to the epoch.
For example, when creating day windows, they were UTC days.
We had to create a custom UDF (very similar to the CONVERT_TZ) for offsetting the bigint epoch to our desired time zone.
Can we now replace that with the built in function?