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

[Nicholas Jiang (Jira)]

Title: Message Title

Nicholas Jiang updated an issue   Calcite / CALCITE-5202 Enhance MATCH_RECOGNIZE functionality Change By: 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 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} Add Comment   This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)