[jira] [Closed] (FLINK-12600) Introduce planner rules to do deterministic rewriting on RelNode

["Kurt Young (JIRA)" <ji...@apache.org>]

     [ 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)