You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2024/01/31 08:37:00 UTC

[jira] [Resolved] (HIVE-28000) Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.

     [ https://issues.apache.org/jira/browse/HIVE-28000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krisztian Kasa resolved HIVE-28000.
-----------------------------------
    Fix Version/s: 4.1.0
       Resolution: Fixed

Merged to master. Thanks [~AnmolSun] for the patch and [~sjc362000] and [~aturoczy] for review.

>  Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.
> ----------------------------------------------------------------------------------------
>
>                 Key: HIVE-28000
>                 URL: https://issues.apache.org/jira/browse/HIVE-28000
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: Anmol Sundaram
>            Assignee: Anmol Sundaram
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.1.0
>
>         Attachments: not_in_examples.q
>
>
> There are certain scenarios where "not in" clause gives incorrect results when type coercion cannot take place. 
> These occur when the in clause contains at least one operand which cannot be type-coerced to the column on which the in clause is being applied to. 
>  
> Please refer to the attached query examples for more details. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)