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

[Anmol Sundaram (Jira)]

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)