[jira] [Closed] (FLINK-12487) Introduce planner rules to rewrite expression and merge calc

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

     [ https://issues.apache.org/jira/browse/FLINK-12487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kurt Young closed FLINK-12487.
------------------------------
       Resolution: Implemented
    Fix Version/s: 1.9.0

merge in 1.9.0: b47b5910c16a423504171a2a29230ff1d8966214

> Introduce planner rules to rewrite expression and merge calc
> ------------------------------------------------------------
>
>                 Key: FLINK-12487
>                 URL: https://issues.apache.org/jira/browse/FLINK-12487
>             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 rewrite expression and merge calc, rules include:
> 1. {{ConvertToNotInOrInRule}}, that converts a cascade of predicates to {{IN}} or {{NOT_IN}},
> e.g. 
>  converts predicate {{(x = 1 OR x = 2 OR x = 3 OR x = 4) AND y = 5}} to predicate {{x IN (1, 2, 3, 4) AND y = 5}}
>  converts predicate {{(x <> 1 AND x <> 2 AND x <> 3 AND x <> 4) AND y = 5}} to predicate {{x NOT IN (1, 2, 3, 4) AND y = 5}}
> 2. {{RewriteCoalesceRule}}, that rewrites {{Coalesce}} to {{Case When}}
> 3. {{FlinkCalcMergeRule}}, that is copied from Calcite {{CalcMergeRule}}, and it will simplify the merged program



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)