[ https://issues.apache.org/jira/browse/FLINK-12600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kurt Young closed FLINK-12600. ------------------------------ Resolution: Implemented Fix Version/s: 1.9.0 merged in 1.9.0: b333ddc16967ae7428229d659130b61de906ef5f > Introduce planner rules to do deterministic rewriting on RelNode > ----------------------------------------------------------------- > > Key: FLINK-12600 > URL: https://issues.apache.org/jira/browse/FLINK-12600 > Project: Flink > Issue Type: New Feature > Components: Table SQL / Planner > Reporter: godfrey he > Assignee: godfrey he > Priority: Major > Labels: pull-request-available > Fix For: 1.9.0 > > Time Spent: 20m > Remaining Estimate: 0h > > This issue aims to introduce planner rules to to do deterministic rewriting > on RelNode , rules include: > 1. {{FlinkLimit0RemoveRule}} that rewrites `limit 0` to empty {{Values}} > 2. {{FlinkRewriteSubQueryRule}} that rewrites a {{Filter}} with condition: > `(select count(*) from T) > 0` to a {{Filter}} with condition: `exists(select > * from T)` which could be converted to SEMI {{Join}} by > {{FlinkSubQueryRemoveRule}} > 3. {{ReplaceIntersectWithSemiJoinRule}} that rewrites distinct {{Intersect}} > to a distinct {{Aggregate}} on a SEMI {{Join}}. > 4. {{ReplaceMinusWithAntiJoinRule}} that rewrites distinct {{Minus}} to a > distinct {{Aggregate}} on an ANTI {{Join}}. -- This message was sent by Atlassian JIRA (v7.6.3#76005)