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 2b1e7626e2 Publish built docs triggered by f4c5a63c6bc61afffa8215f1af784ac9bba73664 2b1e7626e2 is described below commit 2b1e7626e259c39b5d18f0ca9821156ebc806d27 Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com> AuthorDate: Sat Aug 2 04:23:36 2025 +0000 Publish built docs triggered by f4c5a63c6bc61afffa8215f1af784ac9bba73664 --- _sources/user-guide/sql/window_functions.md.txt | 2 - searchindex.js | 2 +- user-guide/sql/index.html | 3 - user-guide/sql/window_functions.html | 440 ++++++++++++------------ 4 files changed, 213 insertions(+), 234 deletions(-) diff --git a/_sources/user-guide/sql/window_functions.md.txt b/_sources/user-guide/sql/window_functions.md.txt index dc06f3d051..73e9731cdb 100644 --- a/_sources/user-guide/sql/window_functions.md.txt +++ b/_sources/user-guide/sql/window_functions.md.txt @@ -331,8 +331,6 @@ FROM employees; +-------------+--------+---------+ ``` -# - ## Analytical Functions - [first_value](#first_value) diff --git a/searchindex.js b/searchindex.js index 3017b31421..494e5caaaf 100644 --- a/searchindex.js +++ b/searchindex.js @@ -1 +1 @@ -Search.setIndex({"alltitles":{"":[[62,"id6"]],"!=":[[56,"op-neq"]],"!~":[[56,"op-re-not-match"]],"!~*":[[56,"op-re-not-match-i"]],"!~~":[[56,"id19"]],"!~~*":[[56,"id20"]],"#":[[56,"op-bit-xor"]],"%":[[56,"op-modulo"]],"&":[[56,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[56,"op-multiply"]],"+":[[56,"op-plus"]],"-":[[56,"op-minus"]],"/":[[56,"op-divide"]],"<":[ [...] \ No newline at end of file +Search.setIndex({"alltitles":{"!=":[[56,"op-neq"]],"!~":[[56,"op-re-not-match"]],"!~*":[[56,"op-re-not-match-i"]],"!~~":[[56,"id19"]],"!~~*":[[56,"id20"]],"#":[[56,"op-bit-xor"]],"%":[[56,"op-modulo"]],"&":[[56,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[56,"op-multiply"]],"+":[[56,"op-plus"]],"-":[[56,"op-minus"]],"/":[[56,"op-divide"]],"<":[[56,"op-lt"]],"< [...] \ No newline at end of file diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html index 85846e2ed1..05b54ec21e 100644 --- a/user-guide/sql/index.html +++ b/user-guide/sql/index.html @@ -652,9 +652,6 @@ <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> -</ul> -</li> -<li class="toctree-l1"><a class="reference internal" href="window_functions.html#id6"></a><ul> <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 f7173208e8..659ab00122 100644 --- a/user-guide/sql/window_functions.html +++ b/user-guide/sql/window_functions.html @@ -544,244 +544,231 @@ <nav id="bd-toc-nav"> <ul class="visible nav section-nav flex-column"> - <li class="toc-h1 nav-item toc-entry"> - <a class="reference internal nav-link" href="#"> - Window Functions + <li class="toc-h2 nav-item toc-entry"> + <a class="reference internal nav-link" href="#syntax"> + Syntax </a> - <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 + </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> + <ul class="nav section-nav flex-column"> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#example"> + Example + </a> + </li> + </ul> </li> - <li class="toc-h2 nav-item toc-entry"> - <a class="reference internal nav-link" href="#ranking-functions"> - Ranking Functions + <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> <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> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id1"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#example"> - Example - </a> - </li> - </ul> </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> + </ul> + </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> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id1"> - Example - </a> - </li> - </ul> </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> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id2"> + Example </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> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id2"> - Example - </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> + </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> + <ul class="nav section-nav flex-column"> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id3"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id3"> - Example - </a> - </li> - </ul> </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> + </ul> + </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> + <ul class="nav section-nav flex-column"> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id4"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id4"> - Example - </a> - </li> - </ul> </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> + </ul> + </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> + <ul class="nav section-nav flex-column"> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id5"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id5"> - Example - </a> - </li> - </ul> </li> </ul> </li> </ul> </li> - <li class="toc-h1 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id6"> + <li class="toc-h2 nav-item toc-entry"> + <a class="reference internal nav-link" href="#analytical-functions"> + Analytical Functions </a> - <ul class="visible nav section-nav flex-column"> - <li class="toc-h2 nav-item toc-entry"> - <a class="reference internal nav-link" href="#analytical-functions"> - Analytical Functions + <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-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> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id6"> + Arguments + </a> + </li> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id7"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id7"> - Arguments - </a> - </li> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id8"> - Example - </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> + </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="#id8"> + Arguments </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id9"> - Arguments - </a> - </li> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id10"> - Example - </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> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id9"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id11"> - Arguments - </a> - </li> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id12"> - Example - </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> + </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="#id10"> + Arguments </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id13"> - Arguments - </a> - </li> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id14"> - Example - </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> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id11"> + Example + </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="#id12"> + Arguments + </a> + </li> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id13"> + Example + </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="#id14"> + Arguments + </a> + </li> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id15"> + Example </a> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id15"> - Arguments - </a> - </li> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id16"> - Example - </a> - </li> - </ul> </li> </ul> </li> @@ -1127,9 +1114,6 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo </section> </section> </section> -</section> -<section id="id6"> -<h1><a class="headerlink" href="#id6" title="Link to this heading">¶</a></h1> <section id="analytical-functions"> <h2>Analytical Functions<a class="headerlink" href="#analytical-functions" title="Link to this heading">¶</a></h2> <ul class="simple"> @@ -1145,14 +1129,14 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo <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="id7"> -<h4>Arguments<a class="headerlink" href="#id7" title="Link to this heading">¶</a></h4> +<section id="id6"> +<h4>Arguments<a class="headerlink" href="#id6" title="Link to this heading">¶</a></h4> <ul class="simple"> <li><p><strong>expression</strong>: Expression to operate on</p></li> </ul> </section> -<section id="id8"> -<h4>Example<a class="headerlink" href="#id8" title="Link to this heading">¶</a></h4> +<section id="id7"> +<h4>Example<a class="headerlink" href="#id7" title="Link to this heading">¶</a></h4> <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="c1">-- Example usage of the first_value window function:</span> <span class="k">SELECT</span><span class="w"> </span><span class="n">department</span><span class="p">,</span> <span class="w"> </span><span class="n">employee_id</span><span class="p">,</span> @@ -1179,16 +1163,16 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo <div class="highlight-sql 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="w"> </span><span class="k">offset</span><span class="p">,</span><span class="w"> </span><span class="k">default</span><span class="p">)</span> </pre></div> </div> -<section id="id9"> -<h4>Arguments<a class="headerlink" href="#id9" title="Link to this heading">¶</a></h4> +<section id="id8"> +<h4>Arguments<a class="headerlink" href="#id8" 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 id="id10"> -<h4>Example<a class="headerlink" href="#id10" title="Link to this heading">¶</a></h4> +<section id="id9"> +<h4>Example<a class="headerlink" href="#id9" title="Link to this heading">¶</a></h4> <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="c1">-- Example usage of the lag window function:</span> <span class="k">SELECT</span><span class="w"> </span><span class="n">employee_id</span><span class="p">,</span> <span class="w"> </span><span class="n">salary</span><span class="p">,</span> @@ -1213,14 +1197,14 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo <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="id11"> -<h4>Arguments<a class="headerlink" href="#id11" title="Link to this heading">¶</a></h4> +<section id="id10"> +<h4>Arguments<a class="headerlink" href="#id10" title="Link to this heading">¶</a></h4> <ul class="simple"> <li><p><strong>expression</strong>: Expression to operate on</p></li> </ul> </section> -<section id="id12"> -<h4>Example<a class="headerlink" href="#id12" title="Link to this heading">¶</a></h4> +<section id="id11"> +<h4>Example<a class="headerlink" href="#id11" title="Link to this heading">¶</a></h4> <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="c1">-- SQL example of last_value:</span> <span class="k">SELECT</span><span class="w"> </span><span class="n">department</span><span class="p">,</span> <span class="w"> </span><span class="n">employee_id</span><span class="p">,</span> @@ -1247,16 +1231,16 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo <div class="highlight-sql 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="w"> </span><span class="k">offset</span><span class="p">,</span><span class="w"> </span><span class="k">default</span><span class="p">)</span> </pre></div> </div> -<section id="id13"> -<h4>Arguments<a class="headerlink" href="#id13" title="Link to this heading">¶</a></h4> +<section id="id12"> +<h4>Arguments<a class="headerlink" href="#id12" 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 id="id14"> -<h4>Example<a class="headerlink" href="#id14" title="Link to this heading">¶</a></h4> +<section id="id13"> +<h4>Example<a class="headerlink" href="#id13" title="Link to this heading">¶</a></h4> <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="c1">-- Example usage of lead window function:</span> <span class="k">SELECT</span> <span class="w"> </span><span class="n">employee_id</span><span class="p">,</span> @@ -1284,15 +1268,15 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo <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="id15"> -<h4>Arguments<a class="headerlink" href="#id15" title="Link to this heading">¶</a></h4> +<section id="id14"> +<h4>Arguments<a class="headerlink" href="#id14" title="Link to this heading">¶</a></h4> <ul class="simple"> <li><p><strong>expression</strong>: The column from which to retrieve the nth value.</p></li> <li><p><strong>n</strong>: Integer. Specifies the row number (starting from 1) in the window frame.</p></li> </ul> </section> -<section id="id16"> -<h4>Example<a class="headerlink" href="#id16" title="Link to this heading">¶</a></h4> +<section id="id15"> +<h4>Example<a class="headerlink" href="#id15" title="Link to this heading">¶</a></h4> <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="c1">-- Sample employees table:</span> <span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">employees</span><span class="w"> </span><span class="p">(</span><span class="n">id</span><span class="w"> </span><span class="nb">INT</span><span class="p">,</span><span class="w"> </span><span class="n">salary</span><span class="w"> </span><span class="nb">INT</span><span class="p">);</span> <span class="k">INSERT</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="n">employees</span><span class="w"> </span><span class="p">(</span><span class="n">id</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">VALUES</span> --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org For additional commands, e-mail: commits-h...@datafusion.apache.org