alamb commented on issue #10664: URL: https://github.com/apache/datafusion/issues/10664#issuecomment-2137108974
> In my understanding, window function is a special case of aggregate function, why would these two have different plan struct? I think window funtions and aggregate functions are different. Somewhat confusingly is that you can use aggregate functions as window functions Window functions always have an `OVER` clause. So for example, this is a normal aggregate ```sql select count(x) from foo; ``` However, this is count being used as a window aggregate: ```sql select count(x) OVER (PARTITION BY y) from foo; ``` -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
