You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Nicholas Jiang (Jira)" <ji...@apache.org> on 2022/06/29 03:40:00 UTC
[jira] [Updated] (CALCITE-5202) Enhance MATCH_RECOGNIZE functionality
|  |
[Nicholas
Jiang](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=nicholasjiang)
**updated** an issue
---|---
|
---
| [Calcite](https://issues.apache.org/jira/browse/CALCITE) / [](https://issues.apache.org/jira/browse/CALCITE-5202)
[CALCITE-5202](https://issues.apache.org/jira/browse/CALCITE-5202)
---
[Enhance MATCH_RECOGNIZE
functionality](https://issues.apache.org/jira/browse/CALCITE-5202)
| Change By: | [Nicholas
Jiang](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=nicholasjiang)
---|---
| MATCH_RECOGNIZE only supports the output of the matches, doesn't support
the output of the timeout at present. Meanwhile, MATCH_RECOGNIZE doesn't
support the definition of the dynamic window format for WITHIN. WITH TIMEOUT
ROWS and WITHIN INTERVAL intervalExpression are is proposed to support for
MATCH_RECOGNIZE functional enhancement.
The grammar of enhanced MATCH_RECOGNIZE is as follows:
{code:sql}
SELECT [ ALL | DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[MATCH_RECOGNIZE (
[PARTITION BY {partitionItem [, partitionItem]*}]
[ORDER BY {orderItem [, orderItem]*}]
[MEASURES {measureItem AS col [, measureItem AS col]*}]
[ONE ROW PER MATCH|ALL ROWS PER MATCH|ONE ROW PER MATCH WITH TIMEOUT ROWS|ALL
ROWS PER MATCH WITH TIMEOUT ROWS]
[AFTER MATCH SKIP]
PATTERN (patternVariable[quantifier] [ patternVariable[quantifier]]*) WITHIN
intervalExpression
DEFINE {patternVariable AS patternDefinationExpression [, patternVariable AS
patternDefinationExpression]*}
)];
{code}
---
| | [ 
](https://issues.apache.org/jira/browse/CALCITE-5202#add-comment "Add
Comment") | [Add
Comment](https://issues.apache.org/jira/browse/CALCITE-5202#add-comment "Add
Comment")
---|---
| This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9) | |
---