[jira] [Commented] (SPARK-28500) adds support for `filter` clause
[ https://issues.apache.org/jira/browse/SPARK-28500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16891930#comment-16891930 ] Yuming Wang commented on SPARK-28500: - ok. thank you. > 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
[jira] [Commented] (SPARK-28500) adds support for `filter` clause
[ https://issues.apache.org/jira/browse/SPARK-28500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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
[jira] [Commented] (SPARK-28500) adds support for `filter` clause
[ https://issues.apache.org/jira/browse/SPARK-28500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16891832#comment-16891832 ] Yuming Wang commented on SPARK-28500: - Duplicate with SPARK-27986? > 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