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