calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <>
Subject [jira] [Created] (CALCITE-1368) Infer predicates for aggregate functions
Date Sat, 03 Sep 2016 00:09:20 GMT
Julian Hyde created CALCITE-1368:

             Summary: Infer predicates for aggregate functions
                 Key: CALCITE-1368
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde

Currently when inferring predicates for Aggregate, Calcite only pulls up existing predicates,
and it can only do that for columns that are part of the group key. This feature would infer
predicates based on the behavior of aggregate functions and, sometimes, predicates of the
arguments to those functions.

* {{count\(*)}} and {{count\(x)}} are always > 0 (if groups are non-empty, and x is not
* {{count\(*)}} and {{count\(x)}} are always >= 0
* {{sum\(x)}} is >= 0 (if x is >= 0; it's OK if x is sometimes null)
* {{min\(x)}} and {{max\(x)}} have the same upper and lower bounds as x

This message was sent by Atlassian JIRA

View raw message