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 10943e573b Publish built docs triggered by
7360260be8d869bd47f2f3e8292954b8ac51de53
10943e573b is described below
commit 10943e573bbe9acc55c280338cc570e0686c30dc
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon May 8 15:37:45 2023 +0000
Publish built docs triggered by 7360260be8d869bd47f2f3e8292954b8ac51de53
---
_sources/user-guide/expressions.md.txt | 3 +
_sources/user-guide/sql/scalar_functions.md.txt | 46 +++
searchindex.js | 2 +-
user-guide/expressions.html | 41 +-
user-guide/sql/scalar_functions.html | 505 ++++++++++++++----------
5 files changed, 376 insertions(+), 221 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 0a8bef345f..e250dc4bb6 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -91,7 +91,10 @@ expressions such as `col("a") + col("b")` to be used.
| cosh(x) | hyperbolic cosine |
| degrees(x) | converts radians to degrees |
| exp(x) | exponential |
+| factorial(x) | factorial |
| floor(x) | nearest integer less than or equal to argument |
+| gcd(x, y) | greatest common divisor |
+| lcm(x, y) | least common multiple |
| ln(x) | natural logarithm |
| log(base, x) | logarithm of x for a particular base |
| log10(x) | base 10 logarithm |
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 8c217b3790..cbf9e2fa18 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -35,7 +35,10 @@
- [cosh](#cosh)
- [degrees](#degrees)
- [exp](#exp)
+- [factorial](#factorial)
- [floor](#floor)
+- [gcd](#gcd)
+- [lcm](#lcm)
- [ln](#ln)
- [log](#log)
- [log10](#log10)
@@ -238,6 +241,19 @@ exp(numeric_expression)
- **numeric_expression**: Numeric expression to use as the exponent.
Can be a constant, column, or function, and any combination of arithmetic
operators.
+### `factorial`
+
+Factorial. Returns 1 if value is less than 2.
+
+```
+factorial(numeric_expression)
+```
+
+#### Arguments
+
+- **numeric_expression**: Numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
### `floor`
Returns the nearest integer less than or equal to a number.
@@ -251,6 +267,36 @@ floor(numeric_expression)
- **numeric_expression**: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
+### `gcd`
+
+Returns the greatest common divisor of `expression_x` and `expression_y`.
Returns 0 if both inputs are zero.
+
+```
+gcd(expression_x, expression_y)
+```
+
+#### Arguments
+
+- **expression_x**: First numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+- **expression_y**: Second numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `lcm`
+
+Returns the least common multiple of `expression_x` and `expression_y`.
Returns 0 if either input is zero.
+
+```
+lcm(expression_x, expression_y)
+```
+
+#### Arguments
+
+- **expression_x**: First numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+- **expression_y**: Second numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
### `ln`
Returns the natural logarithm of a number.
diff --git a/searchindex.js b/searchindex.js
index 5f85e3f676..6f964ee3a3 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/expressions.html b/user-guide/expressions.html
index 8a346de27c..af99b2a097 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -576,52 +576,61 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<tr class="row-odd"><td><p>exp(x)</p></td>
<td><p>exponential</p></td>
</tr>
-<tr class="row-even"><td><p>floor(x)</p></td>
+<tr class="row-even"><td><p>factorial(x)</p></td>
+<td><p>factorial</p></td>
+</tr>
+<tr class="row-odd"><td><p>floor(x)</p></td>
<td><p>nearest integer less than or equal to argument</p></td>
</tr>
-<tr class="row-odd"><td><p>ln(x)</p></td>
+<tr class="row-even"><td><p>gcd(x, y)</p></td>
+<td><p>greatest common divisor</p></td>
+</tr>
+<tr class="row-odd"><td><p>lcm(x, y)</p></td>
+<td><p>least common multiple</p></td>
+</tr>
+<tr class="row-even"><td><p>ln(x)</p></td>
<td><p>natural logarithm</p></td>
</tr>
-<tr class="row-even"><td><p>log(base, x)</p></td>
+<tr class="row-odd"><td><p>log(base, x)</p></td>
<td><p>logarithm of x for a particular base</p></td>
</tr>
-<tr class="row-odd"><td><p>log10(x)</p></td>
+<tr class="row-even"><td><p>log10(x)</p></td>
<td><p>base 10 logarithm</p></td>
</tr>
-<tr class="row-even"><td><p>log2(x)</p></td>
+<tr class="row-odd"><td><p>log2(x)</p></td>
<td><p>base 2 logarithm</p></td>
</tr>
-<tr class="row-odd"><td><p>pi()</p></td>
+<tr class="row-even"><td><p>pi()</p></td>
<td><p>approximate value of π</p></td>
</tr>
-<tr class="row-even"><td><p>power(base, exponent)</p></td>
+<tr class="row-odd"><td><p>power(base, exponent)</p></td>
<td><p>base raised to the power of exponent</p></td>
</tr>
-<tr class="row-odd"><td><p>radians(x)</p></td>
+<tr class="row-even"><td><p>radians(x)</p></td>
<td><p>converts degrees to radians</p></td>
</tr>
-<tr class="row-even"><td><p>round(x)</p></td>
+<tr class="row-odd"><td><p>round(x)</p></td>
<td><p>round to nearest integer</p></td>
</tr>
-<tr class="row-odd"><td><p>signum(x)</p></td>
+<tr class="row-even"><td><p>signum(x)</p></td>
<td><p>sign of the argument (-1, 0, +1)</p></td>
</tr>
-<tr class="row-even"><td><p>sin(x)</p></td>
+<tr class="row-odd"><td><p>sin(x)</p></td>
<td><p>sine</p></td>
</tr>
-<tr class="row-odd"><td><p>sinh(x)</p></td>
+<tr class="row-even"><td><p>sinh(x)</p></td>
<td><p>hyperbolic sine</p></td>
</tr>
-<tr class="row-even"><td><p>sqrt(x)</p></td>
+<tr class="row-odd"><td><p>sqrt(x)</p></td>
<td><p>square root</p></td>
</tr>
-<tr class="row-odd"><td><p>tan(x)</p></td>
+<tr class="row-even"><td><p>tan(x)</p></td>
<td><p>tangent</p></td>
</tr>
-<tr class="row-even"><td><p>tanh(x)</p></td>
+<tr class="row-odd"><td><p>tanh(x)</p></td>
<td><p>hyperbolic tangent</p></td>
</tr>
-<tr class="row-odd"><td><p>trunc(x)</p></td>
+<tr class="row-even"><td><p>trunc(x)</p></td>
<td><p>truncate toward zero</p></td>
</tr>
</tbody>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 660147cb33..5160231a59 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -505,6 +505,22 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#factorial">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ factorial
+ </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>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#floor">
<code class="docutils literal notranslate">
@@ -515,7 +531,39 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id14">
+ <a class="reference internal nav-link" href="#id15">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#gcd">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ gcd
+ </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="#id16">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#lcm">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ lcm
+ </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="#id17">
Arguments
</a>
</li>
@@ -531,7 +579,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id15">
+ <a class="reference internal nav-link" href="#id18">
Arguments
</a>
</li>
@@ -547,7 +595,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id16">
+ <a class="reference internal nav-link" href="#id19">
Arguments
</a>
</li>
@@ -563,7 +611,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id17">
+ <a class="reference internal nav-link" href="#id20">
Arguments
</a>
</li>
@@ -579,7 +627,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id18">
+ <a class="reference internal nav-link" href="#id21">
Arguments
</a>
</li>
@@ -604,7 +652,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id19">
+ <a class="reference internal nav-link" href="#id22">
Arguments
</a>
</li>
@@ -634,7 +682,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id20">
+ <a class="reference internal nav-link" href="#id23">
Arguments
</a>
</li>
@@ -659,7 +707,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id21">
+ <a class="reference internal nav-link" href="#id24">
Arguments
</a>
</li>
@@ -675,7 +723,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id22">
+ <a class="reference internal nav-link" href="#id25">
Arguments
</a>
</li>
@@ -691,7 +739,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id23">
+ <a class="reference internal nav-link" href="#id26">
Arguments
</a>
</li>
@@ -707,7 +755,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id24">
+ <a class="reference internal nav-link" href="#id27">
Arguments
</a>
</li>
@@ -723,7 +771,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id25">
+ <a class="reference internal nav-link" href="#id28">
Arguments
</a>
</li>
@@ -739,7 +787,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id26">
+ <a class="reference internal nav-link" href="#id29">
Arguments
</a>
</li>
@@ -755,7 +803,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id27">
+ <a class="reference internal nav-link" href="#id30">
Arguments
</a>
</li>
@@ -771,7 +819,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id28">
+ <a class="reference internal nav-link" href="#id31">
Arguments
</a>
</li>
@@ -794,7 +842,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id29">
+ <a class="reference internal nav-link" href="#id32">
Arguments
</a>
</li>
@@ -810,7 +858,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id30">
+ <a class="reference internal nav-link" href="#id33">
Arguments
</a>
</li>
@@ -833,7 +881,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id31">
+ <a class="reference internal nav-link" href="#id34">
Arguments
</a>
</li>
@@ -849,7 +897,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id32">
+ <a class="reference internal nav-link" href="#id35">
Arguments
</a>
</li>
@@ -865,7 +913,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id33">
+ <a class="reference internal nav-link" href="#id36">
Arguments
</a>
</li>
@@ -899,7 +947,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id34">
+ <a class="reference internal nav-link" href="#id37">
Arguments
</a>
</li>
@@ -915,7 +963,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id35">
+ <a class="reference internal nav-link" href="#id38">
Arguments
</a>
</li>
@@ -931,7 +979,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id36">
+ <a class="reference internal nav-link" href="#id39">
Arguments
</a>
</li>
@@ -947,7 +995,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id37">
+ <a class="reference internal nav-link" href="#id40">
Arguments
</a>
</li>
@@ -963,7 +1011,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id38">
+ <a class="reference internal nav-link" href="#id41">
Arguments
</a>
</li>
@@ -979,12 +1027,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id39">
+ <a class="reference internal nav-link" href="#id42">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id40">
+ <a class="reference internal nav-link" href="#id43">
Aliases
</a>
</li>
@@ -1000,7 +1048,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id41">
+ <a class="reference internal nav-link" href="#id44">
Arguments
</a>
</li>
@@ -1016,7 +1064,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id42">
+ <a class="reference internal nav-link" href="#id45">
Arguments
</a>
</li>
@@ -1032,12 +1080,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id43">
+ <a class="reference internal nav-link" href="#id46">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id44">
+ <a class="reference internal nav-link" href="#id47">
Arguments
</a>
</li>
@@ -1053,7 +1101,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id45">
+ <a class="reference internal nav-link" href="#id48">
Arguments
</a>
</li>
@@ -1069,7 +1117,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id46">
+ <a class="reference internal nav-link" href="#id49">
Arguments
</a>
</li>
@@ -1085,7 +1133,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id47">
+ <a class="reference internal nav-link" href="#id50">
Arguments
</a>
</li>
@@ -1101,7 +1149,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id48">
+ <a class="reference internal nav-link" href="#id51">
Arguments
</a>
</li>
@@ -1117,7 +1165,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id49">
+ <a class="reference internal nav-link" href="#id52">
Arguments
</a>
</li>
@@ -1133,7 +1181,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id50">
+ <a class="reference internal nav-link" href="#id53">
Arguments
</a>
</li>
@@ -1149,7 +1197,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id51">
+ <a class="reference internal nav-link" href="#id54">
Arguments
</a>
</li>
@@ -1165,7 +1213,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id52">
+ <a class="reference internal nav-link" href="#id55">
Arguments
</a>
</li>
@@ -1181,7 +1229,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id53">
+ <a class="reference internal nav-link" href="#id56">
Arguments
</a>
</li>
@@ -1197,7 +1245,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id54">
+ <a class="reference internal nav-link" href="#id57">
Arguments
</a>
</li>
@@ -1213,7 +1261,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id55">
+ <a class="reference internal nav-link" href="#id58">
Arguments
</a>
</li>
@@ -1238,7 +1286,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id56">
+ <a class="reference internal nav-link" href="#id59">
Arguments
</a>
</li>
@@ -1254,7 +1302,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id57">
+ <a class="reference internal nav-link" href="#id60">
Arguments
</a>
</li>
@@ -1270,7 +1318,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id58">
+ <a class="reference internal nav-link" href="#id61">
Arguments
</a>
</li>
@@ -1302,7 +1350,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id59">
+ <a class="reference internal nav-link" href="#id62">
Arguments
</a>
</li>
@@ -1318,7 +1366,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id60">
+ <a class="reference internal nav-link" href="#id63">
Arguments
</a>
</li>
@@ -1368,7 +1416,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id61">
+ <a class="reference internal nav-link" href="#id64">
Arguments
</a>
</li>
@@ -1384,12 +1432,12 @@
</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="#id65">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id63">
+ <a class="reference internal nav-link" href="#id66">
Aliases
</a>
</li>
@@ -1414,12 +1462,12 @@
</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="#id67">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id65">
+ <a class="reference internal nav-link" href="#id68">
Aliases
</a>
</li>
@@ -1444,7 +1492,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id66">
+ <a class="reference internal nav-link" href="#id69">
Arguments
</a>
</li>
@@ -1460,7 +1508,7 @@
</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="#id70">
Arguments
</a>
</li>
@@ -1476,7 +1524,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id68">
+ <a class="reference internal nav-link" href="#id71">
Arguments
</a>
</li>
@@ -1492,7 +1540,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="#id72">
Arguments
</a>
</li>
@@ -1508,7 +1556,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="#id73">
Arguments
</a>
</li>
@@ -1524,7 +1572,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="#id74">
Arguments
</a>
</li>
@@ -1547,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="#id72">
+ <a class="reference internal nav-link" href="#id75">
Arguments
</a>
</li>
@@ -1563,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="#id73">
+ <a class="reference internal nav-link" href="#id76">
Arguments
</a>
</li>
@@ -1579,7 +1627,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="#id77">
Arguments
</a>
</li>
@@ -1595,7 +1643,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="#id78">
Arguments
</a>
</li>
@@ -1611,7 +1659,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="#id79">
Arguments
</a>
</li>
@@ -1627,7 +1675,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="#id80">
Arguments
</a>
</li>
@@ -1650,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="#id78">
+ <a class="reference internal nav-link" href="#id81">
Arguments
</a>
</li>
@@ -1666,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="#id79">
+ <a class="reference internal nav-link" href="#id82">
Arguments
</a>
</li>
@@ -1682,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="#id80">
+ <a class="reference internal nav-link" href="#id83">
Arguments
</a>
</li>
@@ -1698,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="#id81">
+ <a class="reference internal nav-link" href="#id84">
Arguments
</a>
</li>
@@ -1771,7 +1819,10 @@
<li><p><a class="reference internal" href="#cosh">cosh</a></p></li>
<li><p><a class="reference internal" href="#degrees">degrees</a></p></li>
<li><p><a class="reference internal" href="#exp">exp</a></p></li>
+<li><p><a class="reference internal" href="#factorial">factorial</a></p></li>
<li><p><a class="reference internal" href="#floor">floor</a></p></li>
+<li><p><a class="reference internal" href="#gcd">gcd</a></p></li>
+<li><p><a class="reference internal" href="#lcm">lcm</a></p></li>
<li><p><a class="reference internal" href="#ln">ln</a></p></li>
<li><p><a class="reference internal" href="#log">log</a></p></li>
<li><p><a class="reference internal" href="#log10">log10</a></p></li>
@@ -1988,28 +2039,74 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</ul>
</section>
</section>
+<section id="factorial">
+<h3><code class="docutils literal notranslate"><span
class="pre">factorial</span></code><a class="headerlink" href="#factorial"
title="Permalink to this heading">¶</a></h3>
+<p>Factorial. Returns 1 if value is less than 2.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">factorial</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
+</pre></div>
+</div>
+<section id="id14">
+<h4>Arguments<a class="headerlink" href="#id14" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
<section id="floor">
<h3><code class="docutils literal notranslate"><span
class="pre">floor</span></code><a class="headerlink" href="#floor"
title="Permalink to this heading">¶</a></h3>
<p>Returns the nearest integer less than or equal to a number.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">floor</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id14">
-<h4>Arguments<a class="headerlink" href="#id14" title="Permalink to this
heading">¶</a></h4>
+<section id="id15">
+<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
</ul>
</section>
</section>
+<section id="gcd">
+<h3><code class="docutils literal notranslate"><span
class="pre">gcd</span></code><a class="headerlink" href="#gcd" title="Permalink
to this heading">¶</a></h3>
+<p>Returns the greatest common divisor of <code class="docutils literal
notranslate"><span class="pre">expression_x</span></code> and <code
class="docutils literal notranslate"><span
class="pre">expression_y</span></code>. Returns 0 if both inputs are zero.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">gcd</span><span
class="p">(</span><span class="n">expression_x</span><span class="p">,</span>
<span class="n">expression_y</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id16">
+<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_x</strong>: First numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+<li><p><strong>expression_y</strong>: Second numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="lcm">
+<h3><code class="docutils literal notranslate"><span
class="pre">lcm</span></code><a class="headerlink" href="#lcm" title="Permalink
to this heading">¶</a></h3>
+<p>Returns the least common multiple of <code class="docutils literal
notranslate"><span class="pre">expression_x</span></code> and <code
class="docutils literal notranslate"><span
class="pre">expression_y</span></code>. Returns 0 if either input is zero.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lcm</span><span
class="p">(</span><span class="n">expression_x</span><span class="p">,</span>
<span class="n">expression_y</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id17">
+<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_x</strong>: First numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+<li><p><strong>expression_y</strong>: Second numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
<section id="ln">
<h3><code class="docutils literal notranslate"><span
class="pre">ln</span></code><a class="headerlink" href="#ln" title="Permalink
to this heading">¶</a></h3>
<p>Returns the natural logarithm of a number.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">ln</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id15">
-<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
+<section id="id18">
+<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2024,8 +2121,8 @@ Can either provide a specified base, or if omitted then
takes the base-10 of a n
<span class="n">log</span><span class="p">(</span><span
class="n">numeric_expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id16">
-<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
+<section id="id19">
+<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>base</strong>: Base numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2040,8 +2137,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">log10</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id17">
-<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
+<section id="id20">
+<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2054,8 +2151,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">log2</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id18">
-<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
+<section id="id21">
+<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2075,8 +2172,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">power</span><span
class="p">(</span><span class="n">base</span><span class="p">,</span> <span
class="n">exponent</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id19">
-<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
+<section id="id22">
+<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>base</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2101,8 +2198,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">radians</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id20">
-<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
+<section id="id23">
+<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
<ul>
<li><h1 class="rubric"
id="numeric-expression-numeric-expression-to-operate-on-can-be-a-constant-column-or-function-and-any-combination-of-arithmetic-operators"><strong>numeric_expression</strong>:
Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</h1>
@@ -2124,8 +2221,8 @@ The random seed is unique to each row.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">round</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id21">
-<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
+<section id="id24">
+<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2140,8 +2237,8 @@ Zero and positive numbers return <code class="docutils
literal notranslate"><spa
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">signum</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id22">
-<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
+<section id="id25">
+<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2154,8 +2251,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">sin</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id23">
-<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
+<section id="id26">
+<h4>Arguments<a class="headerlink" href="#id26" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2168,8 +2265,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">sinh</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id24">
-<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
+<section id="id27">
+<h4>Arguments<a class="headerlink" href="#id27" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2182,8 +2279,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">sqrt</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id25">
-<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
+<section id="id28">
+<h4>Arguments<a class="headerlink" href="#id28" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2196,8 +2293,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">tan</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id26">
-<h4>Arguments<a class="headerlink" href="#id26" title="Permalink to this
heading">¶</a></h4>
+<section id="id29">
+<h4>Arguments<a class="headerlink" href="#id29" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2210,8 +2307,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">tanh</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id27">
-<h4>Arguments<a class="headerlink" href="#id27" title="Permalink to this
heading">¶</a></h4>
+<section id="id30">
+<h4>Arguments<a class="headerlink" href="#id30" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2224,8 +2321,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">trunc</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id28">
-<h4>Arguments<a class="headerlink" href="#id28" title="Permalink to this
heading">¶</a></h4>
+<section id="id31">
+<h4>Arguments<a class="headerlink" href="#id31" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2247,8 +2344,8 @@ This function is often used to substitute a default value
for <em>null</em> valu
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">coalesce</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="id29">
-<h4>Arguments<a class="headerlink" href="#id29" title="Permalink to this
heading">¶</a></h4>
+<section id="id32">
+<h4>Arguments<a class="headerlink" href="#id32" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1, expression_n</strong>:
Expression to use if previous expressions are <em>null</em>.
@@ -2264,8 +2361,8 @@ This can be used to perform the inverse operation of <a
class="reference interna
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">nullif</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id30">
-<h4>Arguments<a class="headerlink" href="#id30" title="Permalink to this
heading">¶</a></h4>
+<section id="id33">
+<h4>Arguments<a class="headerlink" href="#id33" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: Expression to compare and return if equal
to expression2.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2315,8 +2412,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">ascii</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id31">
-<h4>Arguments<a class="headerlink" href="#id31" title="Permalink to this
heading">¶</a></h4>
+<section id="id34">
+<h4>Arguments<a class="headerlink" href="#id34" 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>
@@ -2331,8 +2428,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">bit_length</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id32">
-<h4>Arguments<a class="headerlink" href="#id32" title="Permalink to this
heading">¶</a></h4>
+<section id="id35">
+<h4>Arguments<a class="headerlink" href="#id35" 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>
@@ -2350,8 +2447,8 @@ of the input string.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">btrim</span><span
class="p">(</span><span class="nb">str</span><span class="p">[,</span> <span
class="n">trim_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id33">
-<h4>Arguments<a class="headerlink" href="#id33" title="Permalink to this
heading">¶</a></h4>
+<section id="id36">
+<h4>Arguments<a class="headerlink" href="#id36" 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>
@@ -2379,8 +2476,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">concat</span><span
class="p">(</span><span class="nb">str</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span class="n">str_n</span><span
class="p">])</span>
</pre></div>
</div>
-<section id="id34">
-<h4>Arguments<a class="headerlink" href="#id34" title="Permalink to this
heading">¶</a></h4>
+<section id="id37">
+<h4>Arguments<a class="headerlink" href="#id37" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to concatenate.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2396,8 +2493,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">concat</span><span
class="p">(</span><span class="n">separator</span><span class="p">,</span>
<span class="nb">str</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span class="n">str_n</span><span
class="p">])</span>
</pre></div>
</div>
-<section id="id35">
-<h4>Arguments<a class="headerlink" href="#id35" title="Permalink to this
heading">¶</a></h4>
+<section id="id38">
+<h4>Arguments<a class="headerlink" href="#id38" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>separator</strong>: Separator to insert between concatenated
strings.</p></li>
<li><p><strong>str</strong>: String expression to concatenate.
@@ -2414,8 +2511,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="nb">chr</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id36">
-<h4>Arguments<a class="headerlink" href="#id36" title="Permalink to this
heading">¶</a></h4>
+<section id="id39">
+<h4>Arguments<a class="headerlink" href="#id39" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression containing the ASCII or Unicode
code value to operate on.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -2432,8 +2529,8 @@ Words are delimited by non-alphanumeric characters.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">initcap</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id37">
-<h4>Arguments<a class="headerlink" href="#id37" title="Permalink to this
heading">¶</a></h4>
+<section id="id40">
+<h4>Arguments<a class="headerlink" href="#id40" 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>
@@ -2449,8 +2546,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">left</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id38">
-<h4>Arguments<a class="headerlink" href="#id38" title="Permalink to this
heading">¶</a></h4>
+<section id="id41">
+<h4>Arguments<a class="headerlink" href="#id41" 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>
@@ -2466,15 +2563,15 @@ 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">length</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id39">
-<h4>Arguments<a class="headerlink" href="#id39" title="Permalink to this
heading">¶</a></h4>
+<section id="id42">
+<h4>Arguments<a class="headerlink" href="#id42" 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>
</ul>
</section>
-<section id="id40">
-<h4>Aliases<a class="headerlink" href="#id40" title="Permalink to this
heading">¶</a></h4>
+<section id="id43">
+<h4>Aliases<a class="headerlink" href="#id43" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>char_length</p></li>
<li><p>character_length</p></li>
@@ -2490,8 +2587,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">lower</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id41">
-<h4>Arguments<a class="headerlink" href="#id41" title="Permalink to this
heading">¶</a></h4>
+<section id="id44">
+<h4>Arguments<a class="headerlink" href="#id44" 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>
@@ -2507,8 +2604,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">lpad</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">[,</span> <span
class="n">padding_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id42">
-<h4>Arguments<a class="headerlink" href="#id42" title="Permalink to this
heading">¶</a></h4>
+<section id="id45">
+<h4>Arguments<a class="headerlink" href="#id45" 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>
@@ -2527,8 +2624,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">ltrim</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id43">
-<h4>Arguments<a class="headerlink" href="#id43" title="Permalink to this
heading">¶</a></h4>
+<section id="id46">
+<h4>Arguments<a class="headerlink" href="#id46" 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>
@@ -2538,8 +2635,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<a class="reference internal" href="#rtrim">rtrim</a>,
<a class="reference internal" href="#trim">trim</a></p>
</section>
-<section id="id44">
-<h4>Arguments<a class="headerlink" href="#id44" title="Permalink to this
heading">¶</a></h4>
+<section id="id47">
+<h4>Arguments<a class="headerlink" href="#id47" 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>
@@ -2552,8 +2649,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">octet_length</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id45">
-<h4>Arguments<a class="headerlink" href="#id45" title="Permalink to this
heading">¶</a></h4>
+<section id="id48">
+<h4>Arguments<a class="headerlink" href="#id48" 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>
@@ -2569,8 +2666,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">repeat</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id46">
-<h4>Arguments<a class="headerlink" href="#id46" title="Permalink to this
heading">¶</a></h4>
+<section id="id49">
+<h4>Arguments<a class="headerlink" href="#id49" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2584,8 +2681,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">replace</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">,</span> <span
class="n">replacement</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id47">
-<h4>Arguments<a class="headerlink" href="#id47" title="Permalink to this
heading">¶</a></h4>
+<section id="id50">
+<h4>Arguments<a class="headerlink" href="#id50" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2602,8 +2699,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">reverse</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id48">
-<h4>Arguments<a class="headerlink" href="#id48" title="Permalink to this
heading">¶</a></h4>
+<section id="id51">
+<h4>Arguments<a class="headerlink" href="#id51" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2616,8 +2713,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">right</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id49">
-<h4>Arguments<a class="headerlink" href="#id49" title="Permalink to this
heading">¶</a></h4>
+<section id="id52">
+<h4>Arguments<a class="headerlink" href="#id52" 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>
@@ -2633,8 +2730,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">rpad</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">[,</span> <span
class="n">padding_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id50">
-<h4>Arguments<a class="headerlink" href="#id50" title="Permalink to this
heading">¶</a></h4>
+<section id="id53">
+<h4>Arguments<a class="headerlink" href="#id53" 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>
@@ -2653,8 +2750,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">rtrim</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id51">
-<h4>Arguments<a class="headerlink" href="#id51" title="Permalink to this
heading">¶</a></h4>
+<section id="id54">
+<h4>Arguments<a class="headerlink" href="#id54" 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>
@@ -2672,8 +2769,8 @@ specified position.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">split_part</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">,</span> <span
class="n">pos</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id52">
-<h4>Arguments<a class="headerlink" href="#id52" title="Permalink to this
heading">¶</a></h4>
+<section id="id55">
+<h4>Arguments<a class="headerlink" href="#id55" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to spit.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2688,8 +2785,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">starts_with</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id53">
-<h4>Arguments<a class="headerlink" href="#id53" title="Permalink to this
heading">¶</a></h4>
+<section id="id56">
+<h4>Arguments<a class="headerlink" href="#id56" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to test.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2705,8 +2802,8 @@ If the substring does not exist in the string, the
function returns 0.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">strpos</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id54">
-<h4>Arguments<a class="headerlink" href="#id54" title="Permalink to this
heading">¶</a></h4>
+<section id="id57">
+<h4>Arguments<a class="headerlink" href="#id57" 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>
@@ -2722,8 +2819,8 @@ starting position in a string.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">substr</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">start_pos</span><span class="p">[,</span> <span
class="n">length</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id55">
-<h4>Arguments<a class="headerlink" href="#id55" title="Permalink to this
heading">¶</a></h4>
+<section id="id58">
+<h4>Arguments<a class="headerlink" href="#id58" 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>
@@ -2754,8 +2851,8 @@ characters at the same position in the
<strong>chars</strong> string.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_hex</span><span
class="p">(</span><span class="nb">int</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id56">
-<h4>Arguments<a class="headerlink" href="#id56" title="Permalink to this
heading">¶</a></h4>
+<section id="id59">
+<h4>Arguments<a class="headerlink" href="#id59" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>int</strong>: Integer expression to convert.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2768,8 +2865,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">trim</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id57">
-<h4>Arguments<a class="headerlink" href="#id57" title="Permalink to this
heading">¶</a></h4>
+<section id="id60">
+<h4>Arguments<a class="headerlink" href="#id60" 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>
@@ -2786,8 +2883,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">upper</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id58">
-<h4>Arguments<a class="headerlink" href="#id58" title="Permalink to this
heading">¶</a></h4>
+<section id="id61">
+<h4>Arguments<a class="headerlink" href="#id61" 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>
@@ -2819,8 +2916,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="id59">
-<h4>Arguments<a class="headerlink" href="#id59" title="Permalink to this
heading">¶</a></h4>
+<section id="id62">
+<h4>Arguments<a class="headerlink" href="#id62" 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>
@@ -2835,8 +2932,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="id60">
-<h4>Arguments<a class="headerlink" href="#id60" title="Permalink to this
heading">¶</a></h4>
+<section id="id63">
+<h4>Arguments<a class="headerlink" href="#id63" 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>
@@ -2911,8 +3008,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="id61">
-<h4>Arguments<a class="headerlink" href="#id61" 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>interval</strong>: Bin interval.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on.
@@ -2941,8 +3038,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="id62">
-<h4>Arguments<a class="headerlink" href="#id62" 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>precision</strong>: Time precision to truncate to.
The following precisions are supported:</p>
@@ -2961,8 +3058,8 @@ The following precisions are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id63">
-<h4>Aliases<a class="headerlink" href="#id63" title="Permalink to this
heading">¶</a></h4>
+<section id="id66">
+<h4>Aliases<a class="headerlink" href="#id66" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datetrunc</p></li>
</ul>
@@ -2978,8 +3075,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="id64">
-<h4>Arguments<a class="headerlink" href="#id64" 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>part</strong>: Part of the date to return.
The following date parts are supported:</p>
@@ -3002,8 +3099,8 @@ The following date parts are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id65">
-<h4>Aliases<a class="headerlink" href="#id65" 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>datepart</p></li>
</ul>
@@ -3020,8 +3117,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="id66">
-<h4>Arguments<a class="headerlink" href="#id66" 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>field</strong>: Part or field of the date to return.
The following date fields are supported:</p>
@@ -3054,8 +3151,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="id67">
-<h4>Arguments<a class="headerlink" href="#id67" title="Permalink to this
heading">¶</a></h4>
+<section id="id70">
+<h4>Arguments<a class="headerlink" href="#id70" 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>
@@ -3071,8 +3168,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="id68">
-<h4>Arguments<a class="headerlink" href="#id68" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3088,8 +3185,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="id69">
-<h4>Arguments<a class="headerlink" href="#id69" 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>
@@ -3105,8 +3202,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="id70">
-<h4>Arguments<a class="headerlink" href="#id70" 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>
@@ -3121,8 +3218,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="id71">
-<h4>Arguments<a class="headerlink" href="#id71" 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>
@@ -3146,8 +3243,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">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="id72">
-<h4>Arguments<a class="headerlink" href="#id72" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3173,8 +3270,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="id73">
-<h4>Arguments<a class="headerlink" href="#id73" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3187,8 +3284,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="id74">
-<h4>Arguments<a class="headerlink" href="#id74" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3201,8 +3298,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="id75">
-<h4>Arguments<a class="headerlink" href="#id75" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3215,8 +3312,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="id76">
-<h4>Arguments<a class="headerlink" href="#id76" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3229,8 +3326,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="id77">
-<h4>Arguments<a class="headerlink" href="#id77" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3252,8 +3349,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">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="id78">
-<h4>Arguments<a class="headerlink" href="#id78" 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>expression_n</strong>: Expression to include in the output
array.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3267,8 +3364,8 @@ string operators.</p></li>
<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="id79">
-<h4>Arguments<a class="headerlink" href="#id79" 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>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3284,8 +3381,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="id80">
-<h4>Arguments<a class="headerlink" href="#id80" 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>expression</strong>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3301,8 +3398,8 @@ For example: <code class="docutils literal
notranslate"><span class="pre">c0</sp
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">struct</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="id81">
-<h4>Arguments<a class="headerlink" href="#id81" 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>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
