You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/02/19 03:07:00 UTC

[jira] [Resolved] (CALCITE-2707) Information about distinct aggregation is lost in MATCH_RECOGNIZE

     [ https://issues.apache.org/jira/browse/CALCITE-2707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Danny Chen resolved CALCITE-2707.
---------------------------------
    Fix Version/s: 1.22.0
         Assignee: Danny Chen
       Resolution: Fixed

Fixed in [b8deb18|https://github.com/apache/calcite/commit/b8deb183e88bc4b22f23b0fe03d1b8fc6603c600] !

> Information about distinct aggregation is lost in MATCH_RECOGNIZE
> -----------------------------------------------------------------
>
>                 Key: CALCITE-2707
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2707
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Dawid Wysakowicz
>            Assignee: Danny Chen
>            Priority: Major
>              Labels: match, pull-request-available
>             Fix For: 1.22.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> There is no information that the COUNT aggregation is distinct in a plan for a query like e.g. this:
> {code}
> SELECT *
> FROM MyTable
> MATCH_RECOGNIZE (
>   MEASURES
>     ....
>   AFTER MATCH SKIP PAST LAST ROW
>   PATTERN (A B+ C)
>   DEFINE
>     B AS COUNT(DISTINCT B.id) < 4
> ) AS T
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)