You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Xuefu Zhang (JIRA)" <ji...@apache.org> on 2018/02/14 16:04:00 UTC
[jira] [Commented] (HIVE-18713) Optimize: Transform IN clauses to =
when there's only one element
[ https://issues.apache.org/jira/browse/HIVE-18713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16364332#comment-16364332 ]
Xuefu Zhang commented on HIVE-18713:
------------------------------------
I'm wondering if it's a good idea to extend this such that if the number of elements is less than a threshold (say, 3), we convert it to ( (col1) = (a) OR (col1) = (b) OR (col1) = (c) ).
> Optimize: Transform IN clauses to = when there's only one element
> -----------------------------------------------------------------
>
> Key: HIVE-18713
> URL: https://issues.apache.org/jira/browse/HIVE-18713
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 3.0.0
> Reporter: Gopal V
> Assignee: Gopal V
> Priority: Major
> Attachments: HIVE-18713.1.patch
>
>
> (col1) IN (col2) can be transformed to (col1) = (col2), to avoid the hash-set implementation.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)