[CALCITE-2707] Information about distinct aggregation is lost in MATCH_RECOGNIZE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: match pull-request-available
• Assignee: Danny Chen
• Reporter: Dawid Wysakowicz
• Created: 26/Nov/18 15:20
• Updated: 06/Mar/20 04:34
• Resolved: 19/Feb/20 03:06

Description

There is no information that the COUNT aggregation is distinct in a plan for a query like e.g. this:

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

Issue Links

• links to: GitHub Pull Request #1816