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)