Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.3.0
Description
Reproduce step:
CREATE TABLE t (a int);
INSERT INTO TABLE t VALUES(NULL);
select count(*) from t; => 1
create view vv (aa, bb) as select a aa, a bb from t;
select count(*) from vv; => 0
In query plan there is predicates: a = a, and this filters out null.
This affects view because impala rewrites this view to nested select statement.
Attachments
Issue Links
- is related to
-
IMPALA-8386 Incorrect predicate in a left outer join query
- Resolved