[jira] [Commented] (CALCITE-2247) Add rule to push conditions into a related disjunctive expression

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16489824#comment-16489824 ] 

Zoltan Haindrich commented on CALCITE-2247:
-------------------------------------------

[~julianhyde] I think that refactor/generalization of the unknown handling should be done in a separate ticket; I would be intrested in looking into it... after CALCITE-2314 it would be probably safer to do...since it adds a lot of checks.
Are there any more things which are needed to be done before this ticket could go in?

> Add rule to push conditions into a related disjunctive expression
> -----------------------------------------------------------------
>
>                 Key: CALCITE-2247
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2247
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>            Priority: Major
>
> Simplify expressions like: {code}a = 1 AND (a = 1 OR a = 2){code} to {code}a = 1{code}
> Conditions to apply will be:
> * in an AND condition there exists a comparison(c) and an OR (o)
> * o and c only reference 1 variable
> See HIVE-19097 for more info.



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