[HIVE-741] NULL is not handled correctly in join

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.7.0
• Component/s: Query Processor, Serializers/Deserializers
• Assignee: Amareshwari Sriramadasu
• Reporter: Ning Zhang
• Created: 08/Aug/09 03:58
• Updated: 16/Feb/12 23:42
• Resolved: 24/Aug/10 22:21

Description

With the following data in table input4_cb:

Key Value
------ --------
NULL 325
18 NULL

The following query:

select * from input4_cb a join input4_cb b on a.key = b.value;

returns the following result:

NULL 325 18 NULL

The correct result should be empty set.

When 'null' is replaced by '' it works.

Issue Links

• incorporates: HIVE-1552 Nulls are not handled in Sort Merge MapJoin
• is a clone of: HIVE-734 problem in dealing with null
• is duplicated by: HIVE-1460 JOIN should not output rows for NULL values
• relates to: HIVE-1552 Nulls are not handled in Sort Merge MapJoin
• relates to: HIVE-2810 Implement NULL-safe equality operator <=>
• relates to: HIVE-1544 Filtering out NULL-keyed rows in ReduceSinkOperator when no outer join involved