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

Posted to issues@hive.apache.org by "Anmol Sundaram (Jira)" <ji...@apache.org> on 2024/01/15 09:10:00 UTC

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

Anmol Sundaram created HIVE-28000:
-------------------------------------

             Summary:  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


There are certain scenarios where "not in" clause gives incorrect results when type coercion cannot take place. 

These occur when the in clause contains all the operands, none of which can 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)