[CALCITE-5783] Support hint for TableFunctionScan

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: WenJun Min
• Reporter: WenJun Min
• Created: 15/Jun/23 06:57
• Updated: 27/Jul/23 10:22
• Resolved: 16/Jun/23 06:57

Description

This ticket is meant to make the table function scan RelNode hintable, so that we can apply some hint on the target table function.
So that we can support to use hints like

SELECT /*+ ASYNC_LATERAL('output-mode' = 'ordered', 'capacity' = '200', 'timeout' = '180s') */ a, c1, c2
FROM T1
LEFT JOIN LATERAL TABLE (async_split(b)) AS T(c1, c2) ON true

Issue Links

• links to: GitHub Pull Request #3268