[FLINK-11017] Time interval for window aggregations in SQL is wrongly translated if specified with YEAR_MONTH resolution

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.2, 1.7.0
• Fix Version/s: 1.6.3, 1.7.1, 1.8.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Dawid Wysakowicz
• Reporter: Dawid Wysakowicz
• Created: 28/Nov/18 10:58
• Updated: 01/Oct/19 15:38
• Resolved: 30/Nov/18 12:28

Description

If a time interval was specified with YEAR TO MONTH resolution like e.g.:

SELECT * 
FROM Mytable
GROUP BY 
    TUMBLE(rowtime, INTERVAL '1-2' YEAR TO MONTH)

it will be wrongly translated to 14 milliseconds window. We should allow for only DAY TO SECOND resolution.

Issue Links

• links to: GitHub Pull Request #7200