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)

Reply via email to