Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
Impala 3.0, Impala 2.12.0
-
None
-
None
-
ghx-label-6
Description
When a user writes a query like
select * from functional.testtbl t1 join functional.testtbl t2 where t1.id = t2.id or (t1.id IS NULL and t2.id IS NULL)
we should rewrite it to
select * from functional.testtbl t1 join functional.testtbl t2 where t1.id <=> t2.id