RelBuilder.OverCall |
RelBuilder.OverCall.allowPartial(boolean allowPartial) |
Sets whether to allow partial width windows; default true.
|
RelBuilder.OverCall |
RelBuilder.OverCall.nullWhenCountZero(boolean nullWhenCountZero) |
Sets whether the aggregate function should evaluate to null if no rows are in the window;
default false.
|
RelBuilder.OverCall |
RelBuilder.OverCall.orderBy(Iterable<? extends org.apache.calcite.rex.RexNode> expressions) |
Sets the ORDER BY BY clause to a list of expressions.
|
RelBuilder.OverCall |
RelBuilder.OverCall.orderBy(org.apache.calcite.rex.RexNode... expressions) |
Sets the ORDER BY BY clause to an array of expressions.
|
RelBuilder.OverCall |
RelBuilder.AggCall.over() |
Converts this aggregate call to a windowed aggregate call.
|
RelBuilder.OverCall |
RelBuilder.OverCall.partitionBy(Iterable<? extends org.apache.calcite.rex.RexNode> expressions) |
Sets the PARTITION BY clause to a list of expressions.
|
RelBuilder.OverCall |
RelBuilder.OverCall.partitionBy(org.apache.calcite.rex.RexNode... expressions) |
Sets the PARTITION BY clause to an array of expressions.
|
RelBuilder.OverCall |
RelBuilder.OverCall.rangeBetween(org.apache.calcite.rex.RexWindowBound lower,
org.apache.calcite.rex.RexWindowBound upper) |
Sets a RANGE window with lower and upper bounds, equivalent to SQL RANGE BETWEEN
lower ROW AND upper.
|
default RelBuilder.OverCall |
RelBuilder.OverCall.rangeFrom(org.apache.calcite.rex.RexWindowBound lower) |
Sets a RANGE window with a lower bound, equivalent to SQL RANGE BETWEEN lower AND
CURRENT ROW.
|
default RelBuilder.OverCall |
RelBuilder.OverCall.rangeTo(org.apache.calcite.rex.RexWindowBound upper) |
Sets a RANGE window with an upper bound, equivalent to SQL RANGE BETWEEN CURRENT
ROW AND upper.
|
default RelBuilder.OverCall |
RelBuilder.OverCall.rangeUnbounded() |
Sets an unbounded RANGE window, equivalent to SQL RANGE BETWEEN UNBOUNDED
PRECEDING AND UNBOUNDED FOLLOWING.
|
RelBuilder.OverCall |
RelBuilder.OverCall.rowsBetween(org.apache.calcite.rex.RexWindowBound lower,
org.apache.calcite.rex.RexWindowBound upper) |
Sets a RANGE window with lower and upper bounds, equivalent to SQL ROWS BETWEEN
lower ROW AND upper.
|
default RelBuilder.OverCall |
RelBuilder.OverCall.rowsFrom(org.apache.calcite.rex.RexWindowBound lower) |
Sets a ROWS window with a lower bound, equivalent to SQL ROWS BETWEEN lower AND
CURRENT ROW.
|
default RelBuilder.OverCall |
RelBuilder.OverCall.rowsTo(org.apache.calcite.rex.RexWindowBound upper) |
Sets a ROWS window with an upper bound, equivalent to SQL ROWS BETWEEN CURRENT ROW
AND upper.
|
default RelBuilder.OverCall |
RelBuilder.OverCall.rowsUnbounded() |
Sets an unbounded ROWS window, equivalent to SQL ROWS BETWEEN UNBOUNDED PRECEDING
AND UNBOUNDED FOLLOWING.
|