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