[
https://issues.apache.org/jira/browse/HIVE-11424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15206417#comment-15206417
]
Jesus Camacho Rodriguez commented on HIVE-11424:
------------------------------------------------
I have uploaded a new patch:
- It solves the issues seen with partition condition removal optimization for
IN clauses. The problem was that IN clauses with a _column reference_ instead
of a _struct_ were not being considered for removal.
- It extends pointlookup optimizer in Calcite to merge the resulting IN clauses.
- It adds a new flag to choose whether to run pointlookup optimizer in Calcite
vs Hive. This is necessary: as we do not execute the removal of partition
conditions in Calcite, sometimes we cannot fold as tight as we should; I have
seen filter conditions that are simpler when we run the optimization in Hive
(e.g. pointlookup_nocbo.q).
> 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.05.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)
