You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Jim Apple (JIRA)" <ji...@apache.org> on 2018/04/26 18:37:00 UTC

[jira] [Created] (IMPALA-6939) Add rewrite rule to insert <=>, aka IS NOT DISTINCT FROM

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)