[jira] Resolved: (HIVE-742) joins dont handle null correctly

["Namit Jain (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain resolved HIVE-742.
-----------------------------

    Resolution: Duplicate

duplicate of https://issues.apache.org/jira/browse/HIVE-741

> joins dont handle null correctly 
> ---------------------------------
>
>                 Key: HIVE-742
>                 URL: https://issues.apache.org/jira/browse/HIVE-742
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>
> Ning Zhang added a comment - 07/Aug/09 10:46 AM
> BTW, I tried joins and it doesn't handle NULL semantics correctly. Here's the data and results:
> Table:
> Key Value
> ------- -------
> NULL 325
> 18 NULL
> Query:
> select * from input4_cb a join input4_cb b on a.key = b.value;
> Result:
> NULL 325 18 NULL
> The correct result should be empty set.
> I guess the NULL vs. NULL comparison is incorrectly evaluated.
> [ Show » ]
> Ning Zhang added a comment - 07/Aug/09 10:46 AM BTW, I tried joins and it doesn't handle NULL semantics correctly. Here's the data and results: Table: Key Value ------- ------- NULL 325 18 NULL Query: select * from input4_cb a join input4_cb b on a.key = b.value; Result: NULL 325 18 NULL The correct result should be empty set. I guess the NULL vs. NULL comparison is incorrectly evaluated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.