[FLINK-11966] Add support for generating optimized logical plan for simple query(Project, Filter, Values and Union all)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.9.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: godfrey he
• Reporter: godfrey he
• Created: 19/Mar/19 08:59
• Updated: 20/Mar/19 02:59
• Resolved: 20/Mar/19 02:59

Description

Add support for generating optimized logical plan for simple query,
1. Project and Filter: SELECT a, b + 1 FROM MyTable WHERE b > 2
2. Values: SELECT * FROM (VALUES (1, 2, 3)) AS T(a, b, c)
3. Union all: SELECT a, c FROM (SELECT a, c FROM MyTable1 UNION ALL SELECT a, c FROM MyTable2)

Union depends on Aggregate to eliminate duplicates, so it will be introduced after Aggregate spported.

Issue Links

• is a child of: FLINK-11488 Add a basic Blink planner framework
• links to: GitHub Pull Request #8009