You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Brock Noland (JIRA)" <ji...@apache.org> on 2013/07/12 20:37:48 UTC

[jira] [Created] (HIVE-4845) Correctness issue with MapJoins using the null safe operator

Brock Noland created HIVE-4845:
----------------------------------

             Summary: Correctness issue with MapJoins using the null safe operator
                 Key: HIVE-4845
                 URL: https://issues.apache.org/jira/browse/HIVE-4845
             Project: Hive
          Issue Type: Bug
            Reporter: Brock Noland
            Assignee: Brock Noland
            Priority: Critical


I found a correctness issue while working on HIVE-4838. The following query from join_nullsafe.q gives different results depending on if it's executed map-side or reduce-side:

{noformat}
SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key <=> b.key AND a.value <=> b.value ORDER BY a.key, a.value, b.key, b.value;
{noformat}


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira