[
https://issues.apache.org/jira/browse/FLINK-12600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-12600:
-----------------------------------
Labels: pull-request-available (was: )
> 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
>
> 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)
