Snowshoe logo
all-things-risingwave

Is it possible to use UDF for aggregate functions with all records from a group in RisingWave?

I am interested in using UDF for aggregate functions with all records from a group in RisingWave. How can I achieve this?

Ch

Charlie

Asked on Oct 04, 2023

  • Currently, stateful UDFs for aggregate functions are not supported in RisingWave.
  • There is ongoing work to support UDFs for aggregate functions, and it is expected to be available within this year.
  • As a workaround, you can first use array_agg to aggregate the group data into an array, then call the UDF on the array. This approach should work as long as the group is not too large.
Oct 16, 2023Edited by