OPAL Window Functions¶
Function |
Description |
---|---|
Return any value of one column across a group |
|
Return any non-null value of one column across a… |
|
Calculate the arithmetic average of the input… |
|
Count the number of non-null items in the group. |
|
Estimate the approximate number of distinct values… |
|
Count the exact number of distinct values in the… |
|
Returns the dense rank within an ordered group of… |
|
Calculate the average per-second derivative of the… |
|
Return the first value of one column across an… |
|
Return the first non-null value of one column across… |
|
Return the lag of one column across an ordered… |
|
Return the last value of one column across an… |
|
Return the last non-null value of one column across… |
|
Return the lead of one column across an ordered… |
|
Compute the maximum of one column across a group… |
|
Return the fast approximate median value of one… |
|
Return the exact median value of one column. |
|
Compute the minimum of one column across a group… |
|
Returns one OBJECT per group. For each (key, value)… |
|
Returns an approximated value for the specified… |
|
Assuming a continuous distribution, it returns the… |
|
Assuming a discrete distribution, it returns the… |
|
Returns the rank within an ordered group of values…. |
|
Calculate the average per-second rate of the… |
|
Return the window index of the row within its… |
|
Calculate the standard deviation across the group. |
|
Calculate the sum of the argument across the group,… |