[ 
https://issues.apache.org/jira/browse/CALCITE-3302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde resolved CALCITE-3302.
----------------------------------
    Fix Version/s: 1.22.0
       Resolution: Fixed

Fixed in 
[f4dde669|https://github.com/apache/calcite/commit/f4dde669631f7fa4f64b42eb1481ba9a8f27bd39].
 Thanks, [~julian.feinauer]!

> 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
>             Fix For: 1.22.0
>
>          Time Spent: 3h 20m
>  Remaining Estimate: 0h
>
> 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)

Reply via email to