Jim Apple created IMPALA-6939:
---------------------------------
Summary: Add rewrite rule to insert <=>, aka IS NOT DISTINCT FROM
Key: IMPALA-6939
URL: https://issues.apache.org/jira/browse/IMPALA-6939
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Affects Versions: Impala 3.0, Impala 2.12.0
Reporter: Jim Apple
When a user writes a query like
{noformat}
select *
from functional.testtbl t1 join functional.testtbl t2
where t1.id = t2.id or (t1.id IS NULL and t2.id IS NULL)
{noformat}
we should rewrite it to
{noformat}
select *
from functional.testtbl t1 join functional.testtbl t2
where t1.id <=> t2.id
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)