[HIVE-14027] NULL values produced by left outer join do not behave as NULL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.1, 2.2.0
• Fix Version/s: 1.3.0, 2.1.1, 2.2.0
• Component/s: Query Processor
• Assignee: Jesús Camacho Rodríguez
• Reporter: Vaibhav Gumashta
• Created: 15/Jun/16 22:52
• Updated: 27/Feb/24 22:23
• Resolved: 11/Jul/16 17:19

Description

Consider the following setup:

create table tbl (n bigint, t string); 

insert into tbl values (1, 'one'); 
insert into tbl values(2, 'two');

select a.n, a.t, isnull(b.n), isnull(b.t) from (select * from tbl where n = 1) a  left outer join  (select * from tbl where 1 = 2) b on a.n = b.n;

1    one    false    true

The query should return true for isnull(b.n).

I've tested by inserting a row with null value for the bigint column into tbl, and isnull returns true in that case.

Issue Links

• is duplicated by: HIVE-13977 nvl funtion not working after left outer join
• relates to: HIVE-14208 MapJoin uses key of outer input and Converter