qazxcdswe123 commented on issue #14586: URL: https://github.com/apache/datafusion/issues/14586#issuecomment-2708702633
> Queries like `avg(distinct a)` rely on this rule, and without it, they cannot be executed anymore. > > The following query is available on the main branch, but not on this PR branch. > > ```shell > DataFusion CLI v46.0.0 > > select avg(distinct a) from values(1) t(a); > Execution error: avg(DISTINCT) aggregations are not available > ``` https://github.com/apache/datafusion/pull/15099#discussion_r1986094870 I didn't ran the full test at that time, but `single_distinct_to_groupby` is used somewhere else and after some more investigation I think it's more easier to keep it 😅 -- 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]
