You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Dawid Wysakowicz (JIRA)" <ji...@apache.org> on 2018/11/26 15:21:00 UTC

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

Dawid Wysakowicz created CALCITE-2707:
-----------------------------------------

             Summary: 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: Julian Hyde


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
(v7.6.3#76005)