You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Will Noble (Jira)" <ji...@apache.org> on 2021/12/08 00:18:00 UTC

[jira] [Created] (CALCITE-4925) AggregateReduceFunctionsRule should accept arbitrary predicates

Will Noble created CALCITE-4925:
-----------------------------------

             Summary: AggregateReduceFunctionsRule should accept arbitrary predicates
                 Key: CALCITE-4925
                 URL: https://issues.apache.org/jira/browse/CALCITE-4925
             Project: Calcite
          Issue Type: Improvement
            Reporter: Will Noble


`AggregateReduceFunctionsRule` allows you to specify which functions to reduce, but only allows you to specify by function type. For instance, you can either reduce all {{SUM}} functions, or no {{SUM}} functions, but not a subset of {{SUM}} functions (say, only the {{SUM}} functions with distinct keys). Allowing the user to specify an arbitrary predicate would allow us to selective apply the rule to functions without distinct keys, which matters in Looker due to the fact that distinct keys cause an aggregate to be impossible to roll up, and when that's the case, we'd like to avoid reducing the functions for the purpose of aggregate awareness.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)