[jira] [Commented] (CALCITE-1404) Implement FILTER on aggregate functions in Interpreter

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

    [ https://issues.apache.org/jira/browse/CALCITE-1404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15563918#comment-15563918 ] 

Julian Hyde commented on CALCITE-1404:
--------------------------------------

Agreed. Such queries are currently giving the wrong results.

To fix it, I plan to implement the {{FILTER (WHERE condition))}} clause (i.e. observe {{AggregateCall.filterArg}}) in {{AggregateNode}} (i.e. the {{Aggregate}} relational operator implemented inside the {{Interpreter}}) and this will also fix it for {{BindableAggregate}}.

> Implement FILTER on aggregate functions in Interpreter 
> -------------------------------------------------------
>
>                 Key: CALCITE-1404
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1404
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Gian Merlino
>            Assignee: Julian Hyde
>
> BindableAggregate doesn't properly filter aggregates like SUM(cnt) FILTER(WHERE foo = 'bar'). It seems to be ignoring the filter completely.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)