[
https://issues.apache.org/jira/browse/HIVE-28000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anmol Sundaram updated HIVE-28000:
----------------------------------
Attachment: not_in_examples.q
> 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
> Priority: Major
> 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)
