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 0865b43f87 Publish built docs triggered by eb2b8c07b2f564fbd9046c67de41ac4ebfe7ae84 0865b43f87 is described below commit 0865b43f871c6bf1fbb773f7fcbee371a2b5b53f Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com> AuthorDate: Mon Aug 4 19:44:43 2025 +0000 Publish built docs triggered by eb2b8c07b2f564fbd9046c67de41ac4ebfe7ae84 --- _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, 234 insertions(+), 213 deletions(-) diff --git a/_sources/user-guide/sql/window_functions.md.txt b/_sources/user-guide/sql/window_functions.md.txt index 73e9731cdb..dc06f3d051 100644 --- a/_sources/user-guide/sql/window_functions.md.txt +++ b/_sources/user-guide/sql/window_functions.md.txt @@ -331,6 +331,8 @@ FROM employees; +-------------+--------+---------+ ``` +# + ## Analytical Functions - [first_value](#first_value) diff --git a/searchindex.js b/searchindex.js index 6eb90e72ac..9254e3d53d 100644 --- a/searchindex.js +++ b/searchindex.js @@ -1 +1 @@ -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 +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 diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html index 05b54ec21e..85846e2ed1 100644 --- a/user-guide/sql/index.html +++ b/user-guide/sql/index.html @@ -652,6 +652,9 @@ <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 659ab00122..f7173208e8 100644 --- a/user-guide/sql/window_functions.html +++ b/user-guide/sql/window_functions.html @@ -544,231 +544,244 @@ <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 + <li class="toc-h1 nav-item toc-entry"> + <a class="reference internal nav-link" href="#"> + Window Functions </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> + <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> - <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> + <li class="toc-h2 nav-item toc-entry"> + <a class="reference internal nav-link" href="#aggregate-functions"> + Aggregate functions </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-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-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#arguments"> - Arguments + <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-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id2"> - Example + <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-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id1"> + Example + </a> + </li> + </ul> </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> - <ul class="nav section-nav flex-column"> - <li class="toc-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id3"> - Example + <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> + <li class="toc-h4 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id2"> + Example + </a> + </li> + </ul> </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> - </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 + <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> + </li> + </ul> </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> - </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 + <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> + </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> + </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-h2 nav-item toc-entry"> - <a class="reference internal nav-link" href="#analytical-functions"> - Analytical Functions + <li class="toc-h1 nav-item toc-entry"> + <a class="reference internal nav-link" href="#id6"> </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> + <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 </a> <ul class="nav section-nav flex-column"> - <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 + <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="#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> - </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 + <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="#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-h4 nav-item toc-entry"> - <a class="reference internal nav-link" href="#id9"> - Example + <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="#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> - </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 + <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="#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-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 + <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="#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> @@ -1114,6 +1127,9 @@ 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"> @@ -1129,14 +1145,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="id6"> -<h4>Arguments<a class="headerlink" href="#id6" title="Link to this heading">¶</a></h4> +<section id="id7"> +<h4>Arguments<a class="headerlink" href="#id7" 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="id7"> -<h4>Example<a class="headerlink" href="#id7" title="Link to this heading">¶</a></h4> +<section id="id8"> +<h4>Example<a class="headerlink" href="#id8" 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> @@ -1163,16 +1179,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="id8"> -<h4>Arguments<a class="headerlink" href="#id8" title="Link to this heading">¶</a></h4> +<section id="id9"> +<h4>Arguments<a class="headerlink" href="#id9" 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="id9"> -<h4>Example<a class="headerlink" href="#id9" title="Link to this heading">¶</a></h4> +<section id="id10"> +<h4>Example<a class="headerlink" href="#id10" 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> @@ -1197,14 +1213,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="id10"> -<h4>Arguments<a class="headerlink" href="#id10" title="Link to this heading">¶</a></h4> +<section id="id11"> +<h4>Arguments<a class="headerlink" href="#id11" 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="id11"> -<h4>Example<a class="headerlink" href="#id11" title="Link to this heading">¶</a></h4> +<section id="id12"> +<h4>Example<a class="headerlink" href="#id12" 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> @@ -1231,16 +1247,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="id12"> -<h4>Arguments<a class="headerlink" href="#id12" title="Link to this heading">¶</a></h4> +<section id="id13"> +<h4>Arguments<a class="headerlink" href="#id13" 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="id13"> -<h4>Example<a class="headerlink" href="#id13" title="Link to this heading">¶</a></h4> +<section id="id14"> +<h4>Example<a class="headerlink" href="#id14" 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> @@ -1268,15 +1284,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="id14"> -<h4>Arguments<a class="headerlink" href="#id14" title="Link to this heading">¶</a></h4> +<section id="id15"> +<h4>Arguments<a class="headerlink" href="#id15" 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="id15"> -<h4>Example<a class="headerlink" href="#id15" title="Link to this heading">¶</a></h4> +<section id="id16"> +<h4>Example<a class="headerlink" href="#id16" 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