[CALCITE-3302] Add support for CLASSIFIER() command in MATCH_RECOGNIZE

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Julian Feinauer
• Reporter: Julian Feinauer
• Created: 28/Aug/19 08:31
• Updated: 06/Mar/20 04:33
• Resolved: 17/Sep/19 21:22

Description

The CLASSIFIER() command simply returns the defined pattern classifier that was matched for the respective column.

A very simple test case which could be added to match.iq is

select *
from "hr"."emps" match_recognize (
    order by "empid" desc
    measures "commission" as c,
    "empid" as empid,
    CLASSIFIER() as cl
    pattern (s up)
    define up as up."commission" < prev(up."commission"));

C    EMPID CL
---- ----- --
1000   100 S
 500   200 UP

!ok

Issue Links

• is related to: CALCITE-1935 Reference implementation for MATCH_RECOGNIZE
• relates to: CALCITE-3341 Implement FINAL modifier functionality
• links to: GitHub Pull Request #1419
• links to: GitHub Pull Request #1449
• links to: PR1419