Yuming Wang created SPARK-38489: ----------------------------------- Summary: Aggregate.groupOnly support foldable expressions Key: SPARK-38489 URL: https://issues.apache.org/jira/browse/SPARK-38489 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.3.0 Reporter: Yuming Wang Assignee: Yuming Wang Fix For: 3.3.0
{code:scala} spark.range(200L).selectExpr("id AS a").createTempView("t1") spark.range(300L).selectExpr("id AS b").createTempView("t2") spark.sql("SELECT DISTINCT a AS newAlias FROM t1 LEFT JOIN t2 ON a = b").explain(true) {code} Expected optimized plan: {noformat} == Optimized Logical Plan == Aggregate [newAlias#8L], [newAlias#8L] +- Project [id#0L AS newAlias#8L] +- Range (0, 200, step=1, splits=Some(2)) {noformat} -- 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