-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.22.0
-
Component/s: None
-
Labels:
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
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
- is related to
-
CALCITE-1935 Reference implementation for MATCH_RECOGNIZE
-
- Closed
-
- relates to
-
CALCITE-3341 Implement FINAL modifier functionality
-
- Open
-
- links to