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 Chan (Jira)" <ji...@apache.org> on 2019/09/18 08:08:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16932181#comment-16932181 ]
Danny Chan commented on CALCITE-2707:
-------------------------------------
When can we fix this issue, there is a copy file of Calcite SqlValidatorImpl in flink-table-planner, and there is no change to patch other Calcite bug fix in the validator, we should solve this issue as soon as possible and remove the fileĀ SqlValidatorImpl.java.
> 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
> Priority: Major
> Labels: match
>
> 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)