[FLINK-18651] implicitly cast the time attribute to regular TIMESTAMP type in regular join

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Table SQL / Planner
• Labels: stale-major
• Assignee: Unassigned
• Reporter: godfrey he
• Created: 21/Jul/20 01:57
• Updated: 29/Apr/21 12:00
• Resolved: 29/Apr/21 12:00

Description

Currently, regular join does not accept rowtime attribute field as input, and requires users manually cast the time attribute as regular timestamp. Because time attribute will be out-of-order after regular join, and then we can't do window aggregate based on the time attribute.

We can improve it that the planner can implicitly cast the time attribute to regular TIMESTAMP type, and throws exception there is an operator (after join) depended on time attribute, like window aggregate.

Issue Links

• duplicates: FLINK-10211 Time indicators are not correctly materialized for LogicalJoin