calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Feinauer (Jira)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-3302) Add support for CLASSIFIER() command in MATCH_RECOGNIZE
Date Wed, 28 Aug 2019 08:32:00 GMT
Julian Feinauer created CALCITE-3302:
----------------------------------------

             Summary: 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


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)

Mime
View raw message