[FLINK-24081] OVER window throws exception when the rowtime is timestamp_ltz type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0, 1.14.0
• Fix Version/s: 1.14.0, 1.13.3, 1.15.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Leonard Xu
• Reporter: Leonard Xu
• Created: 31/Aug/21 12:19
• Updated: 02/Sep/21 07:15
• Resolved: 02/Sep/21 07:15

Description

 The exception as following:

org.apache.flink.table.api.TableException: OVER windows' ordering in stream mode must be defined on a time attribute. at org.apache.flink.table.planner.plan.nodes.exec.stream.StreamExecOverAggregate.translateToPlanInternal(StreamExecOverAggregate.java:158) at org.apache.flink.table.planner.plan.nodes.exec.ExecNodeBase.translateToPlan(ExecNodeBase.java:134) at org.apache.flink.table.planner.plan.nodes.exec.ExecEdge.translateToPlan(ExecEdge.java:250) at org.apache.flink.table.planner.plan.nodes.exec.common.CommonExecCalc.translateToPlanInternal(CommonExecCalc.java:88) at org.apache.flink.table.planner.plan.nodes.exec.ExecNodeBase.translateToPlan(ExecNodeBase.java:134) at org.apache.flink.table.planner.plan.nodes.exec.ExecEdge.translateToPlan(ExecEdge.java:250)

Issue Links

• links to: GitHub Pull Request #17074
• links to: GitHub Pull Request #17083
• links to: GitHub Pull Request #17084
• links to: GitHub Pull Request #17085