[
https://issues.apache.org/jira/browse/HIVE-21685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16832300#comment-16832300
]
Zoltan Haindrich edited comment on HIVE-21685 at 5/3/19 7:07 AM:
-----------------------------------------------------------------
I think we may consider removing the RexMergeInClause ; I think it's not that
usefull anymore since we are opening/closing INs.
was (Author: kgyrtkirk):
I think we should could also consider removing the RexMergeInClause ; I think
it's not that usefull anymore since we are opening/closing INs.
> Wrong simplification in query with multiple IN clauses
> ------------------------------------------------------
>
> Key: HIVE-21685
> URL: https://issues.apache.org/jira/browse/HIVE-21685
> Project: Hive
> Issue Type: Bug
> Components: CBO
> Reporter: Oliver Draese
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
> Attachments: HIVE-21685.patch, HIVE-21685.patch
>
>
> Simple test to reproduce:
> {code}
> select * from table1 where name IN(‘g’,‘r’) AND name IN(‘a’,‘b’);
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
