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 02:52:00 UTC
[jira] [Created] (CALCITE-5202) Enhance MATCH_RECOGNIZE functionality

|  ![](cid:jira-generated-image-avatar-22b7b708-8aa6-4948-9ce6-4be9289e7ff7) |
[Nicholas
Jiang](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=nicholasjiang)
**created** an issue  
---|---  
|  
---  
|  [Calcite](https://issues.apache.org/jira/browse/CALCITE) / [![New
Feature](cid:jira-generated-image-avatar-
ef7bc815-eaba-4d6d-8bb8-41565ef77180)](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)  
| Issue Type: |  ![New Feature](cid:jira-generated-image-avatar-
ef7bc815-eaba-4d6d-8bb8-41565ef77180) New Feature  
---|---  
Assignee: |  Unassigned  
Created: |  29/Jun/22 02:51  
Priority: |  ![Major](cid:jira-generated-image-static-
major-c4f7009c-a07a-4749-84c9-e335dd0b062f) Major  
Reporter: |  [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 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](cid:jira-generated-image-static-comment-
icon-8efdd9f0-f55e-42cf-98ae-64c191b5da68)
](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) |  |
![Atlassian logo](https://issues.apache.org/jira/images/mail/atlassian-email-
logo.png)  
---