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 9a781f6fae Publish built docs triggered by
02b969381db1f3765676029aa47ddf5e54ccdf4f
9a781f6fae is described below
commit 9a781f6fae0da55988b9b7bb521f4fe5e821b944
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Oct 25 13:13:32 2024 +0000
Publish built docs triggered by 02b969381db1f3765676029aa47ddf5e54ccdf4f
---
_sources/user-guide/sql/window_functions.md.txt | 34 --------
.../user-guide/sql/window_functions_new.md.txt | 13 +++
searchindex.js | 2 +-
user-guide/sql/index.html | 1 -
user-guide/sql/window_functions.html | 94 +++-------------------
user-guide/sql/window_functions_new.html | 42 ++++++++--
6 files changed, 59 insertions(+), 127 deletions(-)
diff --git a/_sources/user-guide/sql/window_functions.md.txt
b/_sources/user-guide/sql/window_functions.md.txt
index 0799859e43..6bf2005dab 100644
--- a/_sources/user-guide/sql/window_functions.md.txt
+++ b/_sources/user-guide/sql/window_functions.md.txt
@@ -146,40 +146,6 @@ 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.
-## Ranking functions
-
-- [rank](#rank)
-- [dense_rank](#dense_rank)
-- [ntile](#ntile)
-
-### `rank`
-
-Rank of the current row with gaps; same as row_number of its first peer.
-
-```sql
-rank()
-```
-
-### `dense_rank`
-
-Rank of the current row without gaps; this function counts peer groups.
-
-```sql
-dense_rank()
-```
-
-### `ntile`
-
-Integer ranging from 1 to the argument value, dividing the partition as
equally as possible.
-
-```sql
-ntile(expression)
-```
-
-#### Arguments
-
-- **expression**: An integer describing the number groups the partition should
be split into
-
## Analytical functions
- [cume_dist](#cume_dist)
diff --git a/_sources/user-guide/sql/window_functions_new.md.txt
b/_sources/user-guide/sql/window_functions_new.md.txt
index 267060abfd..ae3edb832f 100644
--- a/_sources/user-guide/sql/window_functions_new.md.txt
+++ b/_sources/user-guide/sql/window_functions_new.md.txt
@@ -159,6 +159,7 @@ All [aggregate functions](aggregate_functions.md) can be
used as window function
- [cume_dist](#cume_dist)
- [dense_rank](#dense_rank)
+- [ntile](#ntile)
- [percent_rank](#percent_rank)
- [rank](#rank)
- [row_number](#row_number)
@@ -179,6 +180,18 @@ Returns the rank of the current row without gaps. This
function ranks rows in a
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)`.
diff --git a/searchindex.js b/searchindex.js
index f3a75be7a3..90fc61028b 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/sql/index.html b/user-guide/sql/index.html
index c06726d59f..cbdc8582d3 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -607,7 +607,6 @@
<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#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>
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index e08f5f29a6..0cfb264924 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -518,47 +518,6 @@
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="#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="#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>
- </ul>
- </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#analytical-functions">
Analytical functions
@@ -592,7 +551,7 @@
</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="#arguments">
Arguments
</a>
</li>
@@ -608,7 +567,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="#id1">
Arguments
</a>
</li>
@@ -624,7 +583,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id3">
+ <a class="reference internal nav-link" href="#id2">
Arguments
</a>
</li>
@@ -786,41 +745,6 @@ 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="#rank">rank</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>
-</ul>
-<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>Rank of the current row with gaps; same as row_number of its first peer.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">rank</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>Rank of the current row without gaps; this function counts peer groups.</p>
-<div class="highlight-sql 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-sql 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>
<section id="analytical-functions">
<h2>Analytical functions<a class="headerlink" href="#analytical-functions"
title="Link to this heading">¶</a></h2>
<ul class="simple">
@@ -850,8 +774,8 @@ the rest of the documentation.</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>
</pre></div>
</div>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
+<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>: Expression to operate on</p></li>
</ul>
@@ -863,8 +787,8 @@ the rest of the documentation.</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>
</pre></div>
</div>
-<section id="id2">
-<h4>Arguments<a class="headerlink" href="#id2" 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>
@@ -876,8 +800,8 @@ the rest of the documentation.</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>
</pre></div>
</div>
-<section id="id3">
-<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
+<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>: 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>
diff --git a/user-guide/sql/window_functions_new.html
b/user-guide/sql/window_functions_new.html
index 771008d418..2c846bb12c 100644
--- a/user-guide/sql/window_functions_new.html
+++ b/user-guide/sql/window_functions_new.html
@@ -541,6 +541,22 @@
</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">
@@ -585,7 +601,7 @@
</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>
@@ -601,7 +617,7 @@
</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="#id2">
Arguments
</a>
</li>
@@ -777,6 +793,7 @@ Instead, the rows retain their separate identities. Behind
the scenes, the windo
<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>
@@ -795,6 +812,19 @@ Instead, the rows retain their separate identities. Behind
the scenes, the windo
</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>
@@ -829,8 +859,8 @@ Instead, the rows retain their separate identities. Behind
the scenes, the windo
<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="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>
<li><p><strong>offset</strong>: Integer. Specifies how many rows back the
value of expression should be retrieved. Defaults to 1.</p></li>
@@ -844,8 +874,8 @@ Instead, the rows retain their separate identities. Behind
the scenes, the windo
<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="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
+<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 forward the
value of expression should be retrieved. Defaults to 1.</p></li>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
