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] Created: (HIVE-742) joins dont handle null correctly
Date Sat, 08 Aug 2009 05:14:14 GMT
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