Ioannis wants to know if Risingwave can batch rows for UDF calls over a table column without manual aggregation. He has a UDF that can process multiple values with a single call and wants to apply it to a column where each row has a single value. He is concerned about the number of calls made to the server and if Risingwave can optimize this process.
Ioannis Paraskevakos
Asked on Aug 07, 2023
Risingwave does not have a built-in caching behavior for UDF calls, but it does batch the rows for UDF calls over a table column. When you run a query with a UDF on a column, Risingwave will make a single call to the UDF server, which will then process each row individually and return the results in a batch. This batching helps optimize the process by reducing the number of calls made to the server. If the UDF call is heavy, caching on the UDF side can be considered to further optimize performance.
