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)
