[jira] [Created] (CALCITE-5202) Enhance MATCH_RECOGNIZE functionality

[Nicholas Jiang (Jira)]

Title: Message Title

Nicholas Jiang created an issue   Calcite / CALCITE-5202 Enhance MATCH_RECOGNIZE functionality Issue Type: New Feature Assignee: Unassigned Created: 29/Jun/22 02:51 Priority: Major Reporter: Nicholas Jiang 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 proposed to support for MATCH_RECOGNIZE functional enhancement. The grammar of enhanced MATCH_RECOGNIZE is as follows: 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]*} )]; Add Comment   This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)