[FLINK-25609] Avoid creating temporary tables for inline tables

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Francesco Guardiani
• Reporter: Timo Walther
• Created: 11/Jan/22 10:06
• Updated: 19/Jan/22 13:13
• Resolved: 19/Jan/22 13:13

Description

Currently, inline tables such as fromDataStream or from(TableDescriptor) as well as toChangelogStream or Table.executeInsert(TableDescriptor) create an artifical temporary table with object identifier.

This is due to Calcite that forces RelBuilder.scan to have an object identifier.

Instead we should:

• Create an internal RelOptTable that wraps CatalogTable
• Various flavors of CatalogTable can store the DataStream object or information of the TableDescriptor.
• Manually create LogicalTableScan

Issue Links

• links to: GitHub Pull Request #18349