[FLINK-20387] Support defining event time attribute on TIMESTAMP_LTZ column

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Table SQL / API, Table SQL / Planner
• Labels: pull-request-available

Release Note

Support defining event time attribute on TIMESTAMP_LTZ column, base on this, Flink SQL gracefully support the Daylight Saving Time.

• Assignee: Leonard Xu
• Reporter: Jark Wu
• Created: 27/Nov/20 07:03
• Updated: 28/May/21 09:02
• Resolved: 09/Apr/21 08:49

Description

Currently, only TIMESTAMP type can be used as rowtime attribute. Would be better to support TIMESTAMP WITH LOCAL ZONE TIME as well.

As a workaround, users can cast the TIMESTAMP WITH LOCAL ZONE TIME into TIMESTAMP, CAST(ts AS TIMESTAMP).

Issue Links

• is related to: FLINK-21803 Tumbling / Sliding windows are unaware of daylight savings time
• relates to: FLINK-20162 Fix time zone problems for some time related functions
• links to: GitHub Pull Request #15485