[jira] [Resolved] (CALCITE-1645) Row per match syntax support for MATCH_RECOGNIZE

["Julian Hyde (JIRA)" <ji...@apache.org>]

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