[ https://issues.apache.org/jira/browse/CALCITE-1645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-1645. ---------------------------------- Resolution: Fixed Fix Version/s: 1.13.0 > Row per match syntax support for MATCH_RECOGNIZE > ------------------------------------------------- > > Key: CALCITE-1645 > URL: https://issues.apache.org/jira/browse/CALCITE-1645 > Project: Calcite > Issue Type: Sub-task > Components: core > Affects Versions: 1.11.0 > Reporter: Zhiqiang He > Assignee: Zhiqiang He > Labels: features > Fix For: 1.13.0 > > > h1. [ONE ROW | ALL ROWS] PER MATCH: Choosing Summaries or Details for Each > Match > You will sometimes want summary data about the matches and other times need > details. You can do that with the following SQL: > * ONE ROW PER MATCH > Each match produces one summary row. This is the default. > * ALL ROWS PER MATCH > A match spanning multiple rows will produce one output row for each row in > the match. > The output is explained in "Row Pattern Output". > The MATCH_RECOGNIZE clause may find a match with zero rows. For an empty > match, ONE ROW PER MATCH returns a summary row: the PARTITION BY columns take > the values from the row where the empty match occurs, and the measure columns > are evaluated over an empty set of rows. > ALL ROWS PER MATCH has three suboptions: > * ALL ROWS PER MATCH SHOW EMPTY MATCHES > * ALL ROWS PER MATCH OMIT EMPTY MATCHES > * ALL ROWS PER MATCH WITH UNMATCHED ROWS -- This message was sent by Atlassian JIRA (v6.3.15#6346)