Dandandan commented on issue #15676: URL: https://github.com/apache/datafusion/issues/15676#issuecomment-2796056565
> If we want a deterministic result, I think we should add ORDER BY. Just like when we want deterministic output with LIMIT, we need to add ORDER BY. Yes, but in that case it would become equivalent to a window function `FIRST_VALUE`, which is clearly defined (and has a sane execution path in DataFusion). [`SELECT FIRST_VALUE(x) OVER (PARTITION BY x ORDER BY )` ](https://datafusion.apache.org/user-guide/sql/window_functions.html#first-value) Sorry for hijacking this issue @andygrove for this discussion but I think it's important to not have features like these limit the progression of DataFusion in the future. -- 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
