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 19a4fbb0bb Publish built docs triggered by
a4e6b075b8fe448e0f1fde948626d7c43c1d9c4a
19a4fbb0bb is described below
commit 19a4fbb0bbc082e6a78eedf1567f13ae5587f891
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Oct 23 11:00:56 2024 +0000
Publish built docs triggered by a4e6b075b8fe448e0f1fde948626d7c43c1d9c4a
---
_sources/user-guide/sql/window_functions_new.md.txt | 9 +++++++++
searchindex.js | 2 +-
user-guide/sql/window_functions_new.html | 17 +++++++++++++++++
3 files changed, 27 insertions(+), 1 deletion(-)
diff --git a/_sources/user-guide/sql/window_functions_new.md.txt
b/_sources/user-guide/sql/window_functions_new.md.txt
index 462fc900d1..89ce2284a7 100644
--- a/_sources/user-guide/sql/window_functions_new.md.txt
+++ b/_sources/user-guide/sql/window_functions_new.md.txt
@@ -157,11 +157,20 @@ All [aggregate functions](aggregate_functions.md) can be
used as window function
## Ranking Functions
+- [cume_dist](#cume_dist)
- [dense_rank](#dense_rank)
- [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.
diff --git a/searchindex.js b/searchindex.js
index 38cc9a077c..7e32472dd7 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47,
"op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]],
"!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]],
"&": [[47, "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"]], "*":
[[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47,
"op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]],
"!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]],
"&": [[47, "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"]], "*":
[[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/window_functions_new.html
b/user-guide/sql/window_functions_new.html
index 47a6dd32f4..cb0ed05fc8 100644
--- a/user-guide/sql/window_functions_new.html
+++ b/user-guide/sql/window_functions_new.html
@@ -518,6 +518,15 @@
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">
@@ -722,11 +731,19 @@ Instead, the rows retain their separate identities.
Behind the scenes, the windo
<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="#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>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
