[ https://issues.apache.org/jira/browse/SPARK-20207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15956374#comment-15956374 ]
Sean Owen commented on SPARK-20207: ----------------------------------- What's the use case? It sounds like something you can do by iterating over partitions. Kind of manual, but, it may also be a niche use case. I don't see it fitting naturally into a window definition, as I don't think any SQL dialect has a vocabulary for that. > Add ablity to exclude current row in WindowSpec > ----------------------------------------------- > > Key: SPARK-20207 > URL: https://issues.apache.org/jira/browse/SPARK-20207 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 2.1.0 > Reporter: Mathew Wicks > Priority: Minor > > It would be useful if we could implement a way to exclude the current row in > WindowSpec. (We can currently only select ranges of rows/time.) > Currently, users have to resort to ridiculous measures to exclude the current > row from windowing aggregations. > As seen here: > http://stackoverflow.com/questions/43180723/spark-sql-excluding-the-current-row-in-partition-by-windowing-functions/43198839#43198839 -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org