This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 6c2bb41fe8 Publish built docs triggered by
8a88fdcc23e0c09c51e9c6285d78ffe89bf5935f
6c2bb41fe8 is described below
commit 6c2bb41fe85669c52094a9adb3106eaad63754ab
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Nov 13 19:25:21 2024 +0000
Publish built docs triggered by 8a88fdcc23e0c09c51e9c6285d78ffe89bf5935f
---
_sources/user-guide/sql/index.rst.txt | 1 -
_sources/user-guide/sql/window_functions.md.txt | 122 ++-
.../user-guide/sql/window_functions_new.md.txt | 290 ------
contributor-guide/architecture.html | 5 -
contributor-guide/communication.html | 5 -
contributor-guide/getting_started.html | 5 -
contributor-guide/governance.html | 5 -
contributor-guide/howtos.html | 5 -
contributor-guide/index.html | 5 -
contributor-guide/inviting.html | 5 -
contributor-guide/roadmap.html | 5 -
contributor-guide/specification/index.html | 5 -
contributor-guide/specification/invariants.html | 5 -
.../specification/output-field-name-semantic.html | 5 -
contributor-guide/testing.html | 5 -
download.html | 5 -
genindex.html | 5 -
index.html | 5 -
library-user-guide/adding-udfs.html | 5 -
library-user-guide/api-health.html | 5 -
library-user-guide/building-logical-plans.html | 5 -
library-user-guide/catalogs.html | 5 -
library-user-guide/custom-table-providers.html | 5 -
library-user-guide/extending-operators.html | 5 -
library-user-guide/extensions.html | 5 -
library-user-guide/index.html | 5 -
library-user-guide/profiling.html | 5 -
library-user-guide/query-optimizer.html | 5 -
library-user-guide/using-the-dataframe-api.html | 5 -
library-user-guide/using-the-sql-api.html | 5 -
library-user-guide/working-with-exprs.html | 5 -
objects.inv | Bin 1756 -> 1736 bytes
search.html | 5 -
searchindex.js | 2 +-
user-guide/cli/datasources.html | 5 -
user-guide/cli/index.html | 5 -
user-guide/cli/installation.html | 5 -
user-guide/cli/overview.html | 5 -
user-guide/cli/usage.html | 5 -
user-guide/concepts-readings-events.html | 5 -
user-guide/configs.html | 5 -
user-guide/crate-configuration.html | 5 -
user-guide/dataframe.html | 5 -
user-guide/example-usage.html | 5 -
user-guide/explain-usage.html | 5 -
user-guide/expressions.html | 5 -
user-guide/faq.html | 5 -
user-guide/introduction.html | 5 -
user-guide/sql/aggregate_functions.html | 5 -
user-guide/sql/data_types.html | 5 -
user-guide/sql/ddl.html | 5 -
user-guide/sql/dml.html | 5 -
user-guide/sql/explain.html | 5 -
user-guide/sql/index.html | 15 +-
user-guide/sql/information_schema.html | 5 -
user-guide/sql/operators.html | 5 -
user-guide/sql/scalar_functions.html | 11 +-
user-guide/sql/select.html | 5 -
user-guide/sql/special_functions.html | 5 -
user-guide/sql/sql_status.html | 5 -
user-guide/sql/subqueries.html | 5 -
user-guide/sql/window_functions.html | 250 ++++-
user-guide/sql/window_functions_new.html | 1035 --------------------
user-guide/sql/write_options.html | 5 -
64 files changed, 335 insertions(+), 1666 deletions(-)
diff --git a/_sources/user-guide/sql/index.rst.txt
b/_sources/user-guide/sql/index.rst.txt
index 4499aac536..0508fa12f0 100644
--- a/_sources/user-guide/sql/index.rst.txt
+++ b/_sources/user-guide/sql/index.rst.txt
@@ -31,7 +31,6 @@ SQL Reference
operators
aggregate_functions
window_functions
- window_functions_new
scalar_functions
special_functions
sql_status
diff --git a/_sources/user-guide/sql/window_functions.md.txt
b/_sources/user-guide/sql/window_functions.md.txt
index 8216a3b258..a68fdbda67 100644
--- a/_sources/user-guide/sql/window_functions.md.txt
+++ b/_sources/user-guide/sql/window_functions.md.txt
@@ -12,22 +12,25 @@
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- KIND, either expressioness or implied. See the License for the
+ KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
+<!---
+This file was generated by the dev/update_function_docs.sh script.
+Do not edit it manually as changes will be overwritten.
+Instead, edit the WindowUDFImpl's documentation() function to
+update documentation for an individual UDF or the
+dev/update_function_docs.sh file for updating surrounding text.
+-->
+
# Window Functions
A _window function_ performs a calculation across a set of table rows that are
somehow related to the current row.
-
-Note: this documentation is in the process of being migrated to be
[automatically created from the codebase].
-Please see the [Window Functions (new)](window_functions_new.md) page for
-the rest of the documentation.
-
-[automatically created from the codebase]:
https://github.com/apache/datafusion/issues/12740
-
-Window functions are comparable to the type of calculation that can be done
with an aggregate function. However, window functions do not cause rows to
become grouped into a single output row like non-window aggregate calls would.
Instead, the rows retain their separate identities. Behind the scenes, the
window function is able to access more than just the current row of the query
result
+This is comparable to the type of calculation that can be done with an
aggregate function.
+However, window functions do not cause rows to become grouped into a single
output row like non-window aggregate calls would.
+Instead, the rows retain their separate identities. Behind the scenes, the
window function is able to access more than just the current row of the query
result
Here is an example that shows how to compare each employee's salary with the
average salary in his or her department:
@@ -146,17 +149,80 @@ RANGE and GROUPS modes require an ORDER BY clause (with
RANGE the ORDER BY must
All [aggregate functions](aggregate_functions.md) can be used as window
functions.
-## Analytical functions
+## Ranking Functions
+
+- [cume_dist](#cume_dist)
+- [dense_rank](#dense_rank)
+- [ntile](#ntile)
+- [percent_rank](#percent_rank)
+- [rank](#rank)
+- [row_number](#row_number)
+
+### `cume_dist`
+
+Relative rank of the current row: (number of rows preceding or peer with
current row) / (total rows).
+
+```
+cume_dist()
+```
+
+### `dense_rank`
+
+Returns the rank of the current row without gaps. This function ranks rows in
a dense manner, meaning consecutive ranks are assigned even for identical
values.
+
+```
+dense_rank()
+```
+
+### `ntile`
+
+Integer ranging from 1 to the argument value, dividing the partition as
equally as possible
+
+```
+ntile(expression)
+```
+
+#### Arguments
+
+- **expression**: An integer describing the number groups the partition should
be split into
+
+### `percent_rank`
+
+Returns the percentage rank of the current row within its partition. The value
ranges from 0 to 1 and is computed as `(rank - 1) / (total_rows - 1)`.
+
+```
+percent_rank()
+```
+
+### `rank`
+
+Returns the rank of the current row within its partition, allowing gaps
between ranks. This function provides a ranking similar to `row_number`, but
skips ranks for identical values.
+
+```
+rank()
+```
+
+### `row_number`
+
+Number of the current row within its partition, counting from 1.
+
+```
+row_number()
+```
+
+## Analytical Functions
- [first_value](#first_value)
+- [lag](#lag)
- [last_value](#last_value)
+- [lead](#lead)
- [nth_value](#nth_value)
### `first_value`
Returns value evaluated at the row that is the first row of the window frame.
-```sql
+```
first_value(expression)
```
@@ -164,11 +230,25 @@ first_value(expression)
- **expression**: Expression to operate on
+### `lag`
+
+Returns value evaluated at the row that is offset rows before the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value).
+
+```
+lag(expression, offset, default)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on
+- **offset**: Integer. Specifies how many rows back the value of expression
should be retrieved. Defaults to 1.
+- **default**: The default value if the offset is not within the partition.
Must be of the same type as expression.
+
### `last_value`
Returns value evaluated at the row that is the last row of the window frame.
-```sql
+```
last_value(expression)
```
@@ -176,15 +256,29 @@ last_value(expression)
- **expression**: Expression to operate on
+### `lead`
+
+Returns value evaluated at the row that is offset rows after the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value).
+
+```
+lead(expression, offset, default)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on
+- **offset**: Integer. Specifies how many rows forward the value of expression
should be retrieved. Defaults to 1.
+- **default**: The default value if the offset is not within the partition.
Must be of the same type as expression.
+
### `nth_value`
Returns value evaluated at the row that is the nth row of the window frame
(counting from 1); null if no such row.
-```sql
+```
nth_value(expression, n)
```
#### Arguments
- **expression**: The name the column of which nth value to retrieve
-- **n**: Integer. Specifies the _n_ in nth
+- **n**: Integer. Specifies the n in nth
diff --git a/_sources/user-guide/sql/window_functions_new.md.txt
b/_sources/user-guide/sql/window_functions_new.md.txt
deleted file mode 100644
index 1727dececb..0000000000
--- a/_sources/user-guide/sql/window_functions_new.md.txt
+++ /dev/null
@@ -1,290 +0,0 @@
-<!---
- Licensed to the Apache Software Foundation (ASF) under one
- or more contributor license agreements. See the NOTICE file
- distributed with this work for additional information
- regarding copyright ownership. The ASF licenses this file
- to you under the Apache License, Version 2.0 (the
- "License"); you may not use this file except in compliance
- with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
- Unless required by applicable law or agreed to in writing,
- software distributed under the License is distributed on an
- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- KIND, either express or implied. See the License for the
- specific language governing permissions and limitations
- under the License.
--->
-
-<!---
-This file was generated by the dev/update_function_docs.sh script.
-Do not edit it manually as changes will be overwritten.
-Instead, edit the WindowUDFImpl's documentation() function to
-update documentation for an individual UDF or the
-dev/update_function_docs.sh file for updating surrounding text.
--->
-
-# Window Functions (NEW)
-
-Note: this documentation is in the process of being migrated to be
[automatically created from the codebase].
-Please see the [Window Functions (Old)](window_functions.md) page for
-the rest of the documentation.
-
-[automatically created from the codebase]:
https://github.com/apache/datafusion/issues/12740
-
-A _window function_ performs a calculation across a set of table rows that are
somehow related to the current row.
-This is comparable to the type of calculation that can be done with an
aggregate function.
-However, window functions do not cause rows to become grouped into a single
output row like non-window aggregate calls would.
-Instead, the rows retain their separate identities. Behind the scenes, the
window function is able to access more than just the current row of the query
result
-
-Here is an example that shows how to compare each employee's salary with the
average salary in his or her department:
-
-```sql
-SELECT depname, empno, salary, avg(salary) OVER (PARTITION BY depname) FROM
empsalary;
-
-+-----------+-------+--------+-------------------+
-| depname | empno | salary | avg |
-+-----------+-------+--------+-------------------+
-| personnel | 2 | 3900 | 3700.0 |
-| personnel | 5 | 3500 | 3700.0 |
-| develop | 8 | 6000 | 5020.0 |
-| develop | 10 | 5200 | 5020.0 |
-| develop | 11 | 5200 | 5020.0 |
-| develop | 9 | 4500 | 5020.0 |
-| develop | 7 | 4200 | 5020.0 |
-| sales | 1 | 5000 | 4866.666666666667 |
-| sales | 4 | 4800 | 4866.666666666667 |
-| sales | 3 | 4800 | 4866.666666666667 |
-+-----------+-------+--------+-------------------+
-```
-
-A window function call always contains an OVER clause directly following the
window function's name and argument(s). This is what syntactically
distinguishes it from a normal function or non-window aggregate. The OVER
clause determines exactly how the rows of the query are split up for processing
by the window function. The PARTITION BY clause within OVER divides the rows
into groups, or partitions, that share the same values of the PARTITION BY
expression(s). For each row, the window fu [...]
-
-You can also control the order in which rows are processed by window functions
using ORDER BY within OVER. (The window ORDER BY does not even have to match
the order in which the rows are output.) Here is an example:
-
-```sql
-SELECT depname, empno, salary,
- rank() OVER (PARTITION BY depname ORDER BY salary DESC)
-FROM empsalary;
-
-+-----------+-------+--------+--------+
-| depname | empno | salary | rank |
-+-----------+-------+--------+--------+
-| personnel | 2 | 3900 | 1 |
-| develop | 8 | 6000 | 1 |
-| develop | 10 | 5200 | 2 |
-| develop | 11 | 5200 | 2 |
-| develop | 9 | 4500 | 4 |
-| develop | 7 | 4200 | 5 |
-| sales | 1 | 5000 | 1 |
-| sales | 4 | 4800 | 2 |
-| personnel | 5 | 3500 | 2 |
-| sales | 3 | 4800 | 2 |
-+-----------+-------+--------+--------+
-```
-
-There is another important concept associated with window functions: for each
row, there is a set of rows within its partition called its window frame. Some
window functions act only on the rows of the window frame, rather than of the
whole partition. Here is an example of using window frames in queries:
-
-```sql
-SELECT depname, empno, salary,
- avg(salary) OVER(ORDER BY salary ASC ROWS BETWEEN 1 PRECEDING AND 1
FOLLOWING) AS avg,
- min(salary) OVER(ORDER BY empno ASC ROWS BETWEEN UNBOUNDED PRECEDING AND
CURRENT ROW) AS cum_min
-FROM empsalary
-ORDER BY empno ASC;
-
-+-----------+-------+--------+--------------------+---------+
-| depname | empno | salary | avg | cum_min |
-+-----------+-------+--------+--------------------+---------+
-| sales | 1 | 5000 | 5000.0 | 5000 |
-| personnel | 2 | 3900 | 3866.6666666666665 | 3900 |
-| sales | 3 | 4800 | 4700.0 | 3900 |
-| sales | 4 | 4800 | 4866.666666666667 | 3900 |
-| personnel | 5 | 3500 | 3700.0 | 3500 |
-| develop | 7 | 4200 | 4200.0 | 3500 |
-| develop | 8 | 6000 | 5600.0 | 3500 |
-| develop | 9 | 4500 | 4500.0 | 3500 |
-| develop | 10 | 5200 | 5133.333333333333 | 3500 |
-| develop | 11 | 5200 | 5466.666666666667 | 3500 |
-+-----------+-------+--------+--------------------+---------+
-```
-
-When a query involves multiple window functions, it is possible to write out
each one with a separate OVER clause, but this is duplicative and error-prone
if the same windowing behavior is wanted for several functions. Instead, each
windowing behavior can be named in a WINDOW clause and then referenced in OVER.
For example:
-
-```sql
-SELECT sum(salary) OVER w, avg(salary) OVER w
-FROM empsalary
-WINDOW w AS (PARTITION BY depname ORDER BY salary DESC);
-```
-
-## Syntax
-
-The syntax for the OVER-clause is
-
-```
-function([expr])
- OVER(
- [PARTITION BY expr[, …]]
- [ORDER BY expr [ ASC | DESC ][, …]]
- [ frame_clause ]
- )
-```
-
-where **frame_clause** is one of:
-
-```
- { RANGE | ROWS | GROUPS } frame_start
- { RANGE | ROWS | GROUPS } BETWEEN frame_start AND frame_end
-```
-
-and **frame_start** and **frame_end** can be one of
-
-```sql
-UNBOUNDED PRECEDING
-offset PRECEDING
-CURRENT ROW
-offset FOLLOWING
-UNBOUNDED FOLLOWING
-```
-
-where **offset** is an non-negative integer.
-
-RANGE and GROUPS modes require an ORDER BY clause (with RANGE the ORDER BY
must specify exactly one column).
-
-## Aggregate functions
-
-All [aggregate functions](aggregate_functions.md) can be used as window
functions.
-
-## Ranking Functions
-
-- [cume_dist](#cume_dist)
-- [dense_rank](#dense_rank)
-- [ntile](#ntile)
-- [percent_rank](#percent_rank)
-- [rank](#rank)
-- [row_number](#row_number)
-
-### `cume_dist`
-
-Relative rank of the current row: (number of rows preceding or peer with
current row) / (total rows).
-
-```
-cume_dist()
-```
-
-### `dense_rank`
-
-Returns the rank of the current row without gaps. This function ranks rows in
a dense manner, meaning consecutive ranks are assigned even for identical
values.
-
-```
-dense_rank()
-```
-
-### `ntile`
-
-Integer ranging from 1 to the argument value, dividing the partition as
equally as possible
-
-```
-ntile(expression)
-```
-
-#### Arguments
-
-- **expression**: An integer describing the number groups the partition should
be split into
-
-### `percent_rank`
-
-Returns the percentage rank of the current row within its partition. The value
ranges from 0 to 1 and is computed as `(rank - 1) / (total_rows - 1)`.
-
-```
-percent_rank()
-```
-
-### `rank`
-
-Returns the rank of the current row within its partition, allowing gaps
between ranks. This function provides a ranking similar to `row_number`, but
skips ranks for identical values.
-
-```
-rank()
-```
-
-### `row_number`
-
-Number of the current row within its partition, counting from 1.
-
-```
-row_number()
-```
-
-## Analytical Functions
-
-- [first_value](#first_value)
-- [lag](#lag)
-- [last_value](#last_value)
-- [lead](#lead)
-- [nth_value](#nth_value)
-
-### `first_value`
-
-Returns value evaluated at the row that is the first row of the window frame.
-
-```
-first_value(expression)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on
-
-### `lag`
-
-Returns value evaluated at the row that is offset rows before the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value).
-
-```
-lag(expression, offset, default)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on
-- **offset**: Integer. Specifies how many rows back the value of expression
should be retrieved. Defaults to 1.
-- **default**: The default value if the offset is not within the partition.
Must be of the same type as expression.
-
-### `last_value`
-
-Returns value evaluated at the row that is the last row of the window frame.
-
-```
-last_value(expression)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on
-
-### `lead`
-
-Returns value evaluated at the row that is offset rows after the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value).
-
-```
-lead(expression, offset, default)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on
-- **offset**: Integer. Specifies how many rows forward the value of expression
should be retrieved. Defaults to 1.
-- **default**: The default value if the offset is not within the partition.
Must be of the same type as expression.
-
-### `nth_value`
-
-Returns value evaluated at the row that is the nth row of the window frame
(counting from 1); null if no such row.
-
-```
-nth_value(expression, n)
-```
-
-#### Arguments
-
-- **expression**: The name the column of which nth value to retrieve
-- **n**: Integer. Specifies the n in nth
diff --git a/contributor-guide/architecture.html
b/contributor-guide/architecture.html
index 02e795db54..e5fc544641 100644
--- a/contributor-guide/architecture.html
+++ b/contributor-guide/architecture.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/communication.html
b/contributor-guide/communication.html
index 835437cfc7..3b9e920f4c 100644
--- a/contributor-guide/communication.html
+++ b/contributor-guide/communication.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/getting_started.html
b/contributor-guide/getting_started.html
index 8636378635..16b389e839 100644
--- a/contributor-guide/getting_started.html
+++ b/contributor-guide/getting_started.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/governance.html
b/contributor-guide/governance.html
index ac9b8917c3..cfce6b49bb 100644
--- a/contributor-guide/governance.html
+++ b/contributor-guide/governance.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/howtos.html b/contributor-guide/howtos.html
index c7049e168f..81d6da94f5 100644
--- a/contributor-guide/howtos.html
+++ b/contributor-guide/howtos.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/index.html b/contributor-guide/index.html
index c51fb65632..2b1502cb06 100644
--- a/contributor-guide/index.html
+++ b/contributor-guide/index.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/inviting.html b/contributor-guide/inviting.html
index 2430f79483..ca52ac8cae 100644
--- a/contributor-guide/inviting.html
+++ b/contributor-guide/inviting.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/roadmap.html b/contributor-guide/roadmap.html
index 7f9b988e99..01b15ee8ae 100644
--- a/contributor-guide/roadmap.html
+++ b/contributor-guide/roadmap.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/specification/index.html
b/contributor-guide/specification/index.html
index 75120256e2..5a2cf1bceb 100644
--- a/contributor-guide/specification/index.html
+++ b/contributor-guide/specification/index.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/specification/invariants.html
b/contributor-guide/specification/invariants.html
index 9a3ad3091d..7d39e8b0cd 100644
--- a/contributor-guide/specification/invariants.html
+++ b/contributor-guide/specification/invariants.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/specification/output-field-name-semantic.html
b/contributor-guide/specification/output-field-name-semantic.html
index 8828608d02..861da79c14 100644
--- a/contributor-guide/specification/output-field-name-semantic.html
+++ b/contributor-guide/specification/output-field-name-semantic.html
@@ -262,11 +262,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/contributor-guide/testing.html b/contributor-guide/testing.html
index ee834ff39f..a020a2c709 100644
--- a/contributor-guide/testing.html
+++ b/contributor-guide/testing.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/download.html b/download.html
index e87e68b3cf..38c20fa352 100644
--- a/download.html
+++ b/download.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/genindex.html b/genindex.html
index 6932d834c9..40ca2e16ce 100644
--- a/genindex.html
+++ b/genindex.html
@@ -260,11 +260,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/index.html b/index.html
index 6204934945..e614ac89e2 100644
--- a/index.html
+++ b/index.html
@@ -262,11 +262,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/adding-udfs.html
b/library-user-guide/adding-udfs.html
index c6252b2832..a6fa54d801 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/api-health.html
b/library-user-guide/api-health.html
index c379060966..07ba5c8008 100644
--- a/library-user-guide/api-health.html
+++ b/library-user-guide/api-health.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/building-logical-plans.html
b/library-user-guide/building-logical-plans.html
index e418e65046..93709ebba6 100644
--- a/library-user-guide/building-logical-plans.html
+++ b/library-user-guide/building-logical-plans.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/catalogs.html b/library-user-guide/catalogs.html
index 9aa897c523..9f0f5298ef 100644
--- a/library-user-guide/catalogs.html
+++ b/library-user-guide/catalogs.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/custom-table-providers.html
b/library-user-guide/custom-table-providers.html
index bb4c2a4740..7f86ac3e96 100644
--- a/library-user-guide/custom-table-providers.html
+++ b/library-user-guide/custom-table-providers.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/extending-operators.html
b/library-user-guide/extending-operators.html
index 20a0a2216e..ad68ac0988 100644
--- a/library-user-guide/extending-operators.html
+++ b/library-user-guide/extending-operators.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/extensions.html
b/library-user-guide/extensions.html
index c92f6fd655..550ea8024c 100644
--- a/library-user-guide/extensions.html
+++ b/library-user-guide/extensions.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/index.html b/library-user-guide/index.html
index 4511a097fb..db05cc073f 100644
--- a/library-user-guide/index.html
+++ b/library-user-guide/index.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/profiling.html
b/library-user-guide/profiling.html
index ef9d385bfb..19706f67e2 100644
--- a/library-user-guide/profiling.html
+++ b/library-user-guide/profiling.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/query-optimizer.html
b/library-user-guide/query-optimizer.html
index 68bc9360d6..fa5a47478f 100644
--- a/library-user-guide/query-optimizer.html
+++ b/library-user-guide/query-optimizer.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/using-the-dataframe-api.html
b/library-user-guide/using-the-dataframe-api.html
index 127f893375..9b8f43cf59 100644
--- a/library-user-guide/using-the-dataframe-api.html
+++ b/library-user-guide/using-the-dataframe-api.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/using-the-sql-api.html
b/library-user-guide/using-the-sql-api.html
index 4f47a564ec..3b4fbe238a 100644
--- a/library-user-guide/using-the-sql-api.html
+++ b/library-user-guide/using-the-sql-api.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/library-user-guide/working-with-exprs.html
b/library-user-guide/working-with-exprs.html
index edef5573d0..4248c4f18d 100644
--- a/library-user-guide/working-with-exprs.html
+++ b/library-user-guide/working-with-exprs.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal"
href="../user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/objects.inv b/objects.inv
index b6fbffe794..05c722ae9d 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/search.html b/search.html
index 5e3b59f0ac..8b5fdc16d6 100644
--- a/search.html
+++ b/search.html
@@ -267,11 +267,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal"
href="user-guide/sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/scalar_functions.html">
Scalar Functions
diff --git a/searchindex.js b/searchindex.js
index d1d8db93ef..6c69ac5c23 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/cli/datasources.html b/user-guide/cli/datasources.html
index 7e299a550b..86ac166ccb 100644
--- a/user-guide/cli/datasources.html
+++ b/user-guide/cli/datasources.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="../sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/cli/index.html b/user-guide/cli/index.html
index 282ddf7659..73d019bbf5 100644
--- a/user-guide/cli/index.html
+++ b/user-guide/cli/index.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="../sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/cli/installation.html b/user-guide/cli/installation.html
index 4e818a037d..0f7dbbae27 100644
--- a/user-guide/cli/installation.html
+++ b/user-guide/cli/installation.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="../sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/cli/overview.html b/user-guide/cli/overview.html
index 87551e354b..6d155e7b59 100644
--- a/user-guide/cli/overview.html
+++ b/user-guide/cli/overview.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="../sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/cli/usage.html b/user-guide/cli/usage.html
index 2c99b48c98..33434c6eee 100644
--- a/user-guide/cli/usage.html
+++ b/user-guide/cli/usage.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="../sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/concepts-readings-events.html
b/user-guide/concepts-readings-events.html
index bb9be53ee3..072aba68f0 100644
--- a/user-guide/concepts-readings-events.html
+++ b/user-guide/concepts-readings-events.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/configs.html b/user-guide/configs.html
index f639f5f1d1..8f8ce0285f 100644
--- a/user-guide/configs.html
+++ b/user-guide/configs.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/crate-configuration.html
b/user-guide/crate-configuration.html
index c53fbaa359..e82da3d5dc 100644
--- a/user-guide/crate-configuration.html
+++ b/user-guide/crate-configuration.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/dataframe.html b/user-guide/dataframe.html
index 1e87d5180e..1dd4ec964e 100644
--- a/user-guide/dataframe.html
+++ b/user-guide/dataframe.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index 3ed12327e9..13800901ef 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/explain-usage.html b/user-guide/explain-usage.html
index fb79ed87a2..e294dde705 100644
--- a/user-guide/explain-usage.html
+++ b/user-guide/explain-usage.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 3373e7deae..a61e0b2ed2 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/faq.html b/user-guide/faq.html
index 82869fb02d..10f17f455b 100644
--- a/user-guide/faq.html
+++ b/user-guide/faq.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/introduction.html b/user-guide/introduction.html
index de7155b757..25d15c80e0 100644
--- a/user-guide/introduction.html
+++ b/user-guide/introduction.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql/window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 0fd4c5f2b5..4efebe1764 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index 21585cb665..1b2b110ebb 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index b9bde76957..4db46dca4f 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/dml.html b/user-guide/sql/dml.html
index 20b2070055..8c309ef317 100644
--- a/user-guide/sql/dml.html
+++ b/user-guide/sql/dml.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index b0c890ae85..30be93cb27 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index ebff93d394..64517debe8 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
@@ -606,14 +601,8 @@
<li class="toctree-l1"><a class="reference internal"
href="window_functions.html">Window Functions</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#syntax">Syntax</a></li>
<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#aggregate-functions">Aggregate functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#analytical-functions">Analytical functions</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="window_functions_new.html">Window Functions (NEW)</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#syntax">Syntax</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#aggregate-functions">Aggregate
functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#ranking-functions">Ranking Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#analytical-functions">Analytical
Functions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#ranking-functions">Ranking Functions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#analytical-functions">Analytical Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal"
href="scalar_functions.html">Scalar Functions</a><ul>
diff --git a/user-guide/sql/information_schema.html
b/user-guide/sql/information_schema.html
index 57ccf4c481..05560972b6 100644
--- a/user-guide/sql/information_schema.html
+++ b/user-guide/sql/information_schema.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index 3e8253bc03..969c3b3624 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 2488084a1c..58435f7c41 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -35,7 +35,7 @@
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
<link rel="next" title="Special Functions" href="special_functions.html" />
- <link rel="prev" title="Window Functions (NEW)"
href="window_functions_new.html" />
+ <link rel="prev" title="Window Functions" href="window_functions.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2 current active">
<a class="current reference internal" href="#">
Scalar Functions
@@ -9026,11 +9021,11 @@ syntax such as <code class="docutils literal
notranslate"><span class="pre">my_s
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="window_functions_new.html"
title="previous page">
+ <a class='left-prev' id="prev-link" href="window_functions.html"
title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">Window Functions (NEW)</p>
+ <p class="prev-next-title">Window Functions</p>
</div>
</a>
<a class='right-next' id="next-link" href="special_functions.html"
title="next page">
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index eb95e5d8bf..e136b67043 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/special_functions.html
b/user-guide/sql/special_functions.html
index 08179bcfea..bcdb2bb68d 100644
--- a/user-guide/sql/special_functions.html
+++ b/user-guide/sql/special_functions.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/sql_status.html b/user-guide/sql/sql_status.html
index f24f2db85c..2109106665 100644
--- a/user-guide/sql/sql_status.html
+++ b/user-guide/sql/sql_status.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/subqueries.html b/user-guide/sql/subqueries.html
index 50dd71f6f4..c12df51457 100644
--- a/user-guide/sql/subqueries.html
+++ b/user-guide/sql/subqueries.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index a88e1824e4..3183e1e707 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -34,7 +34,7 @@
<script async="true" defer="true"
src="https://buttons.github.io/buttons.js";></script>
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="Window Functions (NEW)"
href="window_functions_new.html" />
+ <link rel="next" title="Scalar Functions" href="scalar_functions.html" />
<link rel="prev" title="Aggregate Functions"
href="aggregate_functions.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
@@ -518,9 +513,77 @@
Aggregate functions
</a>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#ranking-functions">
+ Ranking Functions
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#cume-dist">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ cume_dist
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#dense-rank">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ dense_rank
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#ntile">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ ntile
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#arguments">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#percent-rank">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ percent_rank
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#rank">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ rank
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#row-number">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ row_number
+ </span>
+ </code>
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#analytical-functions">
- Analytical functions
+ Analytical Functions
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
@@ -533,7 +596,23 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#arguments">
+ <a class="reference internal nav-link" href="#id1">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#lag">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ lag
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id2">
Arguments
</a>
</li>
@@ -549,7 +628,23 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
+ <a class="reference internal nav-link" href="#id3">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#lead">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ lead
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id4">
Arguments
</a>
</li>
@@ -565,7 +660,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
+ <a class="reference internal nav-link" href="#id5">
Arguments
</a>
</li>
@@ -615,17 +710,23 @@
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- KIND, either expressioness or implied. See the License for the
+ KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
+<!---
+This file was generated by the dev/update_function_docs.sh script.
+Do not edit it manually as changes will be overwritten.
+Instead, edit the WindowUDFImpl's documentation() function to
+update documentation for an individual UDF or the
+dev/update_function_docs.sh file for updating surrounding text.
+-->
<section id="window-functions">
<h1>Window Functions<a class="headerlink" href="#window-functions" title="Link
to this heading">¶</a></h1>
-<p>A <em>window function</em> performs a calculation across a set of table
rows that are somehow related to the current row.</p>
-<p>Note: this documentation is in the process of being migrated to be <a
class="reference external"
href="https://github.com/apache/datafusion/issues/12740";>automatically created
from the codebase</a>.
-Please see the <a class="reference internal"
href="window_functions_new.html"><span class="std std-doc">Window Functions
(new)</span></a> page for
-the rest of the documentation.</p>
-<p>Window functions are comparable to the type of calculation that can be done
with an aggregate function. However, window functions do not cause rows to
become grouped into a single output row like non-window aggregate calls would.
Instead, the rows retain their separate identities. Behind the scenes, the
window function is able to access more than just the current row of the query
result</p>
+<p>A <em>window function</em> performs a calculation across a set of table
rows that are somehow related to the current row.
+This is comparable to the type of calculation that can be done with an
aggregate function.
+However, window functions do not cause rows to become grouped into a single
output row like non-window aggregate calls would.
+Instead, the rows retain their separate identities. Behind the scenes, the
window function is able to access more than just the current row of the query
result</p>
<p>Here is an example that shows how to compare each employee’s salary with
the average salary in his or her department:</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">depname</span><span class="p">,</span><span
class="w"> </span><span class="n">empno</span><span class="p">,</span><span
class="w"> </span><span class="n">salary</span><span class="p">,</span><span
class="w"> </span><span class="k">avg</span><span class="p">(</span><span
class="n">salary</span><span class="p">)</span><span class="w"> </span>< [...]
@@ -727,50 +828,141 @@ the rest of the documentation.</p>
<h2>Aggregate functions<a class="headerlink" href="#aggregate-functions"
title="Link to this heading">¶</a></h2>
<p>All <a class="reference internal" href="aggregate_functions.html"><span
class="std std-doc">aggregate functions</span></a> can be used as window
functions.</p>
</section>
+<section id="ranking-functions">
+<h2>Ranking Functions<a class="headerlink" href="#ranking-functions"
title="Link to this heading">¶</a></h2>
+<ul class="simple">
+<li><p><a class="reference internal" href="#cume-dist">cume_dist</a></p></li>
+<li><p><a class="reference internal" href="#dense-rank">dense_rank</a></p></li>
+<li><p><a class="reference internal" href="#ntile">ntile</a></p></li>
+<li><p><a class="reference internal"
href="#percent-rank">percent_rank</a></p></li>
+<li><p><a class="reference internal" href="#rank">rank</a></p></li>
+<li><p><a class="reference internal" href="#row-number">row_number</a></p></li>
+</ul>
+<section id="cume-dist">
+<h3><code class="docutils literal notranslate"><span
class="pre">cume_dist</span></code><a class="headerlink" href="#cume-dist"
title="Link to this heading">¶</a></h3>
+<p>Relative rank of the current row: (number of rows preceding or peer with
current row) / (total rows).</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">cume_dist</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
+<section id="dense-rank">
+<h3><code class="docutils literal notranslate"><span
class="pre">dense_rank</span></code><a class="headerlink" href="#dense-rank"
title="Link to this heading">¶</a></h3>
+<p>Returns the rank of the current row without gaps. This function ranks rows
in a dense manner, meaning consecutive ranks are assigned even for identical
values.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">dense_rank</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
+<section id="ntile">
+<h3><code class="docutils literal notranslate"><span
class="pre">ntile</span></code><a class="headerlink" href="#ntile" title="Link
to this heading">¶</a></h3>
+<p>Integer ranging from 1 to the argument value, dividing the partition as
equally as possible</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">ntile</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="arguments">
+<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: An integer describing the number groups
the partition should be split into</p></li>
+</ul>
+</section>
+</section>
+<section id="percent-rank">
+<h3><code class="docutils literal notranslate"><span
class="pre">percent_rank</span></code><a class="headerlink"
href="#percent-rank" title="Link to this heading">¶</a></h3>
+<p>Returns the percentage rank of the current row within its partition. The
value ranges from 0 to 1 and is computed as <code class="docutils literal
notranslate"><span class="pre">(rank</span> <span class="pre">-</span> <span
class="pre">1)</span> <span class="pre">/</span> <span
class="pre">(total_rows</span> <span class="pre">-</span> <span
class="pre">1)</span></code>.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">percent_rank</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
+<section id="rank">
+<h3><code class="docutils literal notranslate"><span
class="pre">rank</span></code><a class="headerlink" href="#rank" title="Link to
this heading">¶</a></h3>
+<p>Returns the rank of the current row within its partition, allowing gaps
between ranks. This function provides a ranking similar to <code
class="docutils literal notranslate"><span
class="pre">row_number</span></code>, but skips ranks for identical values.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">rank</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
+<section id="row-number">
+<h3><code class="docutils literal notranslate"><span
class="pre">row_number</span></code><a class="headerlink" href="#row-number"
title="Link to this heading">¶</a></h3>
+<p>Number of the current row within its partition, counting from 1.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">row_number</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
+</section>
<section id="analytical-functions">
-<h2>Analytical functions<a class="headerlink" href="#analytical-functions"
title="Link to this heading">¶</a></h2>
+<h2>Analytical Functions<a class="headerlink" href="#analytical-functions"
title="Link to this heading">¶</a></h2>
<ul class="simple">
<li><p><a class="reference internal"
href="#first-value">first_value</a></p></li>
+<li><p><a class="reference internal" href="#lag">lag</a></p></li>
<li><p><a class="reference internal" href="#last-value">last_value</a></p></li>
+<li><p><a class="reference internal" href="#lead">lead</a></p></li>
<li><p><a class="reference internal" href="#nth-value">nth_value</a></p></li>
</ul>
<section id="first-value">
<h3><code class="docutils literal notranslate"><span
class="pre">first_value</span></code><a class="headerlink" href="#first-value"
title="Link to this heading">¶</a></h3>
<p>Returns value evaluated at the row that is the first row of the window
frame.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">first_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">first_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="arguments">
-<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">¶</a></h4>
+<section id="id1">
+<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on</p></li>
+</ul>
+</section>
+</section>
+<section id="lag">
+<h3><code class="docutils literal notranslate"><span
class="pre">lag</span></code><a class="headerlink" href="#lag" title="Link to
this heading">¶</a></h3>
+<p>Returns value evaluated at the row that is offset rows before the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value).</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lag</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">offset</span><span class="p">,</span> <span
class="n">default</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id2">
+<h4>Arguments<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on</p></li>
+<li><p><strong>offset</strong>: Integer. Specifies how many rows back the
value of expression should be retrieved. Defaults to 1.</p></li>
+<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as expression.</p></li>
</ul>
</section>
</section>
<section id="last-value">
<h3><code class="docutils literal notranslate"><span
class="pre">last_value</span></code><a class="headerlink" href="#last-value"
title="Link to this heading">¶</a></h3>
<p>Returns value evaluated at the row that is the last row of the window
frame.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">last_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">last_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
+<section id="id3">
+<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on</p></li>
</ul>
</section>
</section>
+<section id="lead">
+<h3><code class="docutils literal notranslate"><span
class="pre">lead</span></code><a class="headerlink" href="#lead" title="Link to
this heading">¶</a></h3>
+<p>Returns value evaluated at the row that is offset rows after the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value).</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lead</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">offset</span><span class="p">,</span> <span
class="n">default</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id4">
+<h4>Arguments<a class="headerlink" href="#id4" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on</p></li>
+<li><p><strong>offset</strong>: Integer. Specifies how many rows forward the
value of expression should be retrieved. Defaults to 1.</p></li>
+<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as expression.</p></li>
+</ul>
+</section>
+</section>
<section id="nth-value">
<h3><code class="docutils literal notranslate"><span
class="pre">nth_value</span></code><a class="headerlink" href="#nth-value"
title="Link to this heading">¶</a></h3>
<p>Returns value evaluated at the row that is the nth row of the window frame
(counting from 1); null if no such row.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">nth_value</span><span
class="p">(</span><span class="n">expression</span><span
class="p">,</span><span class="w"> </span><span class="n">n</span><span
class="p">)</span>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">nth_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id2">
-<h4>Arguments<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
+<section id="id5">
+<h4>Arguments<a class="headerlink" href="#id5" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The name the column of which nth value to
retrieve</p></li>
-<li><p><strong>n</strong>: Integer. Specifies the <em>n</em> in nth</p></li>
+<li><p><strong>n</strong>: Integer. Specifies the n in nth</p></li>
</ul>
</section>
</section>
@@ -790,10 +982,10 @@ the rest of the documentation.</p>
<p class="prev-next-title">Aggregate Functions</p>
</div>
</a>
- <a class='right-next' id="next-link" href="window_functions_new.html"
title="next page">
+ <a class='right-next' id="next-link" href="scalar_functions.html"
title="next page">
<div class="prev-next-info">
<p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">Window Functions (NEW)</p>
+ <p class="prev-next-title">Scalar Functions</p>
</div>
<i class="fas fa-angle-right"></i>
</a>
diff --git a/user-guide/sql/window_functions_new.html
b/user-guide/sql/window_functions_new.html
deleted file mode 100644
index 7a42bca471..0000000000
--- a/user-guide/sql/window_functions_new.html
+++ /dev/null
@@ -1,1035 +0,0 @@
-<!DOCTYPE html>
-
-<html lang="en" data-content_root="../../">
- <head>
- <meta charset="utf-8" />
- <meta name="viewport" content="width=device-width, initial-scale=1.0"
/><meta name="viewport" content="width=device-width, initial-scale=1" />
-
- <title>Window Functions (NEW) — Apache DataFusion
documentation</title>
-
- <link href="../../_static/styles/theme.css?digest=1999514e3f237ded88cf"
rel="stylesheet">
-<link
href="../../_static/styles/pydata-sphinx-theme.css?digest=1999514e3f237ded88cf"
rel="stylesheet">
-
-
- <link rel="stylesheet"
- href="../../_static/vendor/fontawesome/5.13.0/css/all.min.css">
- <link rel="preload" as="font" type="font/woff2" crossorigin
-
href="../../_static/vendor/fontawesome/5.13.0/webfonts/fa-solid-900.woff2">
- <link rel="preload" as="font" type="font/woff2" crossorigin
-
href="../../_static/vendor/fontawesome/5.13.0/webfonts/fa-brands-400.woff2">
-
-
-
-
-
- <link rel="stylesheet" type="text/css"
href="../../_static/pygments.css?v=a746c00c" />
- <link rel="stylesheet" type="text/css"
href="../../_static/styles/pydata-sphinx-theme.css?v=1140d252" />
- <link rel="stylesheet" type="text/css"
href="../../_static/theme_overrides.css?v=c6d785ac" />
-
- <link rel="preload" as="script"
href="../../_static/scripts/pydata-sphinx-theme.js?digest=1999514e3f237ded88cf">
-
- <script src="../../_static/documentation_options.js?v=8a448e45"></script>
- <script src="../../_static/doctools.js?v=9bcbadda"></script>
- <script src="../../_static/sphinx_highlight.js?v=dc90522c"></script>
- <script async="true" defer="true"
src="https://buttons.github.io/buttons.js";></script>
- <link rel="index" title="Index" href="../../genindex.html" />
- <link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="Scalar Functions" href="scalar_functions.html" />
- <link rel="prev" title="Window Functions" href="window_functions.html" />
- <meta name="viewport" content="width=device-width, initial-scale=1" />
- <meta name="docsearch:language" content="en">
-
-
- <!-- Google Analytics -->
-
- </head>
- <body data-spy="scroll" data-target="#bd-toc-nav" data-offset="80">
-
- <div class="container-fluid" id="banner"></div>
-
-
-
-
- <div class="container-xl">
- <div class="row">
-
-
- <!-- Only show if we have sidebars configured, else just a small
margin -->
- <div class="col-12 col-md-3 bd-sidebar">
- <div class="sidebar-start-items">
-
-<form class="bd-search d-flex align-items-center" action="../../search.html"
method="get">
- <i class="icon fas fa-search"></i>
- <input type="search" class="form-control" name="q" id="search-input"
placeholder="Search the docs ..." aria-label="Search the docs ..."
autocomplete="off" >
-</form>
-
-<nav class="bd-links" id="bd-docs-nav" aria-label="Main navigation">
- <div class="bd-toc-item active">
-
- <p aria-level="2" class="caption" role="heading">
- <span class="caption-text">
- ASF Links
- </span>
-</p>
-<ul class="nav bd-sidenav">
- <li class="toctree-l1">
- <a class="reference external" href="https://apache.org";>
- Apache Software Foundation
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external" href="https://www.apache.org/licenses/";>
- License
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external"
href="https://www.apache.org/foundation/sponsorship.html";>
- Donate
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external"
href="https://www.apache.org/foundation/thanks.html";>
- Thanks
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external" href="https://www.apache.org/security/";>
- Security
- </a>
- </li>
-</ul>
-<p aria-level="2" class="caption" role="heading">
- <span class="caption-text">
- Links
- </span>
-</p>
-<ul class="nav bd-sidenav">
- <li class="toctree-l1">
- <a class="reference external" href="https://github.com/apache/datafusion";>
- GitHub and Issue Tracker
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external" href="https://crates.io/crates/datafusion";>
- crates.io
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external"
href="https://docs.rs/datafusion/latest/datafusion/";>
- API Docs
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external" href="https://datafusion.apache.org/blog/";>
- Blog
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external"
href="https://github.com/apache/datafusion/blob/main/CODE_OF_CONDUCT.md";>
- Code of conduct
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../download.html">
- Download
- </a>
- </li>
-</ul>
-<p aria-level="2" class="caption" role="heading">
- <span class="caption-text">
- User Guide
- </span>
-</p>
-<ul class="current nav bd-sidenav">
- <li class="toctree-l1">
- <a class="reference internal" href="../introduction.html">
- Introduction
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../example-usage.html">
- Example Usage
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../concepts-readings-events.html">
- Concepts, Readings, Events
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../crate-configuration.html">
- Crate Configuration
- </a>
- </li>
- <li class="toctree-l1 has-children">
- <a class="reference internal" href="../cli/index.html">
- DataFusion CLI
- </a>
- <input class="toctree-checkbox" id="toctree-checkbox-1"
name="toctree-checkbox-1" type="checkbox"/>
- <label for="toctree-checkbox-1">
- <i class="fas fa-chevron-down">
- </i>
- </label>
- <ul>
- <li class="toctree-l2">
- <a class="reference internal" href="../cli/overview.html">
- Overview
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="../cli/installation.html">
- Installation
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="../cli/usage.html">
- Usage
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="../cli/datasources.html">
- Local Files / Directories
- </a>
- </li>
- </ul>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../dataframe.html">
- DataFrame API
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../expressions.html">
- Expression API
- </a>
- </li>
- <li class="toctree-l1 current active has-children">
- <a class="reference internal" href="index.html">
- SQL Reference
- </a>
- <input checked="" class="toctree-checkbox" id="toctree-checkbox-2"
name="toctree-checkbox-2" type="checkbox"/>
- <label for="toctree-checkbox-2">
- <i class="fas fa-chevron-down">
- </i>
- </label>
- <ul class="current">
- <li class="toctree-l2">
- <a class="reference internal" href="data_types.html">
- Data Types
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="select.html">
- SELECT syntax
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="subqueries.html">
- Subqueries
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="ddl.html">
- DDL
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="dml.html">
- DML
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="explain.html">
- EXPLAIN
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="information_schema.html">
- Information Schema
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="operators.html">
- Operators
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="aggregate_functions.html">
- Aggregate Functions
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions.html">
- Window Functions
- </a>
- </li>
- <li class="toctree-l2 current active">
- <a class="current reference internal" href="#">
- Window Functions (NEW)
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="scalar_functions.html">
- Scalar Functions
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="special_functions.html">
- Special Functions
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="sql_status.html">
- Status
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal" href="write_options.html">
- Write Options
- </a>
- </li>
- </ul>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../configs.html">
- Configuration Settings
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../explain-usage.html">
- Reading Explain Plans
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../faq.html">
- Frequently Asked Questions
- </a>
- </li>
-</ul>
-<p aria-level="2" class="caption" role="heading">
- <span class="caption-text">
- Library User Guide
- </span>
-</p>
-<ul class="nav bd-sidenav">
- <li class="toctree-l1">
- <a class="reference internal" href="../../library-user-guide/index.html">
- Introduction
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/extensions.html">
- Extensions List
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/using-the-sql-api.html">
- Using the SQL API
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/working-with-exprs.html">
- Working with
- <code class="docutils literal notranslate">
- <span class="pre">
- Expr
- </span>
- </code>
- s
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/using-the-dataframe-api.html">
- Using the DataFrame API
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/building-logical-plans.html">
- Building Logical Plans
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../library-user-guide/catalogs.html">
- Catalogs, Schemas, and Tables
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/adding-udfs.html">
- Adding User Defined Functions: Scalar/Window/Aggregate/Table Functions
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/custom-table-providers.html">
- Custom Table Provider
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/extending-operators.html">
- Extending DataFusion’s operators: custom LogicalPlan and Execution Plans
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../library-user-guide/profiling.html">
- Profiling Cookbook
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/query-optimizer.html">
- DataFusion Query Optimizer
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../library-user-guide/api-health.html">
- API health policy
- </a>
- </li>
-</ul>
-<p aria-level="2" class="caption" role="heading">
- <span class="caption-text">
- Contributor Guide
- </span>
-</p>
-<ul class="nav bd-sidenav">
- <li class="toctree-l1">
- <a class="reference internal" href="../../contributor-guide/index.html">
- Introduction
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../contributor-guide/communication.html">
- Communication
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../contributor-guide/getting_started.html">
- Getting Started
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal"
href="../../contributor-guide/architecture.html">
- Architecture
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../contributor-guide/testing.html">
- Testing
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../contributor-guide/howtos.html">
- HOWTOs
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../contributor-guide/roadmap.html">
- Roadmap
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../contributor-guide/governance.html">
- Governance
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference internal" href="../../contributor-guide/inviting.html">
- Inviting New Committers and PMC Members
- </a>
- </li>
- <li class="toctree-l1 has-children">
- <a class="reference internal"
href="../../contributor-guide/specification/index.html">
- Specifications
- </a>
- <input class="toctree-checkbox" id="toctree-checkbox-3"
name="toctree-checkbox-3" type="checkbox"/>
- <label for="toctree-checkbox-3">
- <i class="fas fa-chevron-down">
- </i>
- </label>
- <ul>
- <li class="toctree-l2">
- <a class="reference internal"
href="../../contributor-guide/specification/invariants.html">
- Invariants
- </a>
- </li>
- <li class="toctree-l2">
- <a class="reference internal"
href="../../contributor-guide/specification/output-field-name-semantic.html">
- Output field name semantics
- </a>
- </li>
- </ul>
- </li>
-</ul>
-<p aria-level="2" class="caption" role="heading">
- <span class="caption-text">
- DataFusion Subprojects
- </span>
-</p>
-<ul class="nav bd-sidenav">
- <li class="toctree-l1">
- <a class="reference external" href="https://arrow.apache.org/ballista/";>
- DataFusion Ballista
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external" href="https://datafusion.apache.org/comet/";>
- DataFusion Comet
- </a>
- </li>
- <li class="toctree-l1">
- <a class="reference external" href="https://datafusion.apache.org/python/";>
- DataFusion Python
- </a>
- </li>
-</ul>
-
-
- </div>
-
- <a class="navbar-brand" href="../../index.html">
- <img src="../../_static/images/2x_bgwhite_original.png" class="logo"
alt="logo">
- </a>
-</nav>
-
- </div>
- <div class="sidebar-end-items">
- </div>
- </div>
-
-
-
-
- <div class="d-none d-xl-block col-xl-2 bd-toc">
-
-
- <div class="toc-item">
-
-<div class="tocsection onthispage pt-5 pb-3">
- <i class="fas fa-list"></i> On this page
-</div>
-
-<nav id="bd-toc-nav">
- <ul class="visible nav section-nav flex-column">
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#syntax">
- Syntax
- </a>
- </li>
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#aggregate-functions">
- Aggregate functions
- </a>
- </li>
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#ranking-functions">
- Ranking Functions
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#cume-dist">
- <code class="docutils literal notranslate">
- <span class="pre">
- cume_dist
- </span>
- </code>
- </a>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#dense-rank">
- <code class="docutils literal notranslate">
- <span class="pre">
- dense_rank
- </span>
- </code>
- </a>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#ntile">
- <code class="docutils literal notranslate">
- <span class="pre">
- ntile
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#arguments">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#percent-rank">
- <code class="docutils literal notranslate">
- <span class="pre">
- percent_rank
- </span>
- </code>
- </a>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#rank">
- <code class="docutils literal notranslate">
- <span class="pre">
- rank
- </span>
- </code>
- </a>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#row-number">
- <code class="docutils literal notranslate">
- <span class="pre">
- row_number
- </span>
- </code>
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#analytical-functions">
- Analytical Functions
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#first-value">
- <code class="docutils literal notranslate">
- <span class="pre">
- first_value
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#lag">
- <code class="docutils literal notranslate">
- <span class="pre">
- lag
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#last-value">
- <code class="docutils literal notranslate">
- <span class="pre">
- last_value
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id3">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#lead">
- <code class="docutils literal notranslate">
- <span class="pre">
- lead
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id4">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#nth-value">
- <code class="docutils literal notranslate">
- <span class="pre">
- nth_value
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id5">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- </ul>
- </li>
-</ul>
-
-</nav>
- </div>
-
- <div class="toc-item">
-
-
-<div class="tocsection editthispage">
- <a
href="https://github.com/apache/arrow-datafusion/edit/main/docs/source/user-guide/sql/window_functions_new.md";>
- <i class="fas fa-pencil-alt"></i> Edit this page
- </a>
-</div>
-
- </div>
-
-
- </div>
-
-
-
-
-
-
- <main class="col-12 col-md-9 col-xl-7 py-md-5 pl-md-5 pr-md-4
bd-content" role="main">
-
- <div>
-
- <!---
- Licensed to the Apache Software Foundation (ASF) under one
- or more contributor license agreements. See the NOTICE file
- distributed with this work for additional information
- regarding copyright ownership. The ASF licenses this file
- to you under the Apache License, Version 2.0 (the
- "License"); you may not use this file except in compliance
- with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
- Unless required by applicable law or agreed to in writing,
- software distributed under the License is distributed on an
- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- KIND, either express or implied. See the License for the
- specific language governing permissions and limitations
- under the License.
--->
-<!---
-This file was generated by the dev/update_function_docs.sh script.
-Do not edit it manually as changes will be overwritten.
-Instead, edit the WindowUDFImpl's documentation() function to
-update documentation for an individual UDF or the
-dev/update_function_docs.sh file for updating surrounding text.
--->
-<section id="window-functions-new">
-<h1>Window Functions (NEW)<a class="headerlink" href="#window-functions-new"
title="Link to this heading">¶</a></h1>
-<p>Note: this documentation is in the process of being migrated to be <a
class="reference external"
href="https://github.com/apache/datafusion/issues/12740";>automatically created
from the codebase</a>.
-Please see the <a class="reference internal"
href="window_functions.html"><span class="std std-doc">Window Functions
(Old)</span></a> page for
-the rest of the documentation.</p>
-<p>A <em>window function</em> performs a calculation across a set of table
rows that are somehow related to the current row.
-This is comparable to the type of calculation that can be done with an
aggregate function.
-However, window functions do not cause rows to become grouped into a single
output row like non-window aggregate calls would.
-Instead, the rows retain their separate identities. Behind the scenes, the
window function is able to access more than just the current row of the query
result</p>
-<p>Here is an example that shows how to compare each employee’s salary with
the average salary in his or her department:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">depname</span><span class="p">,</span><span
class="w"> </span><span class="n">empno</span><span class="p">,</span><span
class="w"> </span><span class="n">salary</span><span class="p">,</span><span
class="w"> </span><span class="k">avg</span><span class="p">(</span><span
class="n">salary</span><span class="p">)</span><span class="w"> </span>< [...]
-
-<span class="o">+</span><span
class="c1">-----------+-------+--------+-------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">depname</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="n">empno</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">salary</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="k">avg</span><span class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------+-------+--------+-------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">personnel</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">2</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">3900</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">3700</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">personnel</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">5</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">3500</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">3700</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">8</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">6000</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5020</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">10</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5020</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">11</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5020</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">9</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4500</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5020</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">7</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5020</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">1</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5000</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4866</span><span class="p">.</span><span
class="mi">666666666667</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">4</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4800</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4866</span><span class="p">.</span><span
class="mi">666666666667</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">3</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4800</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4866</span><span class="p">.</span><span
class="mi">666666666667</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------+-------+--------+-------------------+</span>
-</pre></div>
-</div>
-<p>A window function call always contains an OVER clause directly following
the window function’s name and argument(s). This is what syntactically
distinguishes it from a normal function or non-window aggregate. The OVER
clause determines exactly how the rows of the query are split up for processing
by the window function. The PARTITION BY clause within OVER divides the rows
into groups, or partitions, that share the same values of the PARTITION BY
expression(s). For each row, the window [...]
-<p>You can also control the order in which rows are processed by window
functions using ORDER BY within OVER. (The window ORDER BY does not even have
to match the order in which the rows are output.) Here is an example:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">depname</span><span class="p">,</span><span
class="w"> </span><span class="n">empno</span><span class="p">,</span><span
class="w"> </span><span class="n">salary</span><span class="p">,</span>
-<span class="w"> </span><span class="n">rank</span><span
class="p">()</span><span class="w"> </span><span class="n">OVER</span><span
class="w"> </span><span class="p">(</span><span class="n">PARTITION</span><span
class="w"> </span><span class="k">BY</span><span class="w"> </span><span
class="n">depname</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">salary</span><span class="w"> </spa [...]
-<span class="k">FROM</span><span class="w"> </span><span
class="n">empsalary</span><span class="p">;</span>
-
-<span class="o">+</span><span
class="c1">-----------+-------+--------+--------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">depname</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="n">empno</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">salary</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="n">rank</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------+-------+--------+--------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">personnel</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">2</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">3900</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">1</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">8</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">6000</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">1</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">10</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">2</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">11</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">2</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">9</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4500</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">7</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">1</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5000</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">1</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">4</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4800</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">2</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">personnel</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">5</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">3500</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">2</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">3</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4800</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">2</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------+-------+--------+--------+</span>
-</pre></div>
-</div>
-<p>There is another important concept associated with window functions: for
each row, there is a set of rows within its partition called its window frame.
Some window functions act only on the rows of the window frame, rather than of
the whole partition. Here is an example of using window frames in queries:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">depname</span><span class="p">,</span><span
class="w"> </span><span class="n">empno</span><span class="p">,</span><span
class="w"> </span><span class="n">salary</span><span class="p">,</span>
-<span class="w"> </span><span class="k">avg</span><span
class="p">(</span><span class="n">salary</span><span class="p">)</span><span
class="w"> </span><span class="n">OVER</span><span class="p">(</span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">salary</span><span class="w"> </span><span
class="k">ASC</span><span class="w"> </span><span class="k">ROWS</span><span
class="w"> </span><span class="k">BETWEEN</span><s [...]
-<span class="w"> </span><span class="k">min</span><span
class="p">(</span><span class="n">salary</span><span class="p">)</span><span
class="w"> </span><span class="n">OVER</span><span class="p">(</span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">empno</span><span class="w"> </span><span
class="k">ASC</span><span class="w"> </span><span class="k">ROWS</span><span
class="w"> </span><span class="k">BETWEEN</span><sp [...]
-<span class="k">FROM</span><span class="w"> </span><span
class="n">empsalary</span>
-<span class="k">ORDER</span><span class="w"> </span><span
class="k">BY</span><span class="w"> </span><span class="n">empno</span><span
class="w"> </span><span class="k">ASC</span><span class="p">;</span>
-
-<span class="o">+</span><span
class="c1">-----------+-------+--------+--------------------+---------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">depname</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="n">empno</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">salary</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="k">avg</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">cum_min</s [...]
-<span class="o">+</span><span
class="c1">-----------+-------+--------+--------------------+---------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">1</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5000</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5000</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span> [...]
-<span class="o">|</span><span class="w"> </span><span
class="n">personnel</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">2</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">3900</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">3866</span><span class="p">.</span><span
class="mi">6666666666665</span><span class="w"> </span><span class="o">|</span>
[...]
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">3</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4800</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4700</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span> [...]
-<span class="o">|</span><span class="w"> </span><span
class="n">sales</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">4</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4800</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4866</span><span class="p">.</span><span
class="mi">666666666667</span><span class="w"> </span><span class="o">|</span>
[...]
-<span class="o">|</span><span class="w"> </span><span
class="n">personnel</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">5</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">3500</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">3700</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span> [...]
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">7</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4200</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span> [...]
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">8</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">6000</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5600</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span> [...]
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">9</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">4500</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">4500</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span> [...]
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">10</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5133</span><span class="p">.</span><span
class="mi">333333333333</span><span class="w"> </span><span class="o">|</span>
[...]
-<span class="o">|</span><span class="w"> </span><span
class="n">develop</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">11</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">5200</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="mi">5466</span><span class="p">.</span><span
class="mi">666666666667</span><span class="w"> </span><span class="o">|</span>
[...]
-<span class="o">+</span><span
class="c1">-----------+-------+--------+--------------------+---------+</span>
-</pre></div>
-</div>
-<p>When a query involves multiple window functions, it is possible to write
out each one with a separate OVER clause, but this is duplicative and
error-prone if the same windowing behavior is wanted for several functions.
Instead, each windowing behavior can be named in a WINDOW clause and then
referenced in OVER. For example:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="k">sum</span><span class="p">(</span><span
class="n">salary</span><span class="p">)</span><span class="w"> </span><span
class="n">OVER</span><span class="w"> </span><span class="n">w</span><span
class="p">,</span><span class="w"> </span><span class="k">avg</span><span
class="p">(</span><span class="n">salary</span><span class="p">)</span><span
[...]
-<span class="k">FROM</span><span class="w"> </span><span
class="n">empsalary</span>
-<span class="n">WINDOW</span><span class="w"> </span><span
class="n">w</span><span class="w"> </span><span class="k">AS</span><span
class="w"> </span><span class="p">(</span><span class="n">PARTITION</span><span
class="w"> </span><span class="k">BY</span><span class="w"> </span><span
class="n">depname</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">salary</span><span class="w"> </span><span
[...]
-</pre></div>
-</div>
-<section id="syntax">
-<h2>Syntax<a class="headerlink" href="#syntax" title="Link to this
heading">¶</a></h2>
-<p>The syntax for the OVER-clause is</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>function([expr])
- OVER(
- [PARTITION BY expr[, …]]
- [ORDER BY expr [ ASC | DESC ][, …]]
- [ frame_clause ]
- )
-</pre></div>
-</div>
-<p>where <strong>frame_clause</strong> is one of:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span> <span class="p">{</span> <span
class="n">RANGE</span> <span class="o">|</span> <span class="n">ROWS</span>
<span class="o">|</span> <span class="n">GROUPS</span> <span class="p">}</span>
<span class="n">frame_start</span>
- <span class="p">{</span> <span class="n">RANGE</span> <span
class="o">|</span> <span class="n">ROWS</span> <span class="o">|</span> <span
class="n">GROUPS</span> <span class="p">}</span> <span class="n">BETWEEN</span>
<span class="n">frame_start</span> <span class="n">AND</span> <span
class="n">frame_end</span>
-</pre></div>
-</div>
-<p>and <strong>frame_start</strong> and <strong>frame_end</strong> can be one
of</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">UNBOUNDED</span><span
class="w"> </span><span class="n">PRECEDING</span>
-<span class="k">offset</span><span class="w"> </span><span
class="n">PRECEDING</span>
-<span class="k">CURRENT</span><span class="w"> </span><span
class="k">ROW</span>
-<span class="k">offset</span><span class="w"> </span><span
class="n">FOLLOWING</span>
-<span class="n">UNBOUNDED</span><span class="w"> </span><span
class="n">FOLLOWING</span>
-</pre></div>
-</div>
-<p>where <strong>offset</strong> is an non-negative integer.</p>
-<p>RANGE and GROUPS modes require an ORDER BY clause (with RANGE the ORDER BY
must specify exactly one column).</p>
-</section>
-<section id="aggregate-functions">
-<h2>Aggregate functions<a class="headerlink" href="#aggregate-functions"
title="Link to this heading">¶</a></h2>
-<p>All <a class="reference internal" href="aggregate_functions.html"><span
class="std std-doc">aggregate functions</span></a> can be used as window
functions.</p>
-</section>
-<section id="ranking-functions">
-<h2>Ranking Functions<a class="headerlink" href="#ranking-functions"
title="Link to this heading">¶</a></h2>
-<ul class="simple">
-<li><p><a class="reference internal" href="#cume-dist">cume_dist</a></p></li>
-<li><p><a class="reference internal" href="#dense-rank">dense_rank</a></p></li>
-<li><p><a class="reference internal" href="#ntile">ntile</a></p></li>
-<li><p><a class="reference internal"
href="#percent-rank">percent_rank</a></p></li>
-<li><p><a class="reference internal" href="#rank">rank</a></p></li>
-<li><p><a class="reference internal" href="#row-number">row_number</a></p></li>
-</ul>
-<section id="cume-dist">
-<h3><code class="docutils literal notranslate"><span
class="pre">cume_dist</span></code><a class="headerlink" href="#cume-dist"
title="Link to this heading">¶</a></h3>
-<p>Relative rank of the current row: (number of rows preceding or peer with
current row) / (total rows).</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">cume_dist</span><span
class="p">()</span>
-</pre></div>
-</div>
-</section>
-<section id="dense-rank">
-<h3><code class="docutils literal notranslate"><span
class="pre">dense_rank</span></code><a class="headerlink" href="#dense-rank"
title="Link to this heading">¶</a></h3>
-<p>Returns the rank of the current row without gaps. This function ranks rows
in a dense manner, meaning consecutive ranks are assigned even for identical
values.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">dense_rank</span><span
class="p">()</span>
-</pre></div>
-</div>
-</section>
-<section id="ntile">
-<h3><code class="docutils literal notranslate"><span
class="pre">ntile</span></code><a class="headerlink" href="#ntile" title="Link
to this heading">¶</a></h3>
-<p>Integer ranging from 1 to the argument value, dividing the partition as
equally as possible</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">ntile</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="arguments">
-<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: An integer describing the number groups
the partition should be split into</p></li>
-</ul>
-</section>
-</section>
-<section id="percent-rank">
-<h3><code class="docutils literal notranslate"><span
class="pre">percent_rank</span></code><a class="headerlink"
href="#percent-rank" title="Link to this heading">¶</a></h3>
-<p>Returns the percentage rank of the current row within its partition. The
value ranges from 0 to 1 and is computed as <code class="docutils literal
notranslate"><span class="pre">(rank</span> <span class="pre">-</span> <span
class="pre">1)</span> <span class="pre">/</span> <span
class="pre">(total_rows</span> <span class="pre">-</span> <span
class="pre">1)</span></code>.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">percent_rank</span><span
class="p">()</span>
-</pre></div>
-</div>
-</section>
-<section id="rank">
-<h3><code class="docutils literal notranslate"><span
class="pre">rank</span></code><a class="headerlink" href="#rank" title="Link to
this heading">¶</a></h3>
-<p>Returns the rank of the current row within its partition, allowing gaps
between ranks. This function provides a ranking similar to <code
class="docutils literal notranslate"><span
class="pre">row_number</span></code>, but skips ranks for identical values.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">rank</span><span
class="p">()</span>
-</pre></div>
-</div>
-</section>
-<section id="row-number">
-<h3><code class="docutils literal notranslate"><span
class="pre">row_number</span></code><a class="headerlink" href="#row-number"
title="Link to this heading">¶</a></h3>
-<p>Number of the current row within its partition, counting from 1.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">row_number</span><span
class="p">()</span>
-</pre></div>
-</div>
-</section>
-</section>
-<section id="analytical-functions">
-<h2>Analytical Functions<a class="headerlink" href="#analytical-functions"
title="Link to this heading">¶</a></h2>
-<ul class="simple">
-<li><p><a class="reference internal"
href="#first-value">first_value</a></p></li>
-<li><p><a class="reference internal" href="#lag">lag</a></p></li>
-<li><p><a class="reference internal" href="#last-value">last_value</a></p></li>
-<li><p><a class="reference internal" href="#lead">lead</a></p></li>
-<li><p><a class="reference internal" href="#nth-value">nth_value</a></p></li>
-</ul>
-<section id="first-value">
-<h3><code class="docutils literal notranslate"><span
class="pre">first_value</span></code><a class="headerlink" href="#first-value"
title="Link to this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is the first row of the window
frame.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">first_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: Expression to operate on</p></li>
-</ul>
-</section>
-</section>
-<section id="lag">
-<h3><code class="docutils literal notranslate"><span
class="pre">lag</span></code><a class="headerlink" href="#lag" title="Link to
this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is offset rows before the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value).</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lag</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">offset</span><span class="p">,</span> <span
class="n">default</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id2">
-<h4>Arguments<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: Expression to operate on</p></li>
-<li><p><strong>offset</strong>: Integer. Specifies how many rows back the
value of expression should be retrieved. Defaults to 1.</p></li>
-<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as expression.</p></li>
-</ul>
-</section>
-</section>
-<section id="last-value">
-<h3><code class="docutils literal notranslate"><span
class="pre">last_value</span></code><a class="headerlink" href="#last-value"
title="Link to this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is the last row of the window
frame.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">last_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id3">
-<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: Expression to operate on</p></li>
-</ul>
-</section>
-</section>
-<section id="lead">
-<h3><code class="docutils literal notranslate"><span
class="pre">lead</span></code><a class="headerlink" href="#lead" title="Link to
this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is offset rows after the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value).</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lead</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">offset</span><span class="p">,</span> <span
class="n">default</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id4">
-<h4>Arguments<a class="headerlink" href="#id4" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: Expression to operate on</p></li>
-<li><p><strong>offset</strong>: Integer. Specifies how many rows forward the
value of expression should be retrieved. Defaults to 1.</p></li>
-<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as expression.</p></li>
-</ul>
-</section>
-</section>
-<section id="nth-value">
-<h3><code class="docutils literal notranslate"><span
class="pre">nth_value</span></code><a class="headerlink" href="#nth-value"
title="Link to this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is the nth row of the window frame
(counting from 1); null if no such row.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">nth_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">n</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id5">
-<h4>Arguments<a class="headerlink" href="#id5" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: The name the column of which nth value to
retrieve</p></li>
-<li><p><strong>n</strong>: Integer. Specifies the n in nth</p></li>
-</ul>
-</section>
-</section>
-</section>
-</section>
-
-
- </div>
-
-
- <!-- Previous / next buttons -->
-<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="window_functions.html"
title="previous page">
- <i class="fas fa-angle-left"></i>
- <div class="prev-next-info">
- <p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">Window Functions</p>
- </div>
- </a>
- <a class='right-next' id="next-link" href="scalar_functions.html"
title="next page">
- <div class="prev-next-info">
- <p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">Scalar Functions</p>
- </div>
- <i class="fas fa-angle-right"></i>
- </a>
-</div>
-
- </main>
-
-
- </div>
- </div>
-
- <script
src="../../_static/scripts/pydata-sphinx-theme.js?digest=1999514e3f237ded88cf"></script>
-
-<!-- Based on pydata_sphinx_theme/footer.html -->
-<footer class="footer mt-5 mt-md-0">
- <div class="container">
-
- <div class="footer-item">
- <p class="copyright">
- © Copyright 2019-2024, Apache Software Foundation.<br>
-</p>
- </div>
-
- <div class="footer-item">
- <p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 8.1.3.<br>
-</p>
- </div>
-
- <div class="footer-item">
- <p>Apache DataFusion, Apache, the Apache feather logo, and the Apache
DataFusion project logo</p>
- <p>are either registered trademarks or trademarks of The Apache Software
Foundation in the United States and other countries.</p>
- </div>
- </div>
-</footer>
-
-
- </body>
-</html>
\ No newline at end of file
diff --git a/user-guide/sql/write_options.html
b/user-guide/sql/write_options.html
index 6fab2fc204..dbeae4111f 100644
--- a/user-guide/sql/write_options.html
+++ b/user-guide/sql/write_options.html
@@ -263,11 +263,6 @@
Window Functions
</a>
</li>
- <li class="toctree-l2">
- <a class="reference internal" href="window_functions_new.html">
- Window Functions (NEW)
- </a>
- </li>
<li class="toctree-l2">
<a class="reference internal" href="scalar_functions.html">
Scalar Functions
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
