| over {SparkR} | R Documentation |
Define a windowing column.
over(x, window) ## S4 method for signature 'Column,WindowSpec' over(x, window)
x |
a Column, usually one returned by window function(s). |
window |
a WindowSpec object. Can be created by |
over since 2.0.0
Other colum_func: alias,
between, cast,
endsWith, otherwise,
startsWith, substr
## Not run:
##D df <- createDataFrame(mtcars)
##D
##D # Partition by am (transmission) and order by hp (horsepower)
##D ws <- orderBy(windowPartitionBy("am"), "hp")
##D
##D # Rank on hp within each partition
##D out <- select(df, over(rank(), ws), df$hp, df$am)
##D
##D # Lag mpg values by 1 row on the partition-and-ordered table
##D out <- select(df, over(lead(df$mpg), ws), df$mpg, df$hp, df$am)
## End(Not run)