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)