[
https://issues.apache.org/jira/browse/CALCITE-3302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-3302:
------------------------------------
Labels: pull-request-available (was: )
> Add support for CLASSIFIER() command in MATCH_RECOGNIZE
> -------------------------------------------------------
>
> Key: CALCITE-3302
> URL: https://issues.apache.org/jira/browse/CALCITE-3302
> Project: Calcite
> Issue Type: Improvement
> Reporter: Julian Feinauer
> Assignee: Julian Feinauer
> Priority: Major
> Labels: pull-request-available
>
> 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
> {code:java}
> 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
> {code}
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
