[IMPALA-1917] Query return empty result if it contains NullLiteral in inlineview

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Impala 2.3.0, Impala 2.2.9
• Labels: correctness regression
• Target Version: Impala 2.3.0, Impala 2.2.9
• Assignee: Alexander Behm
• Reporter: Juan Yu
• Created: 25/Mar/15 00:07
• Updated: 15/Dec/15 22:00
• Resolved: 09/Sep/15 23:33

Description

Here is a simplified query.

create table sc (
coll_def_id string,
seg_def_id string,
customer_id string
);

insert into sc values
('001', 'aaa', 'jack'),
('002', 'bbb', 'jack'),
('001', 'aaa', 'jim'),
('001', 'ccc', 'jack'),
('002', 'aaa', 'jim');

select ad1.coll_def_id from (
select coll_def_id, count(distinct(customer_id)), NULL as dept, NULL as cat
from sc group by coll_def_id, dept) ad1;