Interface UpdateByOperation
- All Known Implementing Classes:
ColumnUpdateOperation
-
Nested Class Summary
Nested Classes -
Method Summary
Modifier and TypeMethodDescriptionstatic UpdateByOperationCumCountWhere(String resultColumn, Filter filter) Create acumulative count wherethat counts the number of rows that pass the provided filter.static UpdateByOperationCumCountWhere(String resultColumn, String... filters) Create acumulative count wherethat counts the number of rows that pass the provided filters.static UpdateByOperationCreate acumulative maximumfor the supplied column name pairs.static UpdateByOperationCreate acumulative minimumfor the supplied column name pairs.static UpdateByOperationCreate acumulative productfor the supplied column name pairs.static UpdateByOperationCreate acumulative sumfor the supplied column name pairs.static UpdateByOperationDelta(DeltaControl control, String... pairs) Create adeltafor the supplied column name pairs.static UpdateByOperationCreate adeltafor the supplied column name pairs.static UpdateByOperationCreate anexponential moving averagefor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEma(OperationControl control, double tickDecay, String... pairs) Create anexponential moving averagefor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEma(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving averagefor the supplied column name pairs, using time as the decay unit.static UpdateByOperationEma(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving averagefor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving averagefor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving averagefor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving maximumfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEmMax(OperationControl control, double tickDecay, String... pairs) Create anexponential moving maximumfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEmMax(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving maximumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationEmMax(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving maximumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving maximumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving maximumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving minimumfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEmMin(OperationControl control, double tickDecay, String... pairs) Create anexponential moving minimumfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEmMin(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving minimumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationEmMin(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving minimumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving minimumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving minimumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving sumfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEms(OperationControl control, double tickDecay, String... pairs) Create anexponential moving sumfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEms(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving sumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationEms(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving sumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving sumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving sumfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving standard deviationfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEmStd(OperationControl control, double tickDecay, String... pairs) Create anexponential moving standard deviationfor the supplied column name pairs, using ticks as the decay unit.static UpdateByOperationEmStd(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationEmStd(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit.static UpdateByOperationCreate aforward fillfor the supplied column name pairs.static ColumnUpdateOperationof(UpdateBySpec spec, Pair... columns) Conjoin anUpdateBySpecwith columns for it to be applied to so the engine can construct the proper operators.static ColumnUpdateOperationof(UpdateBySpec spec, String... columns) Conjoin anUpdateBySpecwith columns for it to be applied to so the engine can construct the proper operators.static UpdateByOperationRollingAvg(long revTicks, long fwdTicks, String... pairs) Create arolling averagefor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingAvg(long revTicks, String... pairs) Create arolling averagefor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingAvg(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingAvg(String timestampCol, long revTime, String... pairs) Create arolling averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingAvg(String timestampCol, Duration revDuration, String... pairs) Create arolling averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingAvg(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingCount(long revTicks, long fwdTicks, String... pairs) Create arolling countfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingCount(long revTicks, String... pairs) Create arolling countfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingCount(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling countfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingCount(String timestampCol, long revTime, String... pairs) Create arolling countfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingCount(String timestampCol, Duration revDuration, String... pairs) Create arolling countfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingCount(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling countfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingCountWhere(long revTicks, long fwdTicks, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using ticks as the windowing unit.static UpdateByOperationRollingCountWhere(long revTicks, long fwdTicks, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using ticks as the windowing unit.static UpdateByOperationRollingCountWhere(long revTicks, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using ticks as the windowing unit.static UpdateByOperationRollingCountWhere(long revTicks, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using ticks as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, long revTime, long fwdTime, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, long revTime, long fwdTime, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, long revTime, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, long revTime, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, Duration revDuration, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, Duration revDuration, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, Duration revDuration, Duration fwdDuration, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit.static UpdateByOperationRollingCountWhere(String timestampCol, Duration revDuration, Duration fwdDuration, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit.static UpdateByOperationRollingFormula(long revTicks, long fwdTicks, String formula) Create arolling formulausing ticks as the windowing unit.static UpdateByOperationRollingFormula(long revTicks, long fwdTicks, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingFormula(long revTicks, String formula) Create arolling formulausing ticks as the windowing unit.static UpdateByOperationRollingFormula(long revTicks, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, long revTime, long fwdTime, String formula) Create arolling formulausing time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, long revTime, long fwdTime, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, long revTime, String formula) Create arolling formulausing time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, long revTime, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, Duration revDuration, String formula) Create arolling formulausing time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, Duration revDuration, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, Duration revDuration, Duration fwdDuration, String formula) Create arolling formulausing time as the windowing unit.static UpdateByOperationRollingFormula(String timestampCol, Duration revDuration, Duration fwdDuration, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingGroup(long prevTimeTicks, long fwdTimeTicks, String... pairs) Createrolling groupsfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingGroup(long prevTimeTicks, String... pairs) Createrolling groupsfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingGroup(String timestampCol, long prevWindowNanos, long fwdWindowNanos, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingGroup(String timestampCol, long prevWindowNanos, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingGroup(String timestampCol, Duration prevWindowDuration, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingGroup(String timestampCol, Duration prevWindowDuration, Duration fwdWindowDuration, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMax(long revTicks, long fwdTicks, String... pairs) Create arolling maximumfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingMax(long revTicks, String... pairs) Create arolling maximumfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingMax(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling maximumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMax(String timestampCol, long revTime, String... pairs) Create arolling maximumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMax(String timestampCol, Duration revDuration, String... pairs) Create arolling maximumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMax(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling maximumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMin(long revTicks, long fwdTicks, String... pairs) Create arolling minimumfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingMin(long revTicks, String... pairs) Create arolling minimumfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingMin(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling minimumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMin(String timestampCol, long revTime, String... pairs) Create arolling minimumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMin(String timestampCol, Duration revDuration, String... pairs) Create arolling minimumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingMin(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling minimumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingProduct(long revTicks, long fwdTicks, String... pairs) Create arolling productfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingProduct(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling productfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingProduct(String timestampCol, long revTime, String... pairs) Create arolling productfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingProduct(String timestampCol, Duration revDuration, String... pairs) Create arolling productfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingProduct(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling productfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingStd(long revTicks, long fwdTicks, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingStd(long revTicks, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingStd(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingStd(String timestampCol, long revTime, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingStd(String timestampCol, Duration revDuration, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingStd(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingSum(long revTicks, long fwdTicks, String... pairs) Create arolling sumfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingSum(long revTicks, String... pairs) Create arolling sumfor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingSum(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling sumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingSum(String timestampCol, long revTime, String... pairs) Create arolling sumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingSum(String timestampCol, Duration revDuration, String... pairs) Create arolling sumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingSum(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling sumfor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingWAvg(long revTicks, long fwdTicks, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingWAvg(long revTicks, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using ticks as the windowing unit.static UpdateByOperationRollingWAvg(String timestampCol, long revTime, long fwdTime, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingWAvg(String timestampCol, long revTime, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingWAvg(String timestampCol, Duration revDuration, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit.static UpdateByOperationRollingWAvg(String timestampCol, Duration revDuration, Duration fwdDuration, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit.<T> Twalk(UpdateByOperation.Visitor<T> visitor)
-
Method Details
-
of
Conjoin anUpdateBySpecwith columns for it to be applied to so the engine can construct the proper operators.- Parameters:
spec- theUpdateBySpecthat defines the operation to performcolumns- the columns to apply the operation to.- Returns:
- a
ColumnUpdateOperationthat will be used to construct operations for each column
-
of
Conjoin anUpdateBySpecwith columns for it to be applied to so the engine can construct the proper operators.- Parameters:
spec- theUpdateBySpecthat defines the operation to performcolumns- the columns to apply the operation to.- Returns:
- a
ColumnUpdateOperationthat will be used to construct operations for each column
-
CumSum
Create acumulative sumfor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
CumProd
Create acumulative productfor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
CumMin
Create acumulative minimumfor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
CumMax
Create acumulative maximumfor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
CumCountWhere
Create acumulative count wherethat counts the number of rows that pass the provided filters.- Parameters:
resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
CumCountWhere
Create acumulative count wherethat counts the number of rows that pass the provided filter.- Parameters:
resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
Fill
Create aforward fillfor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
Ema
Create anexponential moving averagefor the supplied column name pairs, using ticks as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-1 / tickDecay) ema_next = a * ema_last + (1 - a) * value- Parameters:
tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ema
Create anexponential moving averagefor the supplied column name pairs, using ticks as the decay unit.The formula used is
a = e^(-1 / tickDecay) ema_next = a * ema_last + (1 - a) * value- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ema
Create anexponential moving averagefor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / timeDecay) ema_next = a * ema_last + (1 - a) * value- Parameters:
timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ema
static UpdateByOperation Ema(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving averagefor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / timeDecay) ema_next = a * ema_last + (1 - a) * value- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ema
Create anexponential moving averagefor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / durationDecay) ema_next = a * ema_last + (1 - a) * value- Parameters:
timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
Ema
static UpdateByOperation Ema(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving averagefor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / durationDecay) ema_next = a * ema_last + (1 - a) * value- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
Ems
Create anexponential moving sumfor the supplied column name pairs, using ticks as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-1 / tickDecay) ems_next = a * ems_last + value- Parameters:
tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ems
Create anexponential moving sumfor the supplied column name pairs, using ticks as the decay unit.The formula used is
a = e^(-1 / tickDecay) ems_next = a * ems_last + value- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ems
Create anexponential moving sumfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / timeDecay) ems_next = a * ems_last + value- Parameters:
timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ems
static UpdateByOperation Ems(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving sumfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / timeDecay) ems_next = a * ems_last + value- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
Ems
Create anexponential moving sumfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / durationDecay) ems_next = a * ems_last + value- Parameters:
timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
Ems
static UpdateByOperation Ems(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving sumfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / durationDecay) ems_next = a * ems_last + value- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMin
Create anexponential moving minimumfor the supplied column name pairs, using ticks as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-1 / tickDecay) em_val_next = min(a * em_val_last, value)- Parameters:
tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMin
Create anexponential moving minimumfor the supplied column name pairs, using ticks as the decay unit.The formula used is
a = e^(-1 / tickDecay) em_val_next = min(a * em_val_last, value)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMin
Create anexponential moving minimumfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / timeDecay) em_val_next = min(a * em_val_last, value)- Parameters:
timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMin
static UpdateByOperation EmMin(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving minimumfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / timeDecay) em_val_next = min(a * em_val_last, value)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMin
Create anexponential moving minimumfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / durationDecay) em_val_next = min(a * em_val_last, value)- Parameters:
timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMin
static UpdateByOperation EmMin(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving minimumfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / durationDecay) em_val_next = min(a * em_val_last, value)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMax
Create anexponential moving maximumfor the supplied column name pairs, using ticks as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-1 / tickDecay) em_val_next = max(a * em_val_last, value)- Parameters:
tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMax
Create anexponential moving maximumfor the supplied column name pairs, using ticks as the decay unit.The formula used is
a = e^(-1 / tickDecay) em_val_next = max(a * em_val_last, value)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMax
Create anexponential moving maximumfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / timeDecay) em_val_next = max(a * em_val_last, value)- Parameters:
timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMax
static UpdateByOperation EmMax(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving maximumfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / timeDecay) em_val_next = max(a * em_val_last, value)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMax
Create anexponential moving maximumfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / durationDecay) em_val_next = max(a * em_val_last, value)- Parameters:
timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
EmMax
static UpdateByOperation EmMax(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving maximumfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / durationDecay) em_val_next = max(a * em_val_last, value)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
EmStd
Create anexponential moving standard deviationfor the supplied column name pairs, using ticks as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-1 / tickDecay) variance = a * (prevVariance + (1 - a) * (x - prevEma)^2) ema = a * prevEma + x std = sqrt(variance)- Parameters:
tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmStd
Create anexponential moving standard deviationfor the supplied column name pairs, using ticks as the decay unit.The formula used is
a = e^(-1 / tickDecay) variance = a * (prevVariance + (1 - a) * (x - prevEma)^2) ema = a * prevEma + x std = sqrt(variance)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.tickDecay- the decay rate in tickspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmStd
Create anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / timeDecay) variance = a * (prevVariance + (1 - a) * (x - prevEma)^2) ema = a * prevEma + x std = sqrt(variance)- Parameters:
timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmStd
static UpdateByOperation EmStd(OperationControl control, String timestampColumn, long timeDecay, String... pairs) Create anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / timeDecay) variance = a * (prevVariance + (1 - a) * (x - prevEma)^2) ema = a * prevEma + x std = sqrt(variance)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampstimeDecay- the decay rate in nanosecondspairs- The input/output column name pairs- Returns:
- The aggregation
-
EmStd
Create anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit. Uses the default OperationControl settings.The formula used is
a = e^(-dt / durationDecay) variance = a * (prevVariance + (1 - a) * (x - prevEma)^2) ema = a * prevEma + x std = sqrt(variance)- Parameters:
timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
EmStd
static UpdateByOperation EmStd(OperationControl control, String timestampColumn, Duration durationDecay, String... pairs) Create anexponential moving standard deviationfor the supplied column name pairs, using time as the decay unit.The formula used is
a = e^(-dt / durationDecay) variance = a * (prevVariance + (1 - a) * (x - prevEma)^2) ema = a * prevEma + x std = sqrt(variance)- Parameters:
control- acontrolobject that defines how special cases should behave. SeeOperationControlfor further details.timestampColumn- the column in the source table to use for timestampsdurationDecay- the decay rate asdurationpairs- The input/output column name pairs- Returns:
- The aggregation
-
Delta
Create adeltafor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
Delta
Create adeltafor the supplied column name pairs.- Parameters:
pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingSum
Create arolling sumfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingSum
Create arolling sumfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows.Here are some examples of window values:
revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingSum
Create arolling sumfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingSum
static UpdateByOperation RollingSum(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling sumfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingSum
Create arolling sumfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingSum
static UpdateByOperation RollingSum(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling sumfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingGroup
Createrolling groupsfor the supplied column name pairs, using ticks as the windowing unit. Uses the default OperationControl settings.- Parameters:
prevTimeTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingGroup
Createrolling groupsfor the supplied column name pairs, using ticks as the windowing unit. Uses the default OperationControl settings.- Parameters:
prevTimeTicks- the look-behind window size (in rows/ticks)fwdTimeTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingGroup
static UpdateByOperation RollingGroup(String timestampCol, Duration prevWindowDuration, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit. Uses the default OperationControl settings.- Parameters:
prevWindowDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingGroup
static UpdateByOperation RollingGroup(String timestampCol, Duration prevWindowDuration, Duration fwdWindowDuration, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit. Uses the default OperationControl settings.- Parameters:
prevWindowDuration- the look-behind window size (in Duration)fwdWindowDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingGroup
Createrolling groupsfor the supplied column name pairs, using time as the windowing unit. Uses the default OperationControl settings.- Parameters:
prevWindowNanos- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingGroup
static UpdateByOperation RollingGroup(String timestampCol, long prevWindowNanos, long fwdWindowNanos, String... pairs) Createrolling groupsfor the supplied column name pairs, using time as the windowing unit. Uses the default OperationControl settings.- Parameters:
prevWindowNanos- the look-behind window size (in nanoseconds)fwdWindowNanos- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingAvg
Create arolling averagefor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingAvg
Create arolling averagefor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows. Here are some examples of window values:revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingAvg
Create arolling averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Here are some examples of window values:revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingAvg
static UpdateByOperation RollingAvg(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Here are some examples of window values:revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingAvg
Create arolling averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingAvg
static UpdateByOperation RollingAvg(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMin
Create arolling minimumfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMin
Create arolling minimumfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows.Here are some examples of window values:
revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMin
Create arolling minimumfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMin
static UpdateByOperation RollingMin(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling minimumfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMin
Create arolling minimumfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMin
static UpdateByOperation RollingMin(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling minimumfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMax
Create arolling maximumfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMax
Create arolling maximumfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows. Here are some examples of window values:revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMax
Create arolling maximumfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMax
static UpdateByOperation RollingMax(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling maximumfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMax
Create arolling maximumfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingMax
static UpdateByOperation RollingMax(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling maximumfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingProduct
Create arolling productfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows. Here are some examples of window values:revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingProduct
Create arolling productfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Here are some examples of window values:revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingProduct
static UpdateByOperation RollingProduct(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling productfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Here are some examples of window values:revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingProduct
Create arolling productfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingProduct
static UpdateByOperation RollingProduct(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling productfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCount
Create arolling countfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCount
Create arolling countfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows.Here are some examples of window values:
revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCount
Create arolling countfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCount
static UpdateByOperation RollingCount(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling countfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCount
Create arolling countfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCount
static UpdateByOperation RollingCount(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling countfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingCountWhere
Create arolling count wherethat will count values that pass the provided filters, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(long revTicks, long fwdTicks, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
Create arolling count wherethat will count values that pass the provided filter, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(long revTicks, long fwdTicks, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, Duration revDuration, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, Duration revDuration, Duration fwdDuration, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, long revTime, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, long revTime, long fwdTime, String resultColumn, String... filters) Create arolling count wherethat will count values that pass the provided filters, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)resultColumn- The output column name in the result tablefilters- The filters to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, Duration revDuration, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, Duration revDuration, Duration fwdDuration, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, long revTime, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
RollingCountWhere
static UpdateByOperation RollingCountWhere(String timestampCol, long revTime, long fwdTime, String resultColumn, Filter filter) Create arolling count wherethat will count values that pass the provided filter, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)resultColumn- The output column name in the result tablefilter- The filter to apply to the input columns- Returns:
- The aggregation
-
RollingStd
Create arolling sample standard deviationfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows. Sample standard deviation is computed using Bessel's correction (https://en.wikipedia.org/wiki/Bessel%27s_correction), which ensures that the sample variance will be an unbiased estimator of population variance.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingStd
Create arolling sample standard deviationfor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows. Here are some examples of window values:revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingStd
Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Here are some examples of window values:revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingStd
static UpdateByOperation RollingStd(String timestampCol, Duration revDuration, Duration fwdDuration, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Here are some examples of window values:revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingStd
Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Sample standard deviation is computed using Bessel's correction (https://en.wikipedia.org/wiki/Bessel%27s_correction), which ensures that the sample variance will be an unbiased estimator of population variance.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingStd
static UpdateByOperation RollingStd(String timestampCol, long revTime, long fwdTime, String... pairs) Create arolling sample standard deviationfor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows. Sample standard deviation is computed using Bessel's correction (https://en.wikipedia.org/wiki/Bessel%27s_correction), which ensures that the sample variance will be an unbiased estimator of population variance.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingWAvg
Create arolling weighted averagefor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingWAvg
static UpdateByOperation RollingWAvg(long revTicks, long fwdTicks, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows.Here are some examples of window values:
revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingWAvg
static UpdateByOperation RollingWAvg(String timestampCol, Duration revDuration, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingWAvg
static UpdateByOperation RollingWAvg(String timestampCol, Duration revDuration, Duration fwdDuration, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingWAvg
static UpdateByOperation RollingWAvg(String timestampCol, long revTime, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingWAvg
static UpdateByOperation RollingWAvg(String timestampCol, long revTime, long fwdTime, String weightCol, String... pairs) Create arolling weighted averagefor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(long revTicks, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.- Parameters:
revTicks- the look-behind window size (in rows/ticks)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
paramToken- the parameter name for the input column's vector within the formula. If formula is max(each), then each is the formula_param.pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(long revTicks, long fwdTicks, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows.Here are some examples of window values:
revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
paramToken- the parameter name for the input column's vector within the formula. If formula is max(each), then each is the formula_param.pairs- the input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(String timestampCol, Duration revDuration, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)formula- the user-definedformulato apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
paramToken- theparameter tokenfor the input column's vector within the formula. If formula is max(each), then each is the formula_param.pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(String timestampCol, Duration revDuration, Duration fwdDuration, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)formula- the user-definedformulato apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
paramToken- theparameter tokenfor the input column's vector within the formula. If formula is max(each), then each is the formula_param.pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(String timestampCol, long revTime, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
paramToken- the parameter name for the input column's vector within the formula. If formula is max(each), then each is the formula_param.pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(String timestampCol, long revTime, long fwdTime, String formula, String paramToken, String... pairs) Create arolling formulafor the supplied column name pairs, using time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
paramToken- the parameter name for the input column's vector within the formula. If formula is max(each), then each is the formula_param.pairs- The input/output column name pairs- Returns:
- The aggregation
-
RollingFormula
Create arolling formulausing ticks as the windowing unit. Ticks are row counts and you may specify the previous window in number of rows to include. The current row is considered to belong to the reverse window, so calling this withrevTicks = 1will simply return the current row. SpecifyingrevTicks = 10will include the previous 9 rows to this one and this row for a total of 10 rows.The provided
formulashould specify the output column name. Some examples of formula are:sum_AB = sum(col_A) + sum(col_B) max_AB = max(col_A) + max(col_B) values = col_A + col_B
- Parameters:
revTicks- the look-behind window size (in rows/ticks)formula- the user-defined formula to apply to each group. This formula includes the output column name and can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
- Returns:
- The aggregation
-
RollingFormula
Create arolling formulausing ticks as the windowing unit. Ticks are row counts and you may specify the reverse and forward window in number of rows to include. The current row is considered to belong to the reverse window but not the forward window. Also, negative values are allowed and can be used to generate completely forward or completely reverse windows.Here are some examples of window values:
revTicks = 1, fwdTicks = 0- contains only the current rowrevTicks = 10, fwdTicks = 0- contains 9 previous rows and the current rowrevTicks = 0, fwdTicks = 10- contains the following 10 rows, excludes the current rowrevTicks = 10, fwdTicks = 10- contains the previous 9 rows, the current row and the 10 rows followingrevTicks = 10, fwdTicks = -5- contains 5 rows, beginning at 9 rows before, ending at 5 rows before the current row (inclusive)revTicks = 11, fwdTicks = -1- contains 10 rows, beginning at 10 rows before, ending at 1 row before the current row (inclusive)revTicks = -5, fwdTicks = 10- contains 5 rows, beginning 5 rows following, ending at 10 rows following the current row (inclusive)
The provided
formulashould specify the output column name. Some examples of formula are:sum_AB = sum(col_A) + sum(col_B) max_AB = max(col_A) + max(col_B) values = col_A + col_B
- Parameters:
revTicks- the look-behind window size (in rows/ticks)fwdTicks- the look-ahead window size (in rows/ticks)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
- Returns:
- The aggregation
-
RollingFormula
Create arolling formulausing time as the windowing unit. This function acceptsdurationas the reverse window parameter. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m- contains rows from 10m earlier through the current row timestamp (inclusive)
The provided
formulashould specify the output column name. Some examples of formula are:sum_AB = sum(col_A) + sum(col_B) max_AB = max(col_A) + max(col_B) values = col_A + col_B
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)formula- the user-definedformulato apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(String timestampCol, Duration revDuration, Duration fwdDuration, String formula) Create arolling formulausing time as the windowing unit. This function acceptsdurationsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.Here are some examples of window values:
revDuration = 0m, fwdDuration = 0m- contains rows that exactly match the current row timestamprevDuration = 10m, fwdDuration = 0m- contains rows from 10m earlier through the current row timestamp (inclusive)revDuration = 0m, fwdDuration = 10m- contains rows from the current row through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = 10m- contains rows from 10m earlier through 10m following the current row timestamp (inclusive)revDuration = 10m, fwdDuration = -5m- contains rows from 10m earlier through 5m before the current row timestamp (inclusive), this is a purely backwards looking windowrevDuration = -5m, fwdDuration = 10m- contains rows from 5m following through 10m following the current row timestamp (inclusive), this is a purely forwards looking window
The provided
formulashould specify the output column name. Some examples of formula are:sum_AB = sum(col_A) + sum(col_B) max_AB = max(col_A) + max(col_B) values = col_A + col_B
- Parameters:
timestampCol- the name of the timestamp columnrevDuration- the look-behind window size (in Duration)fwdDuration- the look-ahead window size (in Duration)formula- the user-definedformulato apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
- Returns:
- The aggregation
-
RollingFormula
Create arolling formulausing time as the windowing unit. This function acceptsnanosecondsas the reverse window parameters. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.The provided
formulashould specify the output column name. Some examples of formula are:sum_AB = sum(col_A) + sum(col_B) max_AB = max(col_A) + max(col_B) values = col_A + col_B
- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
- Returns:
- The aggregation
-
RollingFormula
static UpdateByOperation RollingFormula(String timestampCol, long revTime, long fwdTime, String formula) Create arolling formulausing time as the windowing unit. This function acceptsnanosecondsas the reverse and forward window parameters. Negative values are allowed and can be used to generate completely forward or completely reverse windows. A row containing anullin the timestamp column belongs to no window and will not have a value computed or be considered in the windows of other rows.The provided
formulashould specify the output column name. Some examples of formula are:sum_AB = sum(col_A) + sum(col_B) max_AB = max(col_A) + max(col_B) values = col_A + col_B
- Parameters:
timestampCol- the name of the timestamp columnrevTime- the look-behind window size (in nanoseconds)fwdTime- the look-ahead window size (in nanoseconds)formula- the user-defined formula to apply to each group. This formula can contain any combination of the following:- Built-in functions such as min, max, etc.
- Mathematical arithmetic such as *, +, /, etc.
- User-defined functions
- Returns:
- The aggregation
-
walk
-