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)