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 cfc6e866c7 Publish built docs triggered by
e41c02c6996cd83019f3ece98656fa4daee7e7fd
cfc6e866c7 is described below
commit cfc6e866c7ea1e8c2c728d4b7cb64203b2190d0a
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Apr 23 10:46:44 2025 +0000
Publish built docs triggered by e41c02c6996cd83019f3ece98656fa4daee7e7fd
---
_sources/user-guide/sql/aggregate_functions.md.txt | 30 +++++++++++-----------
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 30 +++++++++++-----------
3 files changed, 31 insertions(+), 31 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index 684db52e63..774a4fae6b 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -808,7 +808,7 @@ approx_distinct(expression)
### `approx_median`
-Returns the approximate median (50th percentile) of input values. It is an
alias of `approx_percentile_cont(x, 0.5)`.
+Returns the approximate median (50th percentile) of input values. It is an
alias of `approx_percentile_cont(0.5) WITHIN GROUP (ORDER BY x)`.
```sql
approx_median(expression)
@@ -834,7 +834,7 @@ approx_median(expression)
Returns the approximate percentile of input values using the t-digest
algorithm.
```sql
-approx_percentile_cont(expression, percentile, centroids)
+approx_percentile_cont(percentile, centroids) WITHIN GROUP (ORDER BY
expression)
```
#### Arguments
@@ -846,12 +846,12 @@ approx_percentile_cont(expression, percentile, centroids)
#### Example
```sql
-> SELECT approx_percentile_cont(column_name, 0.75, 100) FROM table_name;
-+-------------------------------------------------+
-| approx_percentile_cont(column_name, 0.75, 100) |
-+-------------------------------------------------+
-| 65.0 |
-+-------------------------------------------------+
+> SELECT approx_percentile_cont(0.75, 100) WITHIN GROUP (ORDER BY column_name)
FROM table_name;
++-----------------------------------------------------------------------+
+| approx_percentile_cont(0.75, 100) WITHIN GROUP (ORDER BY column_name) |
++-----------------------------------------------------------------------+
+| 65.0 |
++-----------------------------------------------------------------------+
```
### `approx_percentile_cont_with_weight`
@@ -859,7 +859,7 @@ approx_percentile_cont(expression, percentile, centroids)
Returns the weighted approximate percentile of input values using the t-digest
algorithm.
```sql
-approx_percentile_cont_with_weight(expression, weight, percentile)
+approx_percentile_cont_with_weight(weight, percentile) WITHIN GROUP (ORDER BY
expression)
```
#### Arguments
@@ -871,10 +871,10 @@ approx_percentile_cont_with_weight(expression, weight,
percentile)
#### Example
```sql
-> SELECT approx_percentile_cont_with_weight(column_name, weight_column, 0.90)
FROM table_name;
-+----------------------------------------------------------------------+
-| approx_percentile_cont_with_weight(column_name, weight_column, 0.90) |
-+----------------------------------------------------------------------+
-| 78.5 |
-+----------------------------------------------------------------------+
+> SELECT approx_percentile_cont_with_weight(weight_column, 0.90) WITHIN GROUP
(ORDER BY column_name) FROM table_name;
++---------------------------------------------------------------------------------------------+
+| approx_percentile_cont_with_weight(weight_column, 0.90) WITHIN GROUP (ORDER
BY column_name) |
++---------------------------------------------------------------------------------------------+
+| 78.5
|
++---------------------------------------------------------------------------------------------+
```
diff --git a/searchindex.js b/searchindex.js
index 93475bec98..ac8d746dbd 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[54,"op-neq"]],"!~":[[54,"op-re-not-match"]],"!~*":[[54,"op-re-not-match-i"]],"!~~":[[54,"id19"]],"!~~*":[[54,"id20"]],"#":[[54,"op-bit-xor"]],"%":[[54,"op-modulo"]],"&":[[54,"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"]],"*":[[54,"op-multiply"]],"+":[[54,"op-plus"]],"-":[[54,"op-minus"]],"/":[[54,"op-divide"]],"2022
Q2":[[10,"q2"]] [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[54,"op-neq"]],"!~":[[54,"op-re-not-match"]],"!~*":[[54,"op-re-not-match-i"]],"!~~":[[54,"id19"]],"!~~*":[[54,"id20"]],"#":[[54,"op-bit-xor"]],"%":[[54,"op-modulo"]],"&":[[54,"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"]],"*":[[54,"op-multiply"]],"+":[[54,"op-plus"]],"-":[[54,"op-minus"]],"/":[[54,"op-divide"]],"2022
Q2":[[10,"q2"]] [...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 054a60c569..c14d0720d2 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -2218,7 +2218,7 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
</section>
<section id="approx-median">
<h3><code class="docutils literal notranslate"><span
class="pre">approx_median</span></code><a class="headerlink"
href="#approx-median" title="Link to this heading">¶</a></h3>
-<p>Returns the approximate median (50th percentile) of input values. It is an
alias of <code class="docutils literal notranslate"><span
class="pre">approx_percentile_cont(x,</span> <span
class="pre">0.5)</span></code>.</p>
+<p>Returns the approximate median (50th percentile) of input values. It is an
alias of <code class="docutils literal notranslate"><span
class="pre">approx_percentile_cont(0.5)</span> <span class="pre">WITHIN</span>
<span class="pre">GROUP</span> <span class="pre">(ORDER</span> <span
class="pre">BY</span> <span class="pre">x)</span></code>.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_median</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
@@ -2243,7 +2243,7 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<section id="approx-percentile-cont">
<h3><code class="docutils literal notranslate"><span
class="pre">approx_percentile_cont</span></code><a class="headerlink"
href="#approx-percentile-cont" title="Link to this heading">¶</a></h3>
<p>Returns the approximate percentile of input values using the t-digest
algorithm.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="n">expression</span><span class="p">,</span><span class="w">
</span><span class="n">percentile</span><span class="p">,</span><span
class="w"> </span><span class="n">centroids</span><span class="p">)</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="n">percentile</span><span class="p">,</span><span class="w">
</span><span class="n">centroids</span><span class="p">)</span><span class="w">
</span><span class="n">WITHIN</span><span class="w"> </span><span
class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span
class="k">ORDER</span><span class="w"> </span>< [...]
</pre></div>
</div>
<section id="id59">
@@ -2256,12 +2256,12 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
</section>
<section id="id60">
<h4>Example<a class="headerlink" href="#id60" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="k">column_name</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span
class="mi">75</span><span class="p">,</span><span class="w"> </span><span
class="mi">100</span><span c [...]
-<span class="o">+</span><span
class="c1">-------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="k">column_name</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span
class="mi">75</span><span class="p">,</span><span class="w"> </span><span
class="mi">100</span><span class="p">)</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="mi">65</span><span class="p">.</span><span class="mi">0</span><span
class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span
class="c1">-------------------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="mi">0</span><span class="p">.</span><span class="mi">75</span><span
class="p">,</span><span class="w"> </span><span class="mi">100</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class= [...]
+<span class="o">+</span><span
class="c1">-----------------------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="mi">0</span><span class="p">.</span><span class="mi">75</span><span
class="p">,</span><span class="w"> </span><span class="mi">100</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class="p">(</span><span class="k">ORDER</span><span class="w"> </s [...]
+<span class="o">+</span><span
class="c1">-----------------------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="mi">65</span><span class="p">.</span><span class="mi">0</span><span
class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">-----------------------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -2269,7 +2269,7 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<section id="approx-percentile-cont-with-weight">
<h3><code class="docutils literal notranslate"><span
class="pre">approx_percentile_cont_with_weight</span></code><a
class="headerlink" href="#approx-percentile-cont-with-weight" title="Link to
this heading">¶</a></h3>
<p>Returns the weighted approximate percentile of input values using the
t-digest algorithm.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">expression</span><span
class="p">,</span><span class="w"> </span><span class="n">weight</span><span
class="p">,</span><span class="w"> </span><span
class="n">percentile</span><span class="p">)</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">weight</span><span class="p">,</span><span
class="w"> </span><span class="n">percentile</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class="p">(</span><span class="k">ORDER</span><span class="w"> [...]
</pre></div>
</div>
<section id="id61">
@@ -2282,12 +2282,12 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
</section>
<section id="id62">
<h4>Example<a class="headerlink" href="#id62" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="k">column_name</span><span
class="p">,</span><span class="w"> </span><span
class="n">weight_column</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span class= [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="k">column_name</span><span
class="p">,</span><span class="w"> </span><span
class="n">weight_column</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span
class="mi">90</span><span class="p">)</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="mi">78</span><span class="p">.</span><span class="mi">5</span><span
class="w">
</span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">----------------------------------------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">weight_column</span><span
class="p">,</span><span class="w"> </span><span class="mi">0</span><span
class="p">.</span><span class="mi">90</span><span class="p">)</span><span
class="w"> </span><span class="n">WITH [...]
+<span class="o">+</span><span
class="c1">---------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">weight_column</span><span
class="p">,</span><span class="w"> </span><span class="mi">0</span><span
class="p">.</span><span class="mi">90</span><span class="p">)</span><span
class="w"> </span><span class="n">WITHIN</span><span class="w"> </span><span
class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span
class="k">ORDER</span [...]
+<span class="o">+</span><span
class="c1">---------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="mi">78</span><span class="p">.</span><span class="mi">5</span><span
class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">---------------------------------------------------------------------------------------------+</span>
</pre></div>
</div>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
