[FLINK-13731] flink sql support window with alignment

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Implemented
• Affects Version/s: 1.9.0
• Fix Version/s: 1.13.0
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major
• Assignee: Unassigned
• Reporter: zzsmdfj
• Created: 15/Aug/19 03:34
• Updated: 30/Apr/21 09:39
• Resolved: 30/Apr/21 09:39

Description

for now, sql: 

// code placeholder
SELECT  COUNT(*) GROUP BY TUMBLE(pt, interval '1' DAY, time '08:00:00')

not supported in flink sql, when rowtime is processTime, the window is  assigned by UTC time,  it is not correct day window when i was in specified time zone.