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 d98ebe345b Publish built docs triggered by
1b14655148377fac317153b5b5f14f4256a5d375
d98ebe345b is described below
commit d98ebe345b7768139617d56ef199be92e2761584
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Oct 24 18:42:16 2024 +0000
Publish built docs triggered by 1b14655148377fac317153b5b5f14f4256a5d375
---
.../user-guide/sql/scalar_functions_new.md.txt | 29 ++++++++--------------
searchindex.js | 2 +-
user-guide/sql/scalar_functions_new.html | 29 ++++++++--------------
3 files changed, 23 insertions(+), 37 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions_new.md.txt
b/_sources/user-guide/sql/scalar_functions_new.md.txt
index 55e61984d7..c15821ac89 100644
--- a/_sources/user-guide/sql/scalar_functions_new.md.txt
+++ b/_sources/user-guide/sql/scalar_functions_new.md.txt
@@ -3530,34 +3530,27 @@ flatten(array)
### `generate_series`
-Returns an Arrow array between start and stop with step. The range start..end
contains all values with start <= x < end. It is empty if start >= end. Step
cannot be 0.
+Similar to the range function, but it includes the upper bound.
```
-range(start, stop, step)
+generate_series(start, stop, step)
```
#### Arguments
-- **start**: Start of the range. Ints, timestamps, dates or string types that
can be coerced to Date32 are supported.
-- **end**: End of the range (not included). Type must be the same as start.
-- **step**: Increase by step (cannot be 0). Steps less than a day are
supported only for timestamp ranges.
+- **start**: start of the series. Ints, timestamps, dates or string types that
can be coerced to Date32 are supported.
+- **end**: end of the series (included). Type must be the same as start.
+- **step**: increase by step (can not be 0). Steps less than a day are
supported only for timestamp ranges.
#### Example
```sql
-> select range(2, 10, 3);
-+-----------------------------------+
-| range(Int64(2),Int64(10),Int64(3))|
-+-----------------------------------+
-| [2, 5, 8] |
-+-----------------------------------+
-
-> select range(DATE '1992-09-01', DATE '1993-03-01', INTERVAL '1' MONTH);
-+--------------------------------------------------------------+
-| range(DATE '1992-09-01', DATE '1993-03-01', INTERVAL '1' MONTH) |
-+--------------------------------------------------------------+
-| [1992-09-01, 1992-10-01, 1992-11-01, 1992-12-01, 1993-01-01, 1993-02-01] |
-+--------------------------------------------------------------+
+> select generate_series(1,3);
++------------------------------------+
+| generate_series(Int64(1),Int64(3)) |
++------------------------------------+
+| [1, 2, 3] |
++------------------------------------+
```
### `list_any_value`
diff --git a/searchindex.js b/searchindex.js
index 5f9145dba0..5b19097600 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "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"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "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"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions_new.html
b/user-guide/sql/scalar_functions_new.html
index 3b08ba4e3c..471e82a40b 100644
--- a/user-guide/sql/scalar_functions_new.html
+++ b/user-guide/sql/scalar_functions_new.html
@@ -8085,33 +8085,26 @@ an error will be returned.</p></li>
</section>
<section id="generate-series">
<h3><code class="docutils literal notranslate"><span
class="pre">generate_series</span></code><a class="headerlink"
href="#generate-series" title="Link to this heading">¶</a></h3>
-<p>Returns an Arrow array between start and stop with step. The range
start..end contains all values with start <= x < end. It is empty if
start >= end. Step cannot be 0.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">range</span><span
class="p">(</span><span class="n">start</span><span class="p">,</span> <span
class="n">stop</span><span class="p">,</span> <span class="n">step</span><span
class="p">)</span>
+<p>Similar to the range function, but it includes the upper bound.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">generate_series</span><span
class="p">(</span><span class="n">start</span><span class="p">,</span> <span
class="n">stop</span><span class="p">,</span> <span class="n">step</span><span
class="p">)</span>
</pre></div>
</div>
<section id="id254">
<h4>Arguments<a class="headerlink" href="#id254" title="Link to this
heading">¶</a></h4>
<ul class="simple">
-<li><p><strong>start</strong>: Start of the range. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
-<li><p><strong>end</strong>: End of the range (not included). Type must be the
same as start.</p></li>
-<li><p><strong>step</strong>: Increase by step (cannot be 0). Steps less than
a day are supported only for timestamp ranges.</p></li>
+<li><p><strong>start</strong>: start of the series. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
+<li><p><strong>end</strong>: end of the series (included). Type must be the
same as start.</p></li>
+<li><p><strong>step</strong>: increase by step (can not be 0). Steps less than
a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
<section id="id255">
<h4>Example<a class="headerlink" href="#id255" 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">range</span><span class="p">(</span><span class="mi">2</span><span
class="p">,</span><span class="w"> </span><span class="mi">10</span><span
class="p">,</span><span class="w"> </span><span class="mi">3</span><span
class="p">);</span>
-<span class="o">+</span><span
class="c1">-----------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">range</span><span class="p">(</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">2</span><span class="p">),</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">10</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">3</span><span class="p">))</span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">5</span><span class="p">,</span><span class="w"> </span><span
class="mi">8</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="k">select</span><span class="w"> </span><span
class="n">range</span><span class="p">(</span><span class="nb">DATE</span><span
class="w"> </span><span class="s1">'1992-09-01'</span><span
class="p">,</span><span class="w"> </span><span class="nb">DATE</span><span
class="w"> </span><span class="s1">'1993-03-01'</span><span
class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span
class="w"> [...]
-<span class="o">+</span><span
class="c1">--------------------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">range</span><span class="p">(</span><span class="nb">DATE</span><span
class="w"> </span><span class="s1">'1992-09-01'</span><span
class="p">,</span><span class="w"> </span><span class="nb">DATE</span><span
class="w"> </span><span class="s1">'1993-03-01'</span><span
class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span
class="w"> </span><span class="s1">'1'</span><span class=" [...]
-<span class="o">+</span><span
class="c1">--------------------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">1992</span><span class="o">-</span><span class="mi">09</span><span
class="o">-</span><span class="mi">01</span><span class="p">,</span><span
class="w"> </span><span class="mi">1992</span><span class="o">-</span><span
class="mi">10</span><span class="o">-</span><span class="mi">01</span><span
class="p">,</span><span class="w"> </span><span class="mi">1992</span><span
class="o">-</span><span class="mi" [...]
-<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">generate_series</span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="mi">3</span><span
class="p">);</span>
+<span class="o">+</span><span
class="c1">------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">generate_series</span><span class="p">(</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">3</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="p">[</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]</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]
