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