Wan Kun created SPARK-40164: ------------------------------- Summary: The partitionSpec should be distinct keys after filter one row of row_number Key: SPARK-40164 URL: https://issues.apache.org/jira/browse/SPARK-40164 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.3.0 Reporter: Wan Kun
For query {code:sql} SELECT * FROM ( SELECT *, row_number() over(partition by key order by value) rn FROM testData t ) t1 WHERE rn=1 {code} column *key* will be distinct -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org