zml1206 opened a new issue, #10605: URL: https://github.com/apache/incubator-gluten/issues/10605
### Description For unbounded window, velox needs to load the entire partition's data into memory for calculation, which can easily cause OOM when the partition is too large. This rule rewrites unbounded window to an equivalent aggregate join operation to avoid OOM. Input query: ``` SELECT *, SUM(c0) OVER (PARTITION BY c1) AS sum FROM t ``` Rewritten query: ``` SELECT t.*, t1.sum FROM t LEFT JOIN (SELECT c1, SUM(c0) AS sum FROM t GROUP BY c1) t1 ON t. c1 <=> t1.c1 ``` ### Gluten version None -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
