[
https://issues.apache.org/jira/browse/CALCITE-5202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nicholas Jiang updated CALCITE-5202:
------------------------------------
Summary: Support for MATCH_RECOGNIZE functionality enhancement (was:
Support MATCH_RECOGNIZE timeout output)
> Support for MATCH_RECOGNIZE functionality enhancement
> -----------------------------------------------------
>
> Key: CALCITE-5202
> URL: https://issues.apache.org/jira/browse/CALCITE-5202
> Project: Calcite
> Issue Type: New Feature
> Reporter: Nicholas Jiang
> Priority: Major
>
> MATCH_RECOGNIZE only supports the output of matches, doesn't support the
> output of timeout at present. WITH TIMEOUT ROWS 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}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
