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

Reply via email to