hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jimmy Xiang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12511) IN clause performs differently then = clause
Date Tue, 24 Nov 2015 22:30:10 GMT

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

Jimmy Xiang commented on HIVE-12511:
------------------------------------

I think we should fix GenericUDFIn to use common type for comparison instead of generic common
type. In this case, for common type of int and string, we should use int instead of string.

> IN clause performs differently then = clause
> --------------------------------------------
>
>                 Key: HIVE-12511
>                 URL: https://issues.apache.org/jira/browse/HIVE-12511
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Jimmy Xiang
>            Assignee: Jimmy Xiang
>
> Similar to HIVE-11973, IN clause performs differently then = clause for "int" type with
string values.
> For example,
> {noformat}
> SELECT * FROM inttest WHERE iValue IN ('01');
> {noformat}
> will not return any rows with int iValue = 1.



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

Mime
View raw message