[CALCITE-3339] DESCRIPTOR as a SQL operator in SqlStdOperatorTable

• 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 19:26
• Updated: 04/May/20 08:04
• Resolved: 15/Jan/20 05:19

Description

For query:

SELECT *
FROM TABLE(TUMBLE_TVF(
TABLE ORDERS,
DESCRIPTOR(ROWTIME),
INTERVAL '10' MINUTE))

TABLE ORDERS is converted to SqlPrefixOperator, but DESCRIPTOR(ROWTIME) has no mapping in SqlStdOperatorTable.

There are two options:
1. There is a SqlColumnListConstructor which serves the same(similar) purpose to specific a list of column.
2. We create a new operator for DESCRIPTOR.

Reuse existing code is always good so we can start from option one and see if it works.

Issue Links

• blocks: CALCITE-3272 TUMBLE Table-valued Function
• is a child of: CALCITE-2270 [SQL:2016] Polymorphic table functions
• links to: Github Pull Request 1587
• links to: GitHub Pull Request #1599