[
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)
