[ https://issues.apache.org/jira/browse/SPARK-30396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jiaan.geng updated SPARK-30396: ------------------------------- Description: This ticket is related to https://issues.apache.org/jira/browse/SPARK-27986 This ticket will support: When there are multiple DISTINCT aggregate expressions acting on different fields, any DISTINCT aggregate expression allows the use of the FILTER clause such as: select class_id, count(distinct sex), sum(distinct id) filter (where sex = 'man') from student group by class_id; select class_id, count(distinct sex) filter (where class_id = 1), sum(distinct id) filter (where sex = 'man') from student group by class_id; was: This ticket is related to https://issues.apache.org/jira/browse/SPARK-27986 This ticket will support: When there are multiple DISTINCT aggregate expressions acting on different fields, any DISTINCT aggregate expression allows the use of the FILTER clause > When there are multiple DISTINCT aggregate expressions acting on different > fields, any DISTINCT aggregate expression allows the use of the FILTER clause > -------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: SPARK-30396 > URL: https://issues.apache.org/jira/browse/SPARK-30396 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: jiaan.geng > Priority: Major > > This ticket is related to https://issues.apache.org/jira/browse/SPARK-27986 > This ticket will support: > When there are multiple DISTINCT aggregate expressions acting on different > fields, any DISTINCT aggregate expression allows the use of the FILTER clause > such as: > select class_id, count(distinct sex), sum(distinct id) filter (where sex = > 'man') from student group by class_id; > select class_id, count(distinct sex) filter (where class_id = 1), > sum(distinct id) filter (where sex = 'man') from student group by class_id; -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org