[ https://issues.apache.org/jira/browse/HIVE-741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ning Zhang updated HIVE-741: ---------------------------- Status: Resolved (was: Patch Available) Fix Version/s: 0.7.0 Resolution: Fixed Committed. Thanks Amareshwari! > NULL is not handled correctly in join > ------------------------------------- > > Key: HIVE-741 > URL: https://issues.apache.org/jira/browse/HIVE-741 > Project: Hadoop Hive > Issue Type: Bug > Reporter: Ning Zhang > Assignee: Amareshwari Sriramadasu > Fix For: 0.7.0 > > Attachments: join_nulls.q.out, patch-741-1.txt, patch-741-2.txt, > patch-741-3.txt, patch-741-4.txt, patch-741-5.txt, patch-741-6.txt, > patch-741.txt, smbjoin_nulls.q.txt > > > With the following data in table input4_cb: > Key Value > ------ -------- > NULL 325 > 18 NULL > The following query: > {code} > select * from input4_cb a join input4_cb b on a.key = b.value; > {code} > returns the following result: > NULL 325 18 NULL > The correct result should be empty set. > When 'null' is replaced by '' it works. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.