程序包 io.github.burukeyou.dataframe.iframe

接口 WindowSDFrame<T>

类型参数:

T -

所有超级接口:

IFrame<T>, Iterable<T>, SDFrame<T>

所有已知实现类:

WindowSDFrameImpl

public interface WindowSDFrame<T>
extends SDFrame<T>

作者:

caizhihao

方法概要

修饰符和类型	方法	说明
<F> SDFrame<FI2<T,BigDecimal>>	overAvg(java.util.function.Function<T,F> field)	avg window function calculate the avg value within the window range
<F> WindowSDFrame<T>	overAvgS(SetFunction<T,BigDecimal> setFunction, java.util.function.Function<T,F> field)	avg window function calculate the avg value within the window range
SDFrame<FI2<T,Integer>>	overCount()	count window function calculate the count within the window range
WindowSDFrame<T>	overCountS(SetFunction<T,Integer> setFunction)	count window function calculate the count within the window range
SDFrame<FI2<T,BigDecimal>>	overCumeDist()	Cume Dist window function set the function result to the setFunction
WindowSDFrame<T>	overCumeDistS(SetFunction<T,BigDecimal> setFunction)	Cume Dist window function set the function result to the setFunction
SDFrame<FI2<T,Integer>>	overDenseRank()	dense rank window function set the function result to the setFunction
WindowSDFrame<T>	overDenseRankS(SetFunction<T,Integer> setFunction)	dense rank window function set the function result to the setFunction
<F> SDFrame<FI2<T,F>>	overFirstValue(java.util.function.Function<T,F> field)	FirstValue window function get the first row within the window range
<F> WindowSDFrame<T>	overFirstValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	FirstValue window function get the first row within the window range
<F> SDFrame<FI2<T,F>>	overLag(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>	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> SDFrame<FI2<T,F>>	overLastValue(java.util.function.Function<T,F> field)	LastValue window function get the last row within the window range
<F> WindowSDFrame<T>	overLastValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	LastValue window function get the last row within the window range
<F> SDFrame<FI2<T,F>>	overLead(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>	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 extends Comparable<? super F>> SDFrame<FI2<T,F>>	overMaxValue(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>	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>> SDFrame<FI2<T,F>>	overMinValue(java.util.function.Function<T,F> field)	min window function calculate the min value within the window range
<F extends Comparable<? super F>> WindowSDFrame<T>	overMinValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	min window function calculate the min value within the window range
<F> SDFrame<FI2<T,F>>	overNthValue(java.util.function.Function<T,F> field, int n)	NthValue window function get the Nth row within the window range
<F> WindowSDFrame<T>	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
SDFrame<FI2<T,Integer>>	overNtile(int n)	Ntile window function assign bucket numbers evenly to windows, starting from 1
WindowSDFrame<T>	overNtileS(SetFunction<T,Integer> setFunction, int n)	Ntile window function assign bucket numbers evenly to windows, starting from 1
SDFrame<FI2<T,BigDecimal>>	overPercentRank()	Percent rank window function set the function result to the setFunction
WindowSDFrame<T>	overPercentRankS(SetFunction<T,BigDecimal> setFunction)	Percent rank window function set the function result to the setFunction
SDFrame<FI2<T,Integer>>	overRank()	rank window function
WindowSDFrame<T>	overRankS(SetFunction<T,Integer> setFunction)	rank window function set the function result to the setFunction
SDFrame<FI2<T,Integer>>	overRowNumber()	rowNumber window function
WindowSDFrame<T>	overRowNumberS(SetFunction<T,Integer> setFunction)	rowNumber window function set the function result to the setFunction
<F> SDFrame<FI2<T,BigDecimal>>	overSum(java.util.function.Function<T,F> field)	sum window function calculate the sum value within the window range
<F> WindowSDFrame<T>	overSumS(SetFunction<T,BigDecimal> setFunction, java.util.function.Function<T,F> field)	sum window function calculate the sum value within the window range

从接口继承的方法 io.github.burukeyou.dataframe.iframe.IFrame

page, stream, subList, toLists

从接口继承的方法 java.lang.Iterable

forEach, iterator, spliterator

从接口继承的方法 io.github.burukeyou.dataframe.iframe.SDFrame

addRankCol, addRankCol, addRowNumberCol, addRowNumberCol, addRowNumberCol, addRowNumberCol, append, avg, col, columns, count, countDistinct, countDistinct, cut, cutFirst, cutFirstRank, cutLast, cutPage, defaultScale, defaultScale, distinct, distinct, distinct, forEachDo, from, group, groupByAvg, groupByAvg, groupByAvg, groupByCount, groupByCount, groupByCount, groupByMax, groupByMax, groupByMaxMin, groupByMaxMin, groupByMaxMinValue, groupByMaxMinValue, groupByMaxValue, groupByMaxValue, groupByMin, groupByMin, groupByMinValue, groupByMinValue, groupBySum, groupBySum, groupBySum, groupBySumCount, groupBySumCount, head, head, join, join, leftJoin, leftJoin, map, mapPercent, mapPercent, max, maxMin, maxMinValue, maxValue, min, minValue, overAvg, overAvgS, overCount, overCountS, overCumeDist, overCumeDistS, overDenseRank, overDenseRankS, overFirstValue, overFirstValueS, overLag, overLagS, overLastValue, overLastValueS, overLead, overLeadS, overMaxValue, overMaxValueS, overMinValue, overMinValueS, overNthValue, overNthValueS, overNtile, overNtileS, overPercentRank, overPercentRankS, overRank, overRankS, overRowNumber, overRowNumberS, overSum, overSumS, partition, replenish, replenish, replenish, rightJoin, rightJoin, show, show, sortAsc, sortAsc, sortDesc, sortDesc, sum, tail, tail, union, where, whereBetween, whereBetweenL, whereBetweenN, whereBetweenR, whereEq, whereGe, whereGt, whereIn, whereLe, whereLike, whereLikeLeft, whereLikeRight, whereLt, whereNotBetween, whereNotBetweenN, whereNotEq, whereNotIn, whereNotLike, whereNotNull, whereNotTrue, whereNull, whereTrue, window, window

方法详细资料

overRowNumber

SDFrame<FI2<T,Integer>> overRowNumber()

rowNumber window function

指定者:

overRowNumber 在接口中 SDFrame<T>

overRowNumberS

WindowSDFrame<T> overRowNumberS(SetFunction<T,Integer> setFunction)

rowNumber window function set the function result to the setFunction

指定者:

overRowNumberS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

overRank

SDFrame<FI2<T,Integer>> overRank()

rank window function

overRankS

WindowSDFrame<T> overRankS(SetFunction<T,Integer> setFunction)

rank window function set the function result to the setFunction

参数:

setFunction - function result accept

overDenseRank

SDFrame<FI2<T,Integer>> overDenseRank()

dense rank window function set the function result to the setFunction

overDenseRankS

WindowSDFrame<T> overDenseRankS(SetFunction<T,Integer> setFunction)

dense rank window function set the function result to the setFunction

参数:

setFunction - function result accept

overPercentRank

SDFrame<FI2<T,BigDecimal>> overPercentRank()

Percent rank window function set the function result to the setFunction

overPercentRankS

WindowSDFrame<T> overPercentRankS(SetFunction<T,BigDecimal> setFunction)

Percent rank window function set the function result to the setFunction

参数:

setFunction - function result accept

overCumeDist

SDFrame<FI2<T,BigDecimal>> overCumeDist()

Cume Dist window function set the function result to the setFunction

overCumeDistS

WindowSDFrame<T> overCumeDistS(SetFunction<T,BigDecimal> setFunction)

Cume Dist window function set the function result to the setFunction

参数:

setFunction - function result accept

overLag

<F> SDFrame<FI2<T,F>> overLag(java.util.function.Function<T,F> field,
                                    int n)

Lag window function get the value of the first n rows of the current row

指定者:

overLag 在接口中 SDFrame<T>

参数:

field - field value

n - first n rows

overLagS

<F> WindowSDFrame<T> 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

指定者:

overLagS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

n - first n rows

overLead

<F> SDFrame<FI2<T,F>> overLead(java.util.function.Function<T,F> field,
                                     int n)

lead window function get the value of the last n rows of the current row

指定者:

overLead 在接口中 SDFrame<T>

参数:

field - field value

n - last n rows

overLeadS

<F> WindowSDFrame<T> 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

指定者:

overLeadS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

n - last n rows

overNthValue

<F> SDFrame<FI2<T,F>> overNthValue(java.util.function.Function<T,F> field,
                                         int n)

NthValue window function get the Nth row within the window range

指定者:

overNthValue 在接口中 SDFrame<T>

参数:

field - field value

n - last n rows

overNthValueS

<F> WindowSDFrame<T> 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

指定者:

overNthValueS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

n - last n rows

overFirstValue

<F> SDFrame<FI2<T,F>> overFirstValue(java.util.function.Function<T,F> field)

FirstValue window function get the first row within the window range

指定者:

overFirstValue 在接口中 SDFrame<T>

参数:

field - field value

overFirstValueS

<F> WindowSDFrame<T> overFirstValueS(SetFunction<T,F> setFunction,
                                     java.util.function.Function<T,F> field)

FirstValue window function get the first row within the window range

指定者:

overFirstValueS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

overLastValue

<F> SDFrame<FI2<T,F>> overLastValue(java.util.function.Function<T,F> field)

LastValue window function get the last row within the window range

指定者:

overLastValue 在接口中 SDFrame<T>

参数:

field - field value

overLastValueS

<F> WindowSDFrame<T> overLastValueS(SetFunction<T,F> setFunction,
                                    java.util.function.Function<T,F> field)

LastValue window function get the last row within the window range

指定者:

overLastValueS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

overSum

<F> SDFrame<FI2<T,BigDecimal>> overSum(java.util.function.Function<T,F> field)

sum window function calculate the sum value within the window range

指定者:

overSum 在接口中 SDFrame<T>

参数:

field - field value

overSumS

<F> WindowSDFrame<T> overSumS(SetFunction<T,BigDecimal> setFunction,
                              java.util.function.Function<T,F> field)

sum window function calculate the sum value within the window range

指定者:

overSumS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

overAvg

<F> SDFrame<FI2<T,BigDecimal>> overAvg(java.util.function.Function<T,F> field)

avg window function calculate the avg value within the window range

指定者:

overAvg 在接口中 SDFrame<T>

参数:

field - field value

overAvgS

<F> WindowSDFrame<T> overAvgS(SetFunction<T,BigDecimal> setFunction,
                              java.util.function.Function<T,F> field)

avg window function calculate the avg value within the window range

指定者:

overAvgS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

overMaxValue

<F extends Comparable<? super F>> SDFrame<FI2<T,F>> overMaxValue(java.util.function.Function<T,F> field)

max window function calculate the max value within the window range

指定者:

overMaxValue 在接口中 SDFrame<T>

参数:

field - field value

overMaxValueS

<F extends Comparable<? super F>> WindowSDFrame<T> overMaxValueS(SetFunction<T,F> setFunction,
                                                                 java.util.function.Function<T,F> field)

max window function calculate the max value within the window range

指定者:

overMaxValueS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

overMinValue

<F extends Comparable<? super F>> SDFrame<FI2<T,F>> overMinValue(java.util.function.Function<T,F> field)

min window function calculate the min value within the window range

指定者:

overMinValue 在接口中 SDFrame<T>

参数:

field - field value

overMinValueS

<F extends Comparable<? super F>> WindowSDFrame<T> overMinValueS(SetFunction<T,F> setFunction,
                                                                 java.util.function.Function<T,F> field)

min window function calculate the min value within the window range

指定者:

overMinValueS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

field - field value

overCount

SDFrame<FI2<T,Integer>> overCount()

count window function calculate the count within the window range

指定者:

overCount 在接口中 SDFrame<T>

overCountS

WindowSDFrame<T> overCountS(SetFunction<T,Integer> setFunction)

count window function calculate the count within the window range

指定者:

overCountS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

overNtile

SDFrame<FI2<T,Integer>> overNtile(int n)

Ntile window function assign bucket numbers evenly to windows, starting from 1

指定者:

overNtile 在接口中 SDFrame<T>

参数:

n - size of buckets

overNtileS

WindowSDFrame<T> overNtileS(SetFunction<T,Integer> setFunction,
                            int n)

Ntile window function assign bucket numbers evenly to windows, starting from 1

指定者:

overNtileS 在接口中 SDFrame<T>

参数:

setFunction - function result accept

n - size of buckets