[ https://issues.apache.org/jira/browse/SPARK-32540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jiaan.geng updated SPARK-32540: ------------------------------- Summary: Eliminate filter clause in aggregate (was: Eliminate distinct that with filter clause) > Eliminate filter clause in aggregate > ------------------------------------ > > Key: SPARK-32540 > URL: https://issues.apache.org/jira/browse/SPARK-32540 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.1.0 > Reporter: jiaan.geng > Priority: Major > > SQL like: > {code:java} > SELECT COUNT(DISTINCT 1) FILTER (WHERE true) FROM testData; > {code} > Could converted to > {code:java} > SELECT COUNT(DISTINCT 1) FROM testData; > {code} -- 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