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 0c98f008eb Publish built docs triggered by
f12f51595e06d5ec868ef7b007d220b9c4113bfd
0c98f008eb is described below
commit 0c98f008eb6a663873c2feb67390b80569cf14f0
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Jul 7 08:03:17 2023 +0000
Publish built docs triggered by f12f51595e06d5ec868ef7b007d220b9c4113bfd
---
_sources/user-guide/sql/scalar_functions.md.txt | 39 +++
searchindex.js | 2 +-
user-guide/sql/index.html | 1 +
user-guide/sql/scalar_functions.html | 306 +++++++++++++++---------
4 files changed, 233 insertions(+), 115 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 34999ddf16..58d0dd253e 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1070,6 +1070,45 @@ Returns UUID v4 string value which is unique per row.
uuid()
```
+## Binary String Functions
+
+- [decode](#decode)
+- [encode](#encode)
+
+### `encode`
+
+Encode binary data into a textual representation.
+
+```
+encode(expression, format)
+```
+
+#### Arguments
+
+- **expression**: Expression containing string or binary data
+
+- **format**: Supported formats are: `base64`, `hex`
+
+**Related functions**:
+[decode](#decode)
+
+### `decode`
+
+Decode binary data from textual representation in string.
+
+```
+decode(expression, format)
+```
+
+#### Arguments
+
+- **expression**: Expression containing encoded string data
+
+- **format**: Same arguments as [encode](#encode)
+
+**Related functions**:
+[encode](#encode)
+
## Regular Expression Functions
Apache DataFusion uses the POSIX regular expression syntax and
diff --git a/searchindex.js b/searchindex.js
index 9e06b77821..58d1be3d6c 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/index.html b/user-guide/sql/index.html
index ab88024c1c..4f808c36df 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -370,6 +370,7 @@
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#math-functions">Math Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#conditional-functions">Conditional
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#string-functions">String Functions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#binary-string-functions">Binary String
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#regular-expression-functions">Regular Expression
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#time-and-date-functions">Time and Date
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#array-functions">Array Functions</a></li>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 13433f6b8c..89273452e3 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1335,6 +1335,45 @@
</li>
</ul>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#binary-string-functions">
+ Binary String Functions
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#encode">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ encode
+ </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="#id62">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#decode">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ decode
+ </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="#id63">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ </ul>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#regular-expression-functions">
Regular Expression Functions
@@ -1350,7 +1389,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id62">
+ <a class="reference internal nav-link" href="#id64">
Arguments
</a>
</li>
@@ -1366,7 +1405,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id63">
+ <a class="reference internal nav-link" href="#id65">
Arguments
</a>
</li>
@@ -1416,7 +1455,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id64">
+ <a class="reference internal nav-link" href="#id66">
Arguments
</a>
</li>
@@ -1432,12 +1471,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id65">
+ <a class="reference internal nav-link" href="#id67">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id66">
+ <a class="reference internal nav-link" href="#id68">
Aliases
</a>
</li>
@@ -1462,12 +1501,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id67">
+ <a class="reference internal nav-link" href="#id69">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id68">
+ <a class="reference internal nav-link" href="#id70">
Aliases
</a>
</li>
@@ -1492,7 +1531,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id69">
+ <a class="reference internal nav-link" href="#id71">
Arguments
</a>
</li>
@@ -1508,7 +1547,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id70">
+ <a class="reference internal nav-link" href="#id72">
Arguments
</a>
</li>
@@ -1524,7 +1563,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id71">
+ <a class="reference internal nav-link" href="#id73">
Arguments
</a>
</li>
@@ -1540,7 +1579,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id72">
+ <a class="reference internal nav-link" href="#id74">
Arguments
</a>
</li>
@@ -1556,7 +1595,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id73">
+ <a class="reference internal nav-link" href="#id75">
Arguments
</a>
</li>
@@ -1572,7 +1611,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id74">
+ <a class="reference internal nav-link" href="#id76">
Arguments
</a>
</li>
@@ -1595,7 +1634,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id75">
+ <a class="reference internal nav-link" href="#id77">
Arguments
</a>
</li>
@@ -1611,7 +1650,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id76">
+ <a class="reference internal nav-link" href="#id78">
Arguments
</a>
</li>
@@ -1627,7 +1666,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id77">
+ <a class="reference internal nav-link" href="#id79">
Arguments
</a>
</li>
@@ -1643,7 +1682,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id78">
+ <a class="reference internal nav-link" href="#id80">
Arguments
</a>
</li>
@@ -1659,7 +1698,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id79">
+ <a class="reference internal nav-link" href="#id81">
Arguments
</a>
</li>
@@ -1675,7 +1714,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id80">
+ <a class="reference internal nav-link" href="#id82">
Arguments
</a>
</li>
@@ -1691,7 +1730,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id81">
+ <a class="reference internal nav-link" href="#id83">
Arguments
</a>
</li>
@@ -1707,7 +1746,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id82">
+ <a class="reference internal nav-link" href="#id84">
Arguments
</a>
</li>
@@ -1723,7 +1762,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id83">
+ <a class="reference internal nav-link" href="#id85">
Arguments
</a>
</li>
@@ -1739,7 +1778,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id84">
+ <a class="reference internal nav-link" href="#id86">
Arguments
</a>
</li>
@@ -1755,7 +1794,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id85">
+ <a class="reference internal nav-link" href="#id87">
Arguments
</a>
</li>
@@ -1771,7 +1810,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id86">
+ <a class="reference internal nav-link" href="#id88">
Arguments
</a>
</li>
@@ -1787,7 +1826,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id87">
+ <a class="reference internal nav-link" href="#id89">
Arguments
</a>
</li>
@@ -1803,7 +1842,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id88">
+ <a class="reference internal nav-link" href="#id90">
Arguments
</a>
</li>
@@ -1819,7 +1858,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id91">
Arguments
</a>
</li>
@@ -1835,7 +1874,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id90">
+ <a class="reference internal nav-link" href="#id92">
Arguments
</a>
</li>
@@ -1858,7 +1897,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id91">
+ <a class="reference internal nav-link" href="#id93">
Arguments
</a>
</li>
@@ -1881,7 +1920,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <a class="reference internal nav-link" href="#id94">
Arguments
</a>
</li>
@@ -1897,7 +1936,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id93">
+ <a class="reference internal nav-link" href="#id95">
Arguments
</a>
</li>
@@ -1913,7 +1952,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id94">
+ <a class="reference internal nav-link" href="#id96">
Arguments
</a>
</li>
@@ -1929,7 +1968,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id95">
+ <a class="reference internal nav-link" href="#id97">
Arguments
</a>
</li>
@@ -1945,7 +1984,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id96">
+ <a class="reference internal nav-link" href="#id98">
Arguments
</a>
</li>
@@ -1961,7 +2000,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id97">
+ <a class="reference internal nav-link" href="#id99">
Arguments
</a>
</li>
@@ -1984,7 +2023,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id98">
+ <a class="reference internal nav-link" href="#id100">
Arguments
</a>
</li>
@@ -2000,7 +2039,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id99">
+ <a class="reference internal nav-link" href="#id101">
Arguments
</a>
</li>
@@ -3158,6 +3197,45 @@ Can be a constant, column, or function, and any
combination of string operators.
</div>
</section>
</section>
+<section id="binary-string-functions">
+<h2>Binary String Functions<a class="headerlink"
href="#binary-string-functions" title="Permalink to this heading">¶</a></h2>
+<ul class="simple">
+<li><p><a class="reference internal" href="#decode">decode</a></p></li>
+<li><p><a class="reference internal" href="#encode">encode</a></p></li>
+</ul>
+<section id="encode">
+<h3><code class="docutils literal notranslate"><span
class="pre">encode</span></code><a class="headerlink" href="#encode"
title="Permalink to this heading">¶</a></h3>
+<p>Encode binary data into a textual representation.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">encode</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="nb">format</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id62">
+<h4>Arguments<a class="headerlink" href="#id62" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression containing string or binary
data</p></li>
+<li><p><strong>format</strong>: Supported formats are: <code class="docutils
literal notranslate"><span class="pre">base64</span></code>, <code
class="docutils literal notranslate"><span
class="pre">hex</span></code></p></li>
+</ul>
+<p><strong>Related functions</strong>:
+<a class="reference internal" href="#decode">decode</a></p>
+</section>
+</section>
+<section id="decode">
+<h3><code class="docutils literal notranslate"><span
class="pre">decode</span></code><a class="headerlink" href="#decode"
title="Permalink to this heading">¶</a></h3>
+<p>Decode binary data from textual representation in string.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">decode</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="nb">format</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id63">
+<h4>Arguments<a class="headerlink" href="#id63" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression containing encoded string
data</p></li>
+<li><p><strong>format</strong>: Same arguments as <a class="reference
internal" href="#encode">encode</a></p></li>
+</ul>
+<p><strong>Related functions</strong>:
+<a class="reference internal" href="#encode">encode</a></p>
+</section>
+</section>
+</section>
<section id="regular-expression-functions">
<h2>Regular Expression Functions<a class="headerlink"
href="#regular-expression-functions" title="Permalink to this
heading">¶</a></h2>
<p>Apache DataFusion uses the POSIX regular expression syntax and
@@ -3172,8 +3250,8 @@ supports the following regular expression functions:</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regexp_match</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">regexp</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id62">
-<h4>Arguments<a class="headerlink" href="#id62" title="Permalink to this
heading">¶</a></h4>
+<section id="id64">
+<h4>Arguments<a class="headerlink" href="#id64" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3188,8 +3266,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regexp_replace</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">regexp</span><span class="p">,</span> <span
class="n">replacement</span><span class="p">,</span> <span
class="n">flags</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id63">
-<h4>Arguments<a class="headerlink" href="#id63" title="Permalink to this
heading">¶</a></h4>
+<section id="id65">
+<h4>Arguments<a class="headerlink" href="#id65" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3264,8 +3342,8 @@ minute bin it is in: <code class="docutils literal
notranslate"><span class="pre
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">date_bin</span><span
class="p">(</span><span class="n">interval</span><span class="p">,</span> <span
class="n">expression</span><span class="p">,</span> <span
class="n">origin</span><span class="o">-</span><span
class="n">timestamp</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id64">
-<h4>Arguments<a class="headerlink" href="#id64" title="Permalink to this
heading">¶</a></h4>
+<section id="id66">
+<h4>Arguments<a class="headerlink" href="#id66" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>interval</strong>: Bin interval.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on.
@@ -3294,8 +3372,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">date_trunc</span><span
class="p">(</span><span class="n">precision</span><span class="p">,</span>
<span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id65">
-<h4>Arguments<a class="headerlink" href="#id65" title="Permalink to this
heading">¶</a></h4>
+<section id="id67">
+<h4>Arguments<a class="headerlink" href="#id67" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>precision</strong>: Time precision to truncate to.
The following precisions are supported:</p>
@@ -3314,8 +3392,8 @@ The following precisions are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id66">
-<h4>Aliases<a class="headerlink" href="#id66" title="Permalink to this
heading">¶</a></h4>
+<section id="id68">
+<h4>Aliases<a class="headerlink" href="#id68" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datetrunc</p></li>
</ul>
@@ -3331,8 +3409,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">date_part</span><span
class="p">(</span><span class="n">part</span><span class="p">,</span> <span
class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id67">
-<h4>Arguments<a class="headerlink" href="#id67" title="Permalink to this
heading">¶</a></h4>
+<section id="id69">
+<h4>Arguments<a class="headerlink" href="#id69" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>part</strong>: Part of the date to return.
The following date parts are supported:</p>
@@ -3355,8 +3433,8 @@ The following date parts are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id68">
-<h4>Aliases<a class="headerlink" href="#id68" title="Permalink to this
heading">¶</a></h4>
+<section id="id70">
+<h4>Aliases<a class="headerlink" href="#id70" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datepart</p></li>
</ul>
@@ -3373,8 +3451,8 @@ Similar to <code class="docutils literal
notranslate"><span class="pre">date_par
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">extract</span><span
class="p">(</span><span class="n">field</span> <span class="n">FROM</span>
<span class="n">source</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id69">
-<h4>Arguments<a class="headerlink" href="#id69" title="Permalink to this
heading">¶</a></h4>
+<section id="id71">
+<h4>Arguments<a class="headerlink" href="#id71" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>field</strong>: Part or field of the date to return.
The following date fields are supported:</p>
@@ -3407,8 +3485,8 @@ return the corresponding RFC3339 nanosecond timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_timestamp</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id70">
-<h4>Arguments<a class="headerlink" href="#id70" title="Permalink to this
heading">¶</a></h4>
+<section id="id72">
+<h4>Arguments<a class="headerlink" href="#id72" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3424,8 +3502,8 @@ return the corresponding RFC3339 timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_millis</span><span class="p">(</span><span
class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id71">
-<h4>Arguments<a class="headerlink" href="#id71" title="Permalink to this
heading">¶</a></h4>
+<section id="id73">
+<h4>Arguments<a class="headerlink" href="#id73" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3441,8 +3519,8 @@ return the corresponding RFC3339 timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_micros</span><span class="p">(</span><span
class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id72">
-<h4>Arguments<a class="headerlink" href="#id72" title="Permalink to this
heading">¶</a></h4>
+<section id="id74">
+<h4>Arguments<a class="headerlink" href="#id74" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3458,8 +3536,8 @@ return the corresponding RFC3339 timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_seconds</span><span class="p">(</span><span
class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id73">
-<h4>Arguments<a class="headerlink" href="#id73" title="Permalink to this
heading">¶</a></h4>
+<section id="id75">
+<h4>Arguments<a class="headerlink" href="#id75" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3474,8 +3552,8 @@ RFC3339 timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">from_unixtime</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id74">
-<h4>Arguments<a class="headerlink" href="#id74" title="Permalink to this
heading">¶</a></h4>
+<section id="id76">
+<h4>Arguments<a class="headerlink" href="#id76" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3509,8 +3587,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_append</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id75">
-<h4>Arguments<a class="headerlink" href="#id75" title="Permalink to this
heading">¶</a></h4>
+<section id="id77">
+<h4>Arguments<a class="headerlink" href="#id77" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3524,8 +3602,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_concat</span><span
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">array_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id76">
-<h4>Arguments<a class="headerlink" href="#id76" title="Permalink to this
heading">¶</a></h4>
+<section id="id78">
+<h4>Arguments<a class="headerlink" href="#id78" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression to concatenate.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3539,8 +3617,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_contains</span><span
class="p">(</span><span class="n">first_array</span><span class="p">,</span>
<span class="n">second_array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id77">
-<h4>Arguments<a class="headerlink" href="#id77" title="Permalink to this
heading">¶</a></h4>
+<section id="id79">
+<h4>Arguments<a class="headerlink" href="#id79" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>first_array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3555,8 +3633,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_dims</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id78">
-<h4>Arguments<a class="headerlink" href="#id78" title="Permalink to this
heading">¶</a></h4>
+<section id="id80">
+<h4>Arguments<a class="headerlink" href="#id80" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3569,8 +3647,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_fill</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id79">
-<h4>Arguments<a class="headerlink" href="#id79" title="Permalink to this
heading">¶</a></h4>
+<section id="id81">
+<h4>Arguments<a class="headerlink" href="#id81" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3584,8 +3662,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_length</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">dimension</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id80">
-<h4>Arguments<a class="headerlink" href="#id80" title="Permalink to this
heading">¶</a></h4>
+<section id="id82">
+<h4>Arguments<a class="headerlink" href="#id82" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3599,8 +3677,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_ndims</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id81">
-<h4>Arguments<a class="headerlink" href="#id81" title="Permalink to this
heading">¶</a></h4>
+<section id="id83">
+<h4>Arguments<a class="headerlink" href="#id83" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3614,8 +3692,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<span class="n">array_position</span><span class="p">(</span><span
class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">,</span> <span
class="n">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id82">
-<h4>Arguments<a class="headerlink" href="#id82" title="Permalink to this
heading">¶</a></h4>
+<section id="id84">
+<h4>Arguments<a class="headerlink" href="#id84" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3630,8 +3708,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_positions</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id83">
-<h4>Arguments<a class="headerlink" href="#id83" title="Permalink to this
heading">¶</a></h4>
+<section id="id85">
+<h4>Arguments<a class="headerlink" href="#id85" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3645,8 +3723,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_prepend</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id84">
-<h4>Arguments<a class="headerlink" href="#id84" title="Permalink to this
heading">¶</a></h4>
+<section id="id86">
+<h4>Arguments<a class="headerlink" href="#id86" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element to prepend to the array.</p></li>
<li><p><strong>array</strong>: Array expression.
@@ -3660,8 +3738,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_remove</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id85">
-<h4>Arguments<a class="headerlink" href="#id85" title="Permalink to this
heading">¶</a></h4>
+<section id="id87">
+<h4>Arguments<a class="headerlink" href="#id87" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3675,8 +3753,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_replace</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">from</span><span class="p">,</span> <span class="n">to</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id86">
-<h4>Arguments<a class="headerlink" href="#id86" title="Permalink to this
heading">¶</a></h4>
+<section id="id88">
+<h4>Arguments<a class="headerlink" href="#id88" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3691,8 +3769,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimeter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id87">
-<h4>Arguments<a class="headerlink" href="#id87" title="Permalink to this
heading">¶</a></h4>
+<section id="id89">
+<h4>Arguments<a class="headerlink" href="#id89" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3706,8 +3784,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">cardinality</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Permalink to this
heading">¶</a></h4>
+<section id="id90">
+<h4>Arguments<a class="headerlink" href="#id90" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3720,8 +3798,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">make_array</span><span
class="p">(</span><span class="n">expression1</span><span class="p">[,</span>
<span class="o">...</span><span class="p">,</span> <span
class="n">expression_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id89">
-<h4>Arguments<a class="headerlink" href="#id89" title="Permalink to this
heading">¶</a></h4>
+<section id="id91">
+<h4>Arguments<a class="headerlink" href="#id91" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
array.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3735,8 +3813,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">trim_array</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id90">
-<h4>Arguments<a class="headerlink" href="#id90" title="Permalink to this
heading">¶</a></h4>
+<section id="id92">
+<h4>Arguments<a class="headerlink" href="#id92" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3777,8 +3855,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id91">
-<h4>Arguments<a class="headerlink" href="#id91" title="Permalink to this
heading">¶</a></h4>
+<section id="id93">
+<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3803,8 +3881,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">digest</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">algorithm</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id92">
-<h4>Arguments<a class="headerlink" href="#id92" title="Permalink to this
heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3830,8 +3908,8 @@ Must be one of:</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">md5</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id93">
-<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
+<section id="id95">
+<h4>Arguments<a class="headerlink" href="#id95" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3844,8 +3922,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha224</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Permalink to this
heading">¶</a></h4>
+<section id="id96">
+<h4>Arguments<a class="headerlink" href="#id96" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3858,8 +3936,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha256</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id95">
-<h4>Arguments<a class="headerlink" href="#id95" title="Permalink to this
heading">¶</a></h4>
+<section id="id97">
+<h4>Arguments<a class="headerlink" href="#id97" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3872,8 +3950,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha384</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Permalink to this
heading">¶</a></h4>
+<section id="id98">
+<h4>Arguments<a class="headerlink" href="#id98" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3886,8 +3964,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha512</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id97">
-<h4>Arguments<a class="headerlink" href="#id97" title="Permalink to this
heading">¶</a></h4>
+<section id="id99">
+<h4>Arguments<a class="headerlink" href="#id99" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3907,8 +3985,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id98">
-<h4>Arguments<a class="headerlink" href="#id98" title="Permalink to this
heading">¶</a></h4>
+<section id="id100">
+<h4>Arguments<a class="headerlink" href="#id100" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3924,8 +4002,8 @@ to cast to.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id99">
-<h4>Arguments<a class="headerlink" href="#id99" title="Permalink to this
heading">¶</a></h4>
+<section id="id101">
+<h4>Arguments<a class="headerlink" href="#id101" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
