[FLINK-18508] Dynamic source supports statistics and parallelism report

• Type: New Feature
• Status: In Progress
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor pull-request-available
• Assignee: Unassigned
• Reporter: Jingsong Lee
• Created: 07/Jul/20 02:40
• Updated: 11/Jan/22 12:22

Description

Add SupportsStatisticsReport and SupportsParallelismReport to dynamic source, source can return some information to help table optimizer.

This information can be more accurate from the source rather than the catalog. 

• First, the information is computed base on real data, for iceberg / filesystem connector, it can be calculated from real files. Although it is related to physical/runtime, it is real and exact.
• Second, For example, for iceberg / filesystem connector, after filter and partition pushdown, the statistics have been greatly adjusted, and many files may have been filtered out.

Issue Links

• duplicates: FLINK-19322 Specified parallelism in create table operation
• relates to: FLINK-16903 Add sink.parallelism for file system factory
• relates to: FLINK-25152 FLIP-188: Introduce Built-in Dynamic Table Storage
• links to: GitHub Pull Request #13016
• links to: GitHub Pull Request #18277