Hi Timo,
Can you please elaborate a bit on what you mean? I am not sure that I
completely understand.
Thank you.
Sincerely,
Marco A. Villalobos
On Tue, Jan 5, 2021 at 6:58 AM Timo Walther wrote:
> A subquery could work but since you want to implement a UDTAGG anyway,
> you can also move the
A subquery could work but since you want to implement a UDTAGG anyway,
you can also move the implementation there and keep the SQL query
simple. But this is up to you. Consecutive windows are supported.
Regards,
Timo
On 05.01.21 15:23, Marco Villalobos wrote:
Hi Timo,
Thank you for the quic
Hi Timo,
Thank you for the quick response.
Neither COLLECT nor LISTAGG work because they only accept one column.
I am trying to collect all the rows and columns into one object. Like a
List for example.
Later, I need make calculations upon all the rows that were just collected
within a window.
Hi Marco,
nesting aggregated functions is not allowed in SQL. The exception could
be improved though. I guess the planner searches for a scalar function
called `MyUDTAGG` in your example and cannot find one.
Maybe the built-in function `COLLECT` or `LISTAGG`is what you are
looking for?
htt
