[CALCITE-3340] Support Table-valued Function TUMBLE in Planner

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Rui Wang
• Reporter: Rui Wang
• Created: 11/Sep/19 22:53
• Updated: 06/Mar/20 04:36
• Resolved: 15/Jan/20 01:42

Description

The goal of this JIRA is to generate a logical plan for the following query:

SELECT *
FROM TABLE(TUMBLE(
TABLE ORDERS,
INTERVAL '10' MINUTE))

This SQL query does not have DESCRIPTOR included, which is being tracked and discussed by CALCITE-3339.

I expect we should generate a logical plan from this query that is similar to the following:

LogicalProject(ROWTIME=[$0], ID=[$1], PRODUCT=[$2], UNITS=[$3], wstart=[$4], wend=[$5])
  LogicalTableFunctionScan(invocation=[TUMBLE($3, 60000:INTERVAL MINUTE)], rowType=[RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, TIMESTAMP(0) wstart, TIMESTAMP(0) wend)])
    LogicalProject(ROWTIME=[$0], ID=[$1], PRODUCT=[$2], UNITS=[$3])
      LogicalTableScan(table=[[ORINOCO, ORDERS]])

Issue Links

• blocks: CALCITE-3272 TUMBLE Table-valued Function
• is blocked by: CALCITE-3382 Rename current TUMBLE to "$TUMBLE" and add TUMBLE to Parser
• is blocked by: CALCITE-3418 Grouped Window Function TUMBLE should return "$TUMBLE" as its operator name
• links to: GitHub Pull Request #1457
• links to: Github Pull Request #1587