I don’t understand MATCH_RECOGNIZE well enough to give an opinion. Is there a
query that gives different results on Oracle if you change the order of items
in SUBSET?
It seems that the parser preserves the order of items in the subset, but the
SqlToRelConverter does not, hence the line
Super! I was not aware of COLLECT. That sounds like an even better fit.
Great timing on the release, for my sake :-)
Kenn
On Sat, Dec 15, 2018, 13:51 Julian Hyde As of https://issues.apache.org/jira/browse/CALCITE-2224 (to be
> released shortly in 1.18) Calcite supports the WITHIN GROUP clause
The Apache Jenkins build system has built Calcite-Master (build #986)
Status: Still Failing
Check console output at https://builds.apache.org/job/Calcite-Master/986/ to
view the results.
Jacques Nadeau created CALCITE-2742:
---
Summary: Update RexImpTable to user DataContext to retrieve USER
and SYSTEM_USER
Key: CALCITE-2742
URL: https://issues.apache.org/jira/browse/CALCITE-2742
As of https://issues.apache.org/jira/browse/CALCITE-2224 (to be
released shortly in 1.18) Calcite supports the WITHIN GROUP clause
(that allows you to specify the order in which values are supplied to
an aggregate function) and the COLLECT aggregate function (similar to
ARRAY_AGG but returns a