[
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)
