osdir.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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)