You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2018/10/25 03:28:00 UTC
[jira] [Created] (IMPALA-7755) IS [NOT] DISTINCT FROM rewrite rules
don't handle aggregates
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}} → {{id IS NOT NULL}}.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org