<F> WindowSDFrame<T> |
WindowSDFrame.overAvgS(SetFunction<T,BigDecimal> setFunction,
java.util.function.Function<T,F> field) |
avg window function
calculate the avg value within the window range
|
WindowSDFrame<T> |
WindowSDFrame.overCountS(SetFunction<T,Integer> setFunction) |
count window function
calculate the count within the window range
|
WindowSDFrame<T> |
WindowSDFrame.overCumeDistS(SetFunction<T,BigDecimal> setFunction) |
Cume Dist window function
set the function result to the setFunction
|
WindowSDFrame<T> |
WindowSDFrame.overDenseRankS(SetFunction<T,Integer> setFunction) |
dense rank window function
set the function result to the setFunction
|
<F> WindowSDFrame<T> |
WindowSDFrame.overFirstValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
FirstValue window function
get the first row within the window range
|
<F> WindowSDFrame<T> |
WindowSDFrame.overLagS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
Lag window function
get the value of the first n rows of the current row
|
<F> WindowSDFrame<T> |
WindowSDFrame.overLastValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
LastValue window function
get the last row within the window range
|
<F> WindowSDFrame<T> |
WindowSDFrame.overLeadS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
lead window function
get the value of the last n rows of the current row
|
<F> WindowSDFrame<T> |
WindowSDFrameImpl.overLeadS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
|
<F extends Comparable<? super F>> WindowSDFrame<T> |
WindowSDFrame.overMaxValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
max window function
calculate the max value within the window range
|
<F extends Comparable<? super F>> WindowSDFrame<T> |
WindowSDFrame.overMinValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
min window function
calculate the min value within the window range
|
<F> WindowSDFrame<T> |
WindowSDFrame.overNthValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
NthValue window function
get the Nth row within the window range
|
WindowSDFrame<T> |
WindowSDFrame.overNtileS(SetFunction<T,Integer> setFunction,
int n) |
Ntile window function
assign bucket numbers evenly to windows, starting from 1
|
WindowSDFrame<T> |
WindowSDFrame.overPercentRankS(SetFunction<T,BigDecimal> setFunction) |
Percent rank window function
set the function result to the setFunction
|
WindowSDFrame<T> |
WindowSDFrame.overRankS(SetFunction<T,Integer> setFunction) |
rank window function
set the function result to the setFunction
|
WindowSDFrame<T> |
WindowSDFrame.overRowNumberS(SetFunction<T,Integer> setFunction) |
rowNumber window function
set the function result to the setFunction
|
<F> WindowSDFrame<T> |
WindowSDFrame.overSumS(SetFunction<T,BigDecimal> setFunction,
java.util.function.Function<T,F> field) |
sum window function
calculate the sum value within the window range
|
WindowSDFrame<T> |
SDFrame.window() |
open a empty window
|
WindowSDFrame<T> |
SDFrame.window(Window<T> window) |
open a window
|
WindowSDFrame<T> |
SDFrameImpl.window() |
|
WindowSDFrame<T> |
SDFrameImpl.window(Window<T> window) |
|