hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12968) genNotNullFilterForJoinSourcePlan: needs to merge predicates into the multi-AND
Date Sun, 31 Jan 2016 11:21:39 GMT

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

Jesus Camacho Rodriguez commented on HIVE-12968:
------------------------------------------------

I will add support for folding _is not null_ if there is a BETWEEN clause in HIVE-12543; thus,
we would fold this in the Calcite side.

> genNotNullFilterForJoinSourcePlan: needs to merge predicates into the multi-AND
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-12968
>                 URL: https://issues.apache.org/jira/browse/HIVE-12968
>             Project: Hive
>          Issue Type: Improvement
>          Components: Logical Optimizer
>    Affects Versions: 2.1.0
>            Reporter: Gopal V
>            Assignee: Gopal V
>            Priority: Minor
>         Attachments: HIVE-12968.1.patch
>
>
> {code}
> predicate: ((cbigint is not null and cint is not null) and cint BETWEEN 1000000 AND 3000000)
(type: boolean)
> {code}
> does not fold the IS_NULL on cint, because of the structure of the AND clause.
> For example, see {{tez_dynpart_hashjoin_1.q}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message