[ https://issues.apache.org/jira/browse/SPARK-28500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16891833#comment-16891833 ]
Dylan Guedes commented on SPARK-28500: -------------------------------------- Hmm you are correct, there's some overlapping there. However, at some point the JIRA will be fragmented into smaller ones, like one for filter, other for distinct, right? > adds support for `filter` clause > -------------------------------- > > Key: SPARK-28500 > URL: https://issues.apache.org/jira/browse/SPARK-28500 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Dylan Guedes > Priority: Major > > Definition: "The {{filter}} clause extends aggregate functions ({{sum}}, > {{avg}}, {{count}}, …) by an additional {{where}} clause. The result of the > aggregate is built from only the rows that satisfy the additional {{where}} > clause too." [source|[https://modern-sql.com/feature/filter]] > Also, PgSQL currently support `filter` while Spark doesn't. -- This message was sent by Atlassian JIRA (v7.6.14#76016) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org