[ https://issues.apache.org/jira/browse/SPARK-38832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17519548#comment-17519548 ]
Apache Spark commented on SPARK-38832: -------------------------------------- User 'ulysses-you' has created a pull request for this issue: https://github.com/apache/spark/pull/36117 > Remove unnecessary distinct in aggregate expression by distinctKeys > ------------------------------------------------------------------- > > Key: SPARK-38832 > URL: https://issues.apache.org/jira/browse/SPARK-38832 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.4.0 > Reporter: XiDuo You > Priority: Major > > We can remove the distinct in aggregate expression if the child distinct > semantics is guaranteed. > For example: > {code:java} > SELECT count(distinct c) FROM ( > SELECT c FROM t GROUP BY c > ){code} > > > -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org