hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (HIVE-742) joins dont handle null correctly
Date Sat, 08 Aug 2009 05:22:14 GMT

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


Mime
View raw message