[
https://issues.apache.org/jira/browse/CALCITE-3302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Feinauer updated CALCITE-3302:
-------------------------------------
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
{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}
was:
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}
> 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
>
> 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)
