[FLINK-22523] TUMBLE TVF should throw helpful exception when specifying second interval parameter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0, 1.13.1
• Component/s: Table SQL / API, Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jark Wu
• Reporter: Jark Wu
• Created: 29/Apr/21 06:56
• Updated: 28/Aug/21 11:20
• Resolved: 11/May/21 02:21

Description

Currently, the following query can run and no exception is thrown.

However, the second interval parameter (i.e. the offset parameter) is not supported yet. We should throw a exception for this.

select 
  date_format(window_end, 'yyyy-MM-dd') as date_str,
  date_format(window_end, 'HH:mm') as time_str,
  count(distinct user_id) as uv
from table(tumble(table user_behavior, descriptor(ts), interval '10' minute, interval '1' day))
group by window_start, window_end;

Issue Links

• links to: GitHub Pull Request #15803