Package | Description |
---|---|
org.apache.calcite.tools |
Modifier and Type | Method and Description |
---|---|
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 . |
Modifier and Type | Method and Description |
---|---|
default <R> R |
RelBuilder.OverCall.let(Function<RelBuilder.OverCall,R> consumer)
Performs an action on this OverCall.
|
Copyright © 2014–2024 The Apache Software Foundation. All rights reserved.