Dandandan opened a new issue, #11732: URL: https://github.com/apache/datafusion/issues/11732
### Is your feature request related to a problem or challenge? After https://github.com/apache/datafusion/pull/11721/files we handle nulls in APPROX_PERCENTILE_CONT by removing them before computing the percentile. This is the default behaviour of PostgreSQL, Spark, etc. However the syntax of the current aggregate functions is confusing for `APPROX_PERCENTILE_CONT`, as it supports `IGNORE NULLS | RESPECT NULLS` ### Describe the solution you'd like Come up with a plan to bring the syntax / semantics of `APPROX_PERCENTILE_CONT` and `PERCENTILE_CONT` and similar aggregations closer to PostgreSQL and others by (one or more). * Supporting something like PostgreSQL/Spark/Snowflake syntax: `SELECT percentile_cont(<fraction double precision>) WITHIN GROUP (<sort_expression>)` * Disabling specifying `IGNORE NULLS | RESPECT NULLS` for aggregations functions where they do not make sense / are not supported. * Comparing results against other engines ### Describe alternatives you've considered _No response_ ### Additional context _No response_ -- 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.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
