[jira] [Created] (CALCITE-2126) Optimization of COUNT (1) in OVER window

["sunjincheng (JIRA)" <ji...@apache.org>]

sunjincheng created CALCITE-2126:
------------------------------------

             Summary:  Optimization of COUNT (1) in OVER window
                 Key: CALCITE-2126
                 URL: https://issues.apache.org/jira/browse/CALCITE-2126
             Project: Calcite
          Issue Type: Improvement
            Reporter: sunjincheng
            Assignee: Julian Hyde


When we parse a SQL:
{code}
select COUNT(1) from T tumble(rowtime, interval 2 seconds)
{code}

 In RexBuild.addAggCall will do the optimize as follows:
{code}
if(aggCall.getAggregation() instanceof SqlCountAggFunction && !aggCall.isDistinct()) {
    List rex = aggCall.getArgList();
    List index = nullableArgs(rex, aggArgTypes);
    if(!index.equals(rex)) {
        aggCall = aggCall.copy(index, aggCall.filterArg);
    }
}
{code}
After the code logic above, the COUNT(1) -> COUNT().

But when we parser a SQL:
{code}
select COUNT(1) OVER(...) from T.
{code}
we do not do the optimized the parameter. So in this JIRA. want add optimize for OVER constant parameter.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)