[
https://issues.apache.org/jira/browse/HIVE-11424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15194982#comment-15194982
]
Jesus Camacho Rodriguez commented on HIVE-11424:
------------------------------------------------
[~damien.carol], there are multiple reasons.
>From the optimizer perspective, it is a way of normalizing expressions in
>Filter operators so we can find potential duplicate expressions and remove
>them. This also has an impact in the operator statistics estimation.
Further, it will make a difference in execution performance for large number of
comparisons using e.g. vectorization. I do not remember the exact details, but
I believe [~gopalv] can extend on it.
> Rule to transform OR clauses into IN clauses in CBO
> ---------------------------------------------------
>
> Key: HIVE-11424
> URL: https://issues.apache.org/jira/browse/HIVE-11424
> Project: Hive
> Issue Type: Bug
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-11424.01.patch, HIVE-11424.01.patch,
> HIVE-11424.03.patch, HIVE-11424.03.patch, HIVE-11424.04.patch,
> HIVE-11424.2.patch, HIVE-11424.patch
>
>
> We create a rule that will transform OR clauses into IN clauses (when
> possible).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
