You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by gi...@apache.org on 2023/05/15 16:44:31 UTC
[arrow-datafusion] branch asf-site updated: Publish built docs triggered by d8a92be182327f98dffaa5db5f515e113eb3b2bf
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/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 4561351e22 Publish built docs triggered by d8a92be182327f98dffaa5db5f515e113eb3b2bf
4561351e22 is described below
commit 4561351e22dede1146711adab11f373a059b9002
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Mon May 15 16:44:26 2023 +0000
Publish built docs triggered by d8a92be182327f98dffaa5db5f515e113eb3b2bf
---
_sources/user-guide/sql/aggregate_functions.md.txt | 4 ++--
_sources/user-guide/sql/select.md.txt | 9 +++++++++
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 4 ++--
user-guide/sql/select.html | 6 ++++++
5 files changed, 20 insertions(+), 5 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt b/_sources/user-guide/sql/aggregate_functions.md.txt
index 68c02ef550..d02c733efc 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -194,10 +194,10 @@ sum(expression)
### `array_agg`
-Returns an array created from the expression elements.
+Returns an array created from the expression elements. If ordering requirement is given, elements are inserted in the order of required ordering.
```
-array_agg(expression)
+array_agg(expression [ORDER BY expression])
```
#### Arguments
diff --git a/_sources/user-guide/sql/select.md.txt b/_sources/user-guide/sql/select.md.txt
index 68be88d7cf..cb73e08520 100644
--- a/_sources/user-guide/sql/select.md.txt
+++ b/_sources/user-guide/sql/select.md.txt
@@ -189,6 +189,15 @@ Example:
SELECT a, b, MAX(c) FROM table GROUP BY a, b
```
+Some aggregation functions accept optional ordering requirement, such as `ARRAY_AGG`. If a requirement is given,
+aggregation is calculated in the order of the requirement.
+
+Example:
+
+```sql
+SELECT a, b, ARRAY_AGG(c, ORDER BY d) FROM table GROUP BY a, b
+```
+
## HAVING clause
Example:
diff --git a/searchindex.js b/searchindex.js
index a2b1633f9b..3c8abafa05 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture", "contributor-guide/communication", "contributor-guide/index", "contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", "contributor-guide/specification/index", "contributor-guide/specification/invariants", "contributor-guide/specification/output-field-name-semantic", "index", "user-guide/cli", "user-guide/configs", "user-guide/dataframe", "user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture", "contributor-guide/communication", "contributor-guide/index", "contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", "contributor-guide/specification/index", "contributor-guide/specification/invariants", "contributor-guide/specification/output-field-name-semantic", "index", "user-guide/cli", "user-guide/configs", "user-guide/dataframe", "user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use [...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html b/user-guide/sql/aggregate_functions.html
index 6ebb5b74cd..73e42629cf 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -964,8 +964,8 @@ Can be a constant, column, or function, and any combination of arithmetic operat
</section>
<section id="array-agg">
<h3><code class="docutils literal notranslate"><span class="pre">array_agg</span></code><a class="headerlink" href="#array-agg" title="Permalink to this heading">¶</a></h3>
-<p>Returns an array created from the expression elements.</p>
-<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_agg</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
+<p>Returns an array created from the expression elements. If ordering requirement is given, elements are inserted in the order of required ordering.</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_agg</span><span class="p">(</span><span class="n">expression</span> <span class="p">[</span><span class="n">ORDER</span> <span class="n">BY</span> <span class="n">expression</span><span class="p">])</span>
</pre></div>
</div>
<section id="id11">
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 2e5141dba6..0e3cbf1881 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -558,6 +558,12 @@ right side of the join.</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">a</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="p">,</span><span class="w"> </span><span class="k">MAX</span><span class="p">(</span><span class="k">c</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="w [...]
</pre></div>
</div>
+<p>Some aggregation functions accept optional ordering requirement, such as <code class="docutils literal notranslate"><span class="pre">ARRAY_AGG</span></code>. If a requirement is given,
+aggregation is calculated in the order of the requirement.</p>
+<p>Example:</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">a</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="p">,</span><span class="w"> </span><span class="n">ARRAY_AGG</span><span class="p">(</span><span class="k">c</span><span class="p">,</span><span class="w"> </span><span class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span clas [...]
+</pre></div>
+</div>
</section>
<section id="having-clause">
<h2>HAVING clause<a class="headerlink" href="#having-clause" title="Permalink to this heading">¶</a></h2>