beliefer opened a new pull request, #43661: URL: https://github.com/apache/spark/pull/43661
### What changes were proposed in this pull request? This PR will translate `MODE` for pushdown. `MODE` constructor has a `deterministic` parameter. When multiple values have the same greatest frequency then either any of values is returned if `deterministic` is false or is not defined, or the lowest value is returned if `deterministic` is true. The semantics is the same the other databases (e.g. H2, Postgres) if `deterministic` true. The standard syntax is: `MODE() WITHIN GROUP (ORDER BY col)`. ### Why are the changes needed? DS V2 supports push down Mode ### Does this PR introduce _any_ user-facing change? 'No'. New feature. ### How was this patch tested? New test cases. ### Was this patch authored or co-authored using generative AI tooling? 'No'. -- 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]
