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
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
Hello!
My use case is sessionizing raw events without an aggregation function.
Approximate code that I tried out:
SELECT ARRAY_AGG(ROW(...))
FROM ...
GROUP BY SESSION(...)
(followed by UNNEST to get the raw events, tagged with session info, back
out into a stream)
I get a parser error on the