[IMPALA-2921] "is not null" does not work in some case - ASF JIRA

XML

Word

Printable

JSON

I have two table foo and foo2, I found "is not null" does not work in some case:

table foo:

create table foo(k1 string, v int) stored as parquet;
insert into foo values('a', 10), ('b', 20);

table foo2:

create table foo2(k1 string, k2 string) stored as parquet;
insert into foo2 values('a', 'c');

After I establishing foo and foo2, the result of following statement is not correct:

WITH t1
AS (
	SELECT k2
		,sum(v) AS v
	FROM foo
	LEFT JOIN foo2 using (k1)
	GROUP BY k2
	)
SELECT *, k2 is null
FROM t1
WHERE k2 IS NOT NULL

(NULL, 20, true) is also selected, which should be omitted