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