You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2024/01/31 08:35:00 UTC
[jira] [Assigned] (HIVE-28000) Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.
[ https://issues.apache.org/jira/browse/HIVE-28000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa reassigned HIVE-28000:
-------------------------------------
Assignee: Anmol Sundaram
> 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
> 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)