RangeFrame is a
FrameType of WindowSpecs with the following:
- rangeBetween operator or RANGE BETWEEN SQL clause
- Unspecified frame with an order specification
CumeDist window function expression requires a
RangeFrame with UnboundedPreceding and CurrentRow.
It is because
CUME_DIST must return the same value for equal values in the partition.
UnspecifiedFrame with Order Specification and ResolveWindowFrame¶
RangeFrame with UnboundedPreceding and CurrentRow is assumed (by ResolveWindowFrame logical resolution rule) for ordered window specifications (WindowSpecDefinitions with
UnspecifiedFrame but a non-empty order specification).
inputType can be any of the following numeric and interval data types:
inputType is part of the
sql is part of the