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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Anmol Sundaram
• Reporter: Anmol Sundaram
• Created: 15/Jan/24 09:09
• Updated: 29/Mar/24 17:49
• Resolved: 31/Jan/24 08:36

Description

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. 

Issue Links

• links to: GitHub Pull Request #5007