[jira] [Created] (IMPALA-7755) IS [NOT] DISTINCT FROM rewrite rules don't handle aggregates

[Paul Rogers (JIRA)]

Paul Rogers created IMPALA-7755:
-----------------------------------

             Summary: IS [NOT] DISTINCT FROM rewrite rules don't handle 
aggregates
                 Key: IMPALA-7755
                 URL: https://issues.apache.org/jira/browse/IMPALA-7755
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 3.0
            Reporter: Paul Rogers
            Assignee: Paul Rogers


Testing revealed one issue and one limitation of the {{IS [NOT] DISTINCT FROM}} 
optimizations in {{SimplifyDistinctFromRule}}.

The rule can simplify {{sum(id) <=> sum(id)}} to {{false}}. But, according to 
IMPALA-5125, the rewrite cannot be applied if it would remove the only 
aggregate. This is a bug.

A simplification is missing: {{id IS DISTINCT FROM NULL}} &rarr; {{id IS NOT 
NULL}}.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org