[FLINK-11310] Convert predicates to IN or NOT_IN for Project

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Component/s: Table SQL / Planner
• Labels: auto-unassigned pull-request-available
• Assignee: Unassigned
• Reporter: Hequn Cheng
• Created: 13/Jan/19 07:50
• Updated: 20/May/21 07:51
• Resolved: 20/May/21 07:51

Description

In FLINK-10474, we force translate IN into a predicate to avoid translating to a JOIN. In addition, we add a Rule to convert the predicates back to IN so that we can generate code using a HashSet for the IN.

However, FLINK-10474 only takes Filter into consideration. It would be great to also convert predicates in Project to IN. It not only will improve the performance for the Project, but also will avoid the problem raised in FLINK-11308, as all predicates will be converted into one IN expression.

Issue Links

• links to: GitHub Pull Request #7483