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 234df7e488 Publish built docs triggered by
3ad7734a7e5b1844b02f1374d0dc1c441bef216d
234df7e488 is described below
commit 234df7e488877d6bd4c2d82fadacd024bfcd3352
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Apr 17 10:32:28 2023 +0000
Publish built docs triggered by 3ad7734a7e5b1844b02f1374d0dc1c441bef216d
---
_sources/user-guide/sql/aggregate_functions.md.txt | 25 +-
_sources/user-guide/sql/data_types.md.txt | 28 +-
_sources/user-guide/sql/ddl.md.txt | 34 +-
_sources/user-guide/sql/explain.md.txt | 4 +-
_sources/user-guide/sql/scalar_functions.md.txt | 123 ++++-
_sources/user-guide/sql/select.md.txt | 16 +-
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 146 +++--
user-guide/sql/data_types.html | 4 +-
user-guide/sql/ddl.html | 42 +-
user-guide/sql/explain.html | 4 +-
user-guide/sql/index.html | 2 +
user-guide/sql/scalar_functions.html | 601 ++++++++++++++-------
user-guide/sql/select.html | 20 +-
14 files changed, 763 insertions(+), 288 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index fff547f257..497cf78aad 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -27,6 +27,7 @@ Aggregate functions operate on a set of values to compute a
single result.
- [count](#count)
- [max](#max)
- [mean](#mean)
+- [median](#median)
- [min](#min)
- [sum](#sum)
- [array_agg](#array_agg)
@@ -82,6 +83,19 @@ max(expression)
_Alias of [avg](#avg)._
+### `median`
+
+Returns the median value in the specified column.
+
+```
+median(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
### `min`
Returns the minimum value in the specified column.
@@ -110,7 +124,16 @@ sum(expression)
### `array_agg`
-<!-- TODO: Add array_agg documentation -->
+Returns an array created from the expression elements.
+
+```
+array_agg(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
## Statistical
diff --git a/_sources/user-guide/sql/data_types.md.txt
b/_sources/user-guide/sql/data_types.md.txt
index 2753b014dc..063976dc3d 100644
--- a/_sources/user-guide/sql/data_types.md.txt
+++ b/_sources/user-guide/sql/data_types.md.txt
@@ -60,20 +60,20 @@ For example, to cast the output of `now()` to a `Timestamp`
with second precisio
## Numeric Types
-| SQL DataType | Arrow DataType | Notes
|
-| ------------------------------------ | :---------------------------- |
-----------------------------------------------------------------------------------------------------------
|
-| `TINYINT` | `Int8` |
|
-| `SMALLINT` | `Int16` |
|
-| `INT` or `INTEGER` | `Int32` |
|
-| `BIGINT` | `Int64` |
|
-| `TINYINT UNSIGNED` | `UInt8` |
|
-| `SMALLINT UNSIGNED` | `UInt16` |
|
-| `INT UNSIGNED` or `INTEGER UNSIGNED` | `UInt32` |
|
-| `BIGINT UNSIGNED` | `UInt64` |
|
-| `FLOAT` | `Float32` |
|
-| `REAL` | `Float32` |
|
-| `DOUBLE` | `Float64` |
|
-| `DECIMAL(precision,scale)` | `Decimal128(precision,scale)` |
Decimal support is currently experimental
([#3523](https://github.com/apache/arrow-datafusion/issues/3523)) |
+| SQL DataType | Arrow DataType |
Notes
|
+| ------------------------------------ | :----------------------------- |
-----------------------------------------------------------------------------------------------------------
|
+| `TINYINT` | `Int8` |
|
+| `SMALLINT` | `Int16` |
|
+| `INT` or `INTEGER` | `Int32` |
|
+| `BIGINT` | `Int64` |
|
+| `TINYINT UNSIGNED` | `UInt8` |
|
+| `SMALLINT UNSIGNED` | `UInt16` |
|
+| `INT UNSIGNED` or `INTEGER UNSIGNED` | `UInt32` |
|
+| `BIGINT UNSIGNED` | `UInt64` |
|
+| `FLOAT` | `Float32` |
|
+| `REAL` | `Float32` |
|
+| `DOUBLE` | `Float64` |
|
+| `DECIMAL(precision, scale)` | `Decimal128(precision, scale)` |
Decimal support is currently experimental
([#3523](https://github.com/apache/arrow-datafusion/issues/3523)) |
## Date/Time Types
diff --git a/_sources/user-guide/sql/ddl.md.txt
b/_sources/user-guide/sql/ddl.md.txt
index 8de29b4e50..45d7d81a0a 100644
--- a/_sources/user-guide/sql/ddl.md.txt
+++ b/_sources/user-guide/sql/ddl.md.txt
@@ -19,6 +19,32 @@
# DDL
+## CREATE DATABASE
+
+Create catalog with specified name.
+
+<pre>
+CREATE DATABASE [ IF NOT EXISTS ] <i><b>catalog</i></b>
+</pre>
+
+```sql
+-- create catalog cat
+CREATE DATABASE cat;
+```
+
+## CREATE SCHEMA
+
+Create schema under specified catalog, or the default DataFusion catalog if
not specified.
+
+<pre>
+CREATE SCHEMA [ IF NOT EXISTS ] [ <i><b>catalog.</i></b> ]
<b><i>schema_name</i></b>
+</pre>
+
+```sql
+-- create schema emu under catalog cat
+CREATE SCHEMA cat.emu;
+```
+
## CREATE EXTERNAL TABLE
Parquet data sources can be registered by executing a `CREATE EXTERNAL TABLE`
SQL statement. It is not necessary
@@ -67,7 +93,7 @@ When creating an output from a data source that is already
ordered by an express
the data using the `WITH ORDER` clause. This applies even if the expression
used for sorting is complex,
allowing for greater flexibility.
-Here's an example of how to use `WITH ORDER` query
+Here's an example of how to use `WITH ORDER` clause.
```sql
CREATE EXTERNAL TABLE test (
@@ -91,14 +117,14 @@ WITH ORDER (c2 ASC, c5 + c8 DESC NULL FIRST)
LOCATION '/path/to/aggregate_test_100.csv';
```
-where `WITH ORDER` clause specifies the sort order:
+Where `WITH ORDER` clause specifies the sort order:
```sql
WITH ORDER (sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }]
[, sort_expression2 [ASC | DESC] [NULLS { FIRST | LAST }] ...])
```
-### Cautions When Using the WITH ORDER Clause
+### Cautions when using the WITH ORDER Clause
- It's important to understand that using the `WITH ORDER` clause in the
`CREATE EXTERNAL TABLE` statement only specifies the order in which the data
should be read from the external file. If the data in the file is not already
sorted according to the specified order, then the results may not be correct.
@@ -153,7 +179,7 @@ DROP TABLE IF EXISTS nonexistent_table;
View is a virtual table based on the result of a SQL query. It can be created
from an existing table or values list.
<pre>
-CREATE VIEW <i><b>view_name</b></i> AS statement;
+CREATE [ OR REPLACE ] VIEW <i><b>view_name</b></i> AS statement;
</pre>
```sql
diff --git a/_sources/user-guide/sql/explain.md.txt
b/_sources/user-guide/sql/explain.md.txt
index ae0795f9ab..ca4169d577 100644
--- a/_sources/user-guide/sql/explain.md.txt
+++ b/_sources/user-guide/sql/explain.md.txt
@@ -28,7 +28,7 @@ EXPLAIN [ANALYZE] [VERBOSE] statement
## EXPLAIN
Shows the execution plan of a statement.
-If you need more details output, try to use `EXPLAIN VERBOSE`.
+If you need more detailed output, use `EXPLAIN VERBOSE`.
```sql
EXPLAIN SELECT SUM(x) FROM table GROUP BY b;
@@ -52,7 +52,7 @@ EXPLAIN SELECT SUM(x) FROM table GROUP BY b;
## EXPLAIN ANALYZE
Shows the execution plan and metrics of a statement.
-If you need more information output, try to use `EXPLAIN ANALYZE VERBOSE`.
+If you need more information output, use `EXPLAIN ANALYZE VERBOSE`.
```sql
EXPLAIN ANALYZE SELECT SUM(x) FROM table GROUP BY b;
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 0414ffdd31..25002e572d 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -36,10 +36,12 @@
- [exp](#exp)
- [floor](#floor)
- [ln](#ln)
+- [log](#log)
- [log10](#log10)
- [log2](#log2)
- [pi](#pi)
- [power](#power)
+- [pow](#pow)
- [random](#random)
- [round](#round)
- [signum](#signum)
@@ -247,6 +249,23 @@ ln(numeric_expression)
- **numeric_expression**: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
+### `log`
+
+Returns the base-x logarithm of a number.
+Can either provide a specified base, or if omitted then takes the base-10 of a
number.
+
+```
+log(base, numeric_expression)
+log(numeric_expression)
+```
+
+#### Arguments
+
+- **base**: Base numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+- **numeric_expression**: Numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
### `log10`
Returns the base-10 logarithm of a number.
@@ -262,7 +281,7 @@ log10(numeric_expression)
### `log2`
-Returns the base-2 logarithm or a number.
+Returns the base-2 logarithm of a number.
```
log2(numeric_expression)
@@ -283,7 +302,7 @@ pi()
### `power`
-Returns a base number raised to the power of an exponent.
+Returns a base expression raised to the power of an exponent.
```
power(base, exponent)
@@ -291,14 +310,22 @@ power(base, exponent)
#### Arguments
-- **power**: Base numeric expression to operate on.
+- **base**: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
- **exponent**: Exponent numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
+#### Aliases
+
+- pow
+
+### `pow`
+
+_Alias of [power](#power)._
+
### `random`
-Returns a random float value between 0 and 1.
+Returns a random float value in the range [0, 1).
The random seed is unique to each row.
```
@@ -480,6 +507,7 @@ nullif(expression1, expression2)
- [translate](#translate)
- [trim](#trim)
- [upper](#upper)
+- [uuid](#uuid)
### `ascii`
@@ -673,7 +701,7 @@ lower(str)
### `lpad`
-Pads the left side a string with another string to a specified string length.
+Pads the left side of a string with another string to a specified string
length.
```
lpad(str, n[, padding_str])
@@ -794,7 +822,7 @@ right(str, n)
### `rpad`
-right side a string with another string to a specified string length.
+Pads the right side of a string with another string to a specified string
length.
```
rpad(str, n[, padding_str])
@@ -832,7 +860,7 @@ rtrim(str)
### `split_part`
-Splits a string based on a specified delimiter and returns the substring a the
+Splits a string based on a specified delimiter and returns the substring in the
specified position.
```
@@ -957,6 +985,14 @@ upper(str)
[initcap](#initcap),
[lower](#lower)
+### `uuid`
+
+Returns UUID v4 string value which is unique per row.
+
+```
+uuid()
+```
+
## Regular Expression Functions
Apache DataFusion uses the POSIX regular expression syntax and
@@ -1004,9 +1040,13 @@ regexp_replace(str, regexp, replacement, flags)
## Time and Date Functions
- [now](#now)
+- [current_date](#current_date)
+- [current_time](#current_time)
- [date_bin](#date_bin)
- [date_trunc](#date_trunc)
+- [datetrunc](#datetrunc)
- [date_part](#date_part)
+- [datepart](#datepart)
- [extract](#extract)
- [to_timestamp](#to_timestamp)
- [to_timestamp_millis](#to_timestamp_millis)
@@ -1025,6 +1065,28 @@ no matter when in the query plan the function executes.
now()
```
+### `current_date`
+
+Returns the current UTC date.
+
+The `current_date()` return value is determined at query time and will return
the same date,
+no matter when in the query plan the function executes.
+
+```
+current_date()
+```
+
+### `current_time`
+
+Returns the current UTC time.
+
+The `current_time()` return value is determined at query time and will return
the same time,
+no matter when in the query plan the function executes.
+
+```
+current_time()
+```
+
### `date_bin`
Calculates time intervals and returns the start of the interval nearest to the
specified timestamp.
@@ -1084,6 +1146,14 @@ date_trunc(precision, expression)
- **expression**: Time expression to operate on.
Can be a constant, column, or function.
+#### Aliases
+
+- datetrunc
+
+### `datetrunc`
+
+_Alias of [date_trunc](#date_trunc)._
+
### `date_part`
Returns the specified part of the date as an integer.
@@ -1113,6 +1183,14 @@ date_part(part, expression)
- **expression**: Time expression to operate on.
Can be a constant, column, or function.
+#### Aliases
+
+- datepart
+
+### `datepart`
+
+_Alias of [date_part](#date_part)._
+
### `extract`
Returns a sub-field from a time value as an integer.
@@ -1224,12 +1302,37 @@ from_unixtime(expression)
## Hashing Functions
+- [digest](#digest)
- [md5](#md5)
- [sha224](#sha224)
- [sha256](#sha256)
- [sha384](#sha384)
- [sha512](#sha512)
+### `digest`
+
+Computes the binary hash of an expression using the specified algorithm.
+
+```
+digest(expression, algorithm)
+```
+
+#### Arguments
+
+- **expression**: String expression to operate on.
+ Can be a constant, column, or function, and any combination of string
operators.
+- **algorithm**: String expression specifying algorithm to use.
+ Must be one of:
+
+ - md5
+ - sha224
+ - sha256
+ - sha384
+ - sha512
+ - blake2s
+ - blake2b
+ - blake3
+
### `md5`
Computes an MD5 128-bit checksum for a string expression.
@@ -1297,17 +1400,17 @@ sha512(expression)
## Other Functions
-- [array](#array)
+- [make_array](#make_array)
- [arrow_cast](#arrow_cast)
- [arrow_typeof](#arrow_typeof)
- [struct](#struct)
-### `array`
+### `make_array`
Returns an Arrow array using the specified input expressions.
```
-array(expression1[, ..., expression_n])
+make_array(expression1[, ..., expression_n])
```
#### Arguments
diff --git a/_sources/user-guide/sql/select.md.txt
b/_sources/user-guide/sql/select.md.txt
index 3eea252d70..68be88d7cf 100644
--- a/_sources/user-guide/sql/select.md.txt
+++ b/_sources/user-guide/sql/select.md.txt
@@ -83,7 +83,7 @@ SELECT a FROM table WHERE a > 10
## JOIN clause
-DataFusion supports `INNER JOIN`, `LEFT OUTER JOIN`, `RIGHT OUTER JOIN`, `FULL
OUTER JOIN`, and `CROSS JOIN`.
+DataFusion supports `INNER JOIN`, `LEFT OUTER JOIN`, `RIGHT OUTER JOIN`, `FULL
OUTER JOIN`, `NATURAL JOIN` and `CROSS JOIN`.
The following examples are based on this table:
@@ -153,6 +153,20 @@ either side of the join where there is not a match.
+----------+----------+----------+----------+
```
+### NATURAL JOIN
+
+A natural join defines an inner join based on common column names found
between the input tables. When no common
+column names are found, it behaves like a cross join.
+
+```sql
+❯ select * from x natural join x y;
++----------+----------+
+| column_1 | column_2 |
++----------+----------+
+| 1 | 2 |
++----------+----------+
+```
+
### CROSS JOIN
A cross join produces a cartesian product that matches every row in the left
side of the join with every row in the
diff --git a/searchindex.js b/searchindex.js
index 2b16898a10..385d59d051 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 541491c995..07a4377eb4 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -345,6 +345,22 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#median">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ median
+ </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="#id3">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#min">
<code class="docutils literal notranslate">
@@ -355,7 +371,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id3">
+ <a class="reference internal nav-link" href="#id4">
Arguments
</a>
</li>
@@ -371,7 +387,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id4">
+ <a class="reference internal nav-link" href="#id5">
Arguments
</a>
</li>
@@ -385,6 +401,13 @@
</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="#id6">
+ Arguments
+ </a>
+ </li>
+ </ul>
</li>
</ul>
</li>
@@ -403,7 +426,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id5">
+ <a class="reference internal nav-link" href="#id7">
Arguments
</a>
</li>
@@ -419,7 +442,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id6">
+ <a class="reference internal nav-link" href="#id8">
Arguments
</a>
</li>
@@ -435,7 +458,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id7">
+ <a class="reference internal nav-link" href="#id9">
Arguments
</a>
</li>
@@ -451,7 +474,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id8">
+ <a class="reference internal nav-link" href="#id10">
Arguments
</a>
</li>
@@ -467,7 +490,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id9">
+ <a class="reference internal nav-link" href="#id11">
Arguments
</a>
</li>
@@ -483,7 +506,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id10">
+ <a class="reference internal nav-link" href="#id12">
Arguments
</a>
</li>
@@ -499,7 +522,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id11">
+ <a class="reference internal nav-link" href="#id13">
Arguments
</a>
</li>
@@ -515,7 +538,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id12">
+ <a class="reference internal nav-link" href="#id14">
Arguments
</a>
</li>
@@ -531,7 +554,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id13">
+ <a class="reference internal nav-link" href="#id15">
Arguments
</a>
</li>
@@ -547,7 +570,7 @@
</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="#id16">
Arguments
</a>
</li>
@@ -570,7 +593,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="#id17">
Arguments
</a>
</li>
@@ -586,7 +609,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="#id18">
Arguments
</a>
</li>
@@ -602,7 +625,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="#id19">
Arguments
</a>
</li>
@@ -618,7 +641,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="#id20">
Arguments
</a>
</li>
@@ -682,6 +705,7 @@
<li><p><a class="reference internal" href="#count">count</a></p></li>
<li><p><a class="reference internal" href="#max">max</a></p></li>
<li><p><a class="reference internal" href="#mean">mean</a></p></li>
+<li><p><a class="reference internal" href="#median">median</a></p></li>
<li><p><a class="reference internal" href="#min">min</a></p></li>
<li><p><a class="reference internal" href="#sum">sum</a></p></li>
<li><p><a class="reference internal" href="#array-agg">array_agg</a></p></li>
@@ -741,14 +765,28 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<h3><code class="docutils literal notranslate"><span
class="pre">mean</span></code><a class="headerlink" href="#mean"
title="Permalink to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal" href="#avg">avg</a>.</em></p>
</section>
+<section id="median">
+<h3><code class="docutils literal notranslate"><span
class="pre">median</span></code><a class="headerlink" href="#median"
title="Permalink to this heading">¶</a></h3>
+<p>Returns the median value in the specified column.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">median</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id3">
+<h4>Arguments<a class="headerlink" href="#id3" 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>
+</ul>
+</section>
+</section>
<section id="min">
<h3><code class="docutils literal notranslate"><span
class="pre">min</span></code><a class="headerlink" href="#min" title="Permalink
to this heading">¶</a></h3>
<p>Returns the minimum value in the specified column.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">min</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id3">
-<h4>Arguments<a class="headerlink" href="#id3" title="Permalink to this
heading">¶</a></h4>
+<section id="id4">
+<h4>Arguments<a class="headerlink" href="#id4" 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>
@@ -761,8 +799,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="nb">sum</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id4">
-<h4>Arguments<a class="headerlink" href="#id4" title="Permalink to this
heading">¶</a></h4>
+<section id="id5">
+<h4>Arguments<a class="headerlink" href="#id5" 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>
@@ -771,7 +809,17 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</section>
<section id="array-agg">
<h3><code class="docutils literal notranslate"><span
class="pre">array_agg</span></code><a class="headerlink" href="#array-agg"
title="Permalink to this heading">¶</a></h3>
-<!-- TODO: Add array_agg documentation -->
+<p>Returns an array created from the expression elements.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_agg</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id6">
+<h4>Arguments<a class="headerlink" href="#id6" 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>
+</ul>
+</section>
</section>
</section>
<section id="statistical">
@@ -794,8 +842,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">corr</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="id5">
-<h4>Arguments<a class="headerlink" href="#id5" title="Permalink to this
heading">¶</a></h4>
+<section id="id7">
+<h4>Arguments<a class="headerlink" href="#id7" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -810,8 +858,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">covar</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="id6">
-<h4>Arguments<a class="headerlink" href="#id6" title="Permalink to this
heading">¶</a></h4>
+<section id="id8">
+<h4>Arguments<a class="headerlink" href="#id8" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -826,8 +874,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">covar_pop</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="id7">
-<h4>Arguments<a class="headerlink" href="#id7" title="Permalink to this
heading">¶</a></h4>
+<section id="id9">
+<h4>Arguments<a class="headerlink" href="#id9" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -842,8 +890,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">covar_samp</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="id8">
-<h4>Arguments<a class="headerlink" href="#id8" title="Permalink to this
heading">¶</a></h4>
+<section id="id10">
+<h4>Arguments<a class="headerlink" href="#id10" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -858,8 +906,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">stddev</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id9">
-<h4>Arguments<a class="headerlink" href="#id9" title="Permalink to this
heading">¶</a></h4>
+<section id="id11">
+<h4>Arguments<a class="headerlink" href="#id11" 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>
@@ -872,8 +920,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">stddev_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id10">
-<h4>Arguments<a class="headerlink" href="#id10" title="Permalink to this
heading">¶</a></h4>
+<section id="id12">
+<h4>Arguments<a class="headerlink" href="#id12" 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>
@@ -886,8 +934,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">stddev_samp</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id11">
-<h4>Arguments<a class="headerlink" href="#id11" title="Permalink to this
heading">¶</a></h4>
+<section id="id13">
+<h4>Arguments<a class="headerlink" href="#id13" 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>
@@ -900,8 +948,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">var</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id12">
-<h4>Arguments<a class="headerlink" href="#id12" title="Permalink to this
heading">¶</a></h4>
+<section id="id14">
+<h4>Arguments<a class="headerlink" href="#id14" 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>
@@ -914,8 +962,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">var_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id13">
-<h4>Arguments<a class="headerlink" href="#id13" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -928,8 +976,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">var_samp</span><span
class="p">(</span><span class="n">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="id16">
+<h4>Arguments<a class="headerlink" href="#id16" 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>
@@ -952,8 +1000,8 @@ HyperLogLog algorithm.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_distinct</span><span
class="p">(</span><span class="n">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="id17">
+<h4>Arguments<a class="headerlink" href="#id17" 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>
@@ -967,8 +1015,8 @@ It is an alias of <code class="docutils literal
notranslate"><span class="pre">a
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_median</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id16">
-<h4>Arguments<a class="headerlink" href="#id16" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -981,8 +1029,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">approx_percentile_cont</span><span class="p">(</span><span
class="n">expression</span><span class="p">,</span> <span
class="n">percentile</span><span class="p">,</span> <span
class="n">centroids</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="id19">
+<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
<ul>
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1002,8 +1050,8 @@ t-digest algorithm.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">weight</span><span class="p">,</span> <span
class="n">percentile</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="id20">
+<h4>Arguments<a class="headerlink" href="#id20" 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>
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index 7b52a6ca04..a992a24f4f 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -464,8 +464,8 @@ For example, to cast the output of <code class="docutils
literal notranslate"><s
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Float64</span></code></p></td>
<td><p></p></td>
</tr>
-<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">DECIMAL(precision,scale)</span></code></p></td>
-<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Decimal128(precision,scale)</span></code></p></td>
+<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">DECIMAL(precision,</span> <span
class="pre">scale)</span></code></p></td>
+<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Decimal128(precision,</span> <span
class="pre">scale)</span></code></p></td>
<td><p>Decimal support is currently experimental (<a class="reference
external"
href="https://github.com/apache/arrow-datafusion/issues/3523";>#3523</a>)</p></td>
</tr>
</tbody>
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index 63c92fffc2..7431e38933 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -278,6 +278,16 @@
<nav id="bd-toc-nav">
<ul class="visible nav section-nav flex-column">
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#create-database">
+ CREATE DATABASE
+ </a>
+ </li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#create-schema">
+ CREATE SCHEMA
+ </a>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#create-external-table">
CREATE EXTERNAL TABLE
@@ -285,7 +295,7 @@
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link"
href="#cautions-when-using-the-with-order-clause">
- Cautions When Using the WITH ORDER Clause
+ Cautions when using the WITH ORDER Clause
</a>
</li>
</ul>
@@ -358,6 +368,28 @@
-->
<section id="ddl">
<h1>DDL<a class="headerlink" href="#ddl" title="Permalink to this
heading">¶</a></h1>
+<section id="create-database">
+<h2>CREATE DATABASE<a class="headerlink" href="#create-database"
title="Permalink to this heading">¶</a></h2>
+<p>Create catalog with specified name.</p>
+<pre>
+CREATE DATABASE [ IF NOT EXISTS ] <i><b>catalog</i></b>
+</pre>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="c1">-- create catalog
cat</span>
+<span class="k">CREATE</span><span class="w"> </span><span
class="k">DATABASE</span><span class="w"> </span><span
class="n">cat</span><span class="p">;</span>
+</pre></div>
+</div>
+</section>
+<section id="create-schema">
+<h2>CREATE SCHEMA<a class="headerlink" href="#create-schema" title="Permalink
to this heading">¶</a></h2>
+<p>Create schema under specified catalog, or the default DataFusion catalog if
not specified.</p>
+<pre>
+CREATE SCHEMA [ IF NOT EXISTS ] [ <i><b>catalog.</i></b> ]
<b><i>schema_name</i></b>
+</pre>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="c1">-- create schema emu under
catalog cat</span>
+<span class="k">CREATE</span><span class="w"> </span><span
class="k">SCHEMA</span><span class="w"> </span><span class="n">cat</span><span
class="p">.</span><span class="n">emu</span><span class="p">;</span>
+</pre></div>
+</div>
+</section>
<section id="create-external-table">
<h2>CREATE EXTERNAL TABLE<a class="headerlink" href="#create-external-table"
title="Permalink to this heading">¶</a></h2>
<p>Parquet data sources can be registered by executing a <code class="docutils
literal notranslate"><span class="pre">CREATE</span> <span
class="pre">EXTERNAL</span> <span class="pre">TABLE</span></code> SQL
statement. It is not necessary
@@ -399,7 +431,7 @@ inferred based on scanning a subset of the file.</p>
<p>When creating an output from a data source that is already ordered by an
expression, you can pre-specify the order of
the data using the <code class="docutils literal notranslate"><span
class="pre">WITH</span> <span class="pre">ORDER</span></code> clause. This
applies even if the expression used for sorting is complex,
allowing for greater flexibility.</p>
-<p>Here’s an example of how to use <code class="docutils literal
notranslate"><span class="pre">WITH</span> <span
class="pre">ORDER</span></code> query</p>
+<p>Here’s an example of how to use <code class="docutils literal
notranslate"><span class="pre">WITH</span> <span
class="pre">ORDER</span></code> clause.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">CREATE</span><span
class="w"> </span><span class="k">EXTERNAL</span><span class="w"> </span><span
class="k">TABLE</span><span class="w"> </span><span class="n">test</span><span
class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="n">c1</span><span class="w">
</span><span class="nb">VARCHAR</span><span class="w"> </span><span
class="k">NOT</span><span class="w"> </span><span class="k">NULL</span><span
class="p">,</span>
<span class="w"> </span><span class="n">c2</span><span class="w">
</span><span class="nb">INT</span><span class="w"> </span><span
class="k">NOT</span><span class="w"> </span><span class="k">NULL</span><span
class="p">,</span>
@@ -421,13 +453,13 @@ allowing for greater flexibility.</p>
<span class="k">LOCATION</span><span class="w"> </span><span
class="s1">'/path/to/aggregate_test_100.csv'</span><span
class="p">;</span>
</pre></div>
</div>
-<p>where <code class="docutils literal notranslate"><span
class="pre">WITH</span> <span class="pre">ORDER</span></code> clause specifies
the sort order:</p>
+<p>Where <code class="docutils literal notranslate"><span
class="pre">WITH</span> <span class="pre">ORDER</span></code> clause specifies
the sort order:</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>WITH ORDER (sort_expression1 [ASC | DESC]
[NULLS { FIRST | LAST }]
[, sort_expression2 [ASC | DESC] [NULLS { FIRST | LAST }] ...])
</pre></div>
</div>
<section id="cautions-when-using-the-with-order-clause">
-<h3>Cautions When Using the WITH ORDER Clause<a class="headerlink"
href="#cautions-when-using-the-with-order-clause" title="Permalink to this
heading">¶</a></h3>
+<h3>Cautions when using the WITH ORDER Clause<a class="headerlink"
href="#cautions-when-using-the-with-order-clause" title="Permalink to this
heading">¶</a></h3>
<ul class="simple">
<li><p>It’s important to understand that using the <code class="docutils
literal notranslate"><span class="pre">WITH</span> <span
class="pre">ORDER</span></code> clause in the <code class="docutils literal
notranslate"><span class="pre">CREATE</span> <span class="pre">EXTERNAL</span>
<span class="pre">TABLE</span></code> statement only specifies the order in
which the data should be read from the external file. If the data in the file
is not already sorted according to the specified orde [...]
<li><p>It’s also important to note that the <code class="docutils literal
notranslate"><span class="pre">WITH</span> <span
class="pre">ORDER</span></code> clause does not affect the ordering of the data
in the original external file.</p></li>
@@ -475,7 +507,7 @@ DROP TABLE [ IF EXISTS ] <b><i>table_name</i></b>;
<h2>CREATE VIEW<a class="headerlink" href="#create-view" title="Permalink to
this heading">¶</a></h2>
<p>View is a virtual table based on the result of a SQL query. It can be
created from an existing table or values list.</p>
<pre>
-CREATE VIEW <i><b>view_name</b></i> AS statement;
+CREATE [ OR REPLACE ] VIEW <i><b>view_name</b></i> AS statement;
</pre>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">CREATE</span><span
class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span
class="n">users</span><span class="w"> </span><span class="k">AS</span><span
class="w"> </span><span class="k">VALUES</span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">),(</span><span class="mi">2</span><span class="p">,</span><spa [...]
<span class="k">CREATE</span><span class="w"> </span><span
class="k">VIEW</span><span class="w"> </span><span class="n">test</span><span
class="w"> </span><span class="k">AS</span><span class="w"> </span><span
class="k">SELECT</span><span class="w"> </span><span
class="n">column1</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span class="n">users</span><span
class="p">;</span>
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index c8e5a3515a..a485944128 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -343,7 +343,7 @@ EXPLAIN [ANALYZE] [VERBOSE] statement
<section id="id1">
<h2>EXPLAIN<a class="headerlink" href="#id1" title="Permalink to this
heading">¶</a></h2>
<p>Shows the execution plan of a statement.
-If you need more details output, try to use <code class="docutils literal
notranslate"><span class="pre">EXPLAIN</span> <span
class="pre">VERBOSE</span></code>.</p>
+If you need more detailed output, use <code class="docutils literal
notranslate"><span class="pre">EXPLAIN</span> <span
class="pre">VERBOSE</span></code>.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>EXPLAIN SELECT SUM(x) FROM table GROUP BY b;
+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan
|
@@ -366,7 +366,7 @@ If you need more details output, try to use <code
class="docutils literal notran
<section id="explain-analyze">
<h2>EXPLAIN ANALYZE<a class="headerlink" href="#explain-analyze"
title="Permalink to this heading">¶</a></h2>
<p>Shows the execution plan and metrics of a statement.
-If you need more information output, try to use <code class="docutils literal
notranslate"><span class="pre">EXPLAIN</span> <span class="pre">ANALYZE</span>
<span class="pre">VERBOSE</span></code>.</p>
+If you need more information output, use <code class="docutils literal
notranslate"><span class="pre">EXPLAIN</span> <span class="pre">ANALYZE</span>
<span class="pre">VERBOSE</span></code>.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>EXPLAIN ANALYZE SELECT SUM(x) FROM table
GROUP BY b;
+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan
|
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index dccba2105b..b08e8c1bc3 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -337,6 +337,8 @@
</ul>
</li>
<li class="toctree-l1"><a class="reference internal"
href="ddl.html">DDL</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-database">CREATE DATABASE</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-schema">CREATE SCHEMA</a></li>
<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-external-table">CREATE EXTERNAL TABLE</a></li>
<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-table">CREATE TABLE</a></li>
<li class="toctree-l2"><a class="reference internal"
href="ddl.html#drop-table">DROP TABLE</a></li>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index d62a608083..42c423832e 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -523,6 +523,22 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#log">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ log
+ </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="#id15">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#log10">
<code class="docutils literal notranslate">
@@ -533,7 +549,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="#id16">
Arguments
</a>
</li>
@@ -549,7 +565,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="#id17">
Arguments
</a>
</li>
@@ -574,12 +590,26 @@
</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="#id18">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#aliases">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#pow">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ pow
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#random">
<code class="docutils literal notranslate">
@@ -599,7 +629,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="#id19">
Arguments
</a>
</li>
@@ -615,7 +645,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="#id20">
Arguments
</a>
</li>
@@ -631,7 +661,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="#id21">
Arguments
</a>
</li>
@@ -647,7 +677,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="#id22">
Arguments
</a>
</li>
@@ -663,7 +693,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="#id23">
Arguments
</a>
</li>
@@ -679,7 +709,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="#id24">
Arguments
</a>
</li>
@@ -695,7 +725,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="#id25">
Arguments
</a>
</li>
@@ -711,7 +741,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="#id26">
Arguments
</a>
</li>
@@ -734,7 +764,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="#id27">
Arguments
</a>
</li>
@@ -750,7 +780,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="#id28">
Arguments
</a>
</li>
@@ -773,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="#id28">
+ <a class="reference internal nav-link" href="#id29">
Arguments
</a>
</li>
@@ -789,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="#id29">
+ <a class="reference internal nav-link" href="#id30">
Arguments
</a>
</li>
@@ -805,7 +835,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="#id31">
Arguments
</a>
</li>
@@ -839,7 +869,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="#id32">
Arguments
</a>
</li>
@@ -855,7 +885,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="#id33">
Arguments
</a>
</li>
@@ -871,7 +901,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="#id34">
Arguments
</a>
</li>
@@ -887,7 +917,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="#id35">
Arguments
</a>
</li>
@@ -903,7 +933,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="#id36">
Arguments
</a>
</li>
@@ -919,12 +949,12 @@
</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="#id37">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#aliases">
+ <a class="reference internal nav-link" href="#id38">
Aliases
</a>
</li>
@@ -940,7 +970,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="#id39">
Arguments
</a>
</li>
@@ -956,7 +986,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="#id40">
Arguments
</a>
</li>
@@ -972,12 +1002,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="#id41">
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="#id42">
Arguments
</a>
</li>
@@ -993,7 +1023,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="#id43">
Arguments
</a>
</li>
@@ -1009,7 +1039,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="#id44">
Arguments
</a>
</li>
@@ -1025,7 +1055,7 @@
</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="#id45">
Arguments
</a>
</li>
@@ -1041,7 +1071,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id44">
+ <a class="reference internal nav-link" href="#id46">
Arguments
</a>
</li>
@@ -1057,7 +1087,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="#id47">
Arguments
</a>
</li>
@@ -1073,7 +1103,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="#id48">
Arguments
</a>
</li>
@@ -1089,7 +1119,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="#id49">
Arguments
</a>
</li>
@@ -1105,7 +1135,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="#id50">
Arguments
</a>
</li>
@@ -1121,7 +1151,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="#id51">
Arguments
</a>
</li>
@@ -1137,7 +1167,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="#id52">
Arguments
</a>
</li>
@@ -1153,7 +1183,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="#id53">
Arguments
</a>
</li>
@@ -1178,7 +1208,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="#id54">
Arguments
</a>
</li>
@@ -1194,7 +1224,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="#id55">
Arguments
</a>
</li>
@@ -1210,12 +1240,21 @@
</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="#id56">
Arguments
</a>
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#uuid">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ uuid
+ </span>
+ </code>
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h2 nav-item toc-entry">
@@ -1233,7 +1272,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="#id57">
Arguments
</a>
</li>
@@ -1249,7 +1288,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="#id58">
Arguments
</a>
</li>
@@ -1271,6 +1310,24 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#current-date">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ current_date
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#current-time">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ current_time
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#date-bin">
<code class="docutils literal notranslate">
@@ -1281,7 +1338,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="#id59">
Arguments
</a>
</li>
@@ -1297,12 +1354,26 @@
</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="#id60">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id61">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#datetrunc">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ datetrunc
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#date-part">
<code class="docutils literal notranslate">
@@ -1313,12 +1384,26 @@
</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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id63">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#datepart">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ datepart
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#extract">
<code class="docutils literal notranslate">
@@ -1329,7 +1414,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="#id64">
Arguments
</a>
</li>
@@ -1345,7 +1430,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="#id65">
Arguments
</a>
</li>
@@ -1361,7 +1446,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="#id66">
Arguments
</a>
</li>
@@ -1377,7 +1462,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="#id67">
Arguments
</a>
</li>
@@ -1393,7 +1478,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="#id68">
Arguments
</a>
</li>
@@ -1409,7 +1494,7 @@
</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="#id69">
Arguments
</a>
</li>
@@ -1422,6 +1507,22 @@
Hashing Functions
</a>
<ul class="nav section-nav flex-column">
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#digest">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ digest
+ </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="#id70">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#md5">
<code class="docutils literal notranslate">
@@ -1432,7 +1533,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="#id71">
Arguments
</a>
</li>
@@ -1448,7 +1549,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="#id72">
Arguments
</a>
</li>
@@ -1464,7 +1565,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="#id73">
Arguments
</a>
</li>
@@ -1480,7 +1581,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="#id74">
Arguments
</a>
</li>
@@ -1496,7 +1597,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="#id75">
Arguments
</a>
</li>
@@ -1510,16 +1611,16 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array">
+ <a class="reference internal nav-link" href="#make-array">
<code class="docutils literal notranslate">
<span class="pre">
- array
+ make_array
</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="#id71">
+ <a class="reference internal nav-link" href="#id76">
Arguments
</a>
</li>
@@ -1535,7 +1636,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="#id77">
Arguments
</a>
</li>
@@ -1551,7 +1652,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="#id78">
Arguments
</a>
</li>
@@ -1567,7 +1668,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="#id79">
Arguments
</a>
</li>
@@ -1641,10 +1742,12 @@
<li><p><a class="reference internal" href="#exp">exp</a></p></li>
<li><p><a class="reference internal" href="#floor">floor</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>
<li><p><a class="reference internal" href="#log2">log2</a></p></li>
<li><p><a class="reference internal" href="#pi">pi</a></p></li>
<li><p><a class="reference internal" href="#power">power</a></p></li>
+<li><p><a class="reference internal" href="#pow">pow</a></p></li>
<li><p><a class="reference internal" href="#random">random</a></p></li>
<li><p><a class="reference internal" href="#round">round</a></p></li>
<li><p><a class="reference internal" href="#signum">signum</a></p></li>
@@ -1867,14 +1970,32 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</ul>
</section>
</section>
+<section id="log">
+<h3><code class="docutils literal notranslate"><span
class="pre">log</span></code><a class="headerlink" href="#log" title="Permalink
to this heading">¶</a></h3>
+<p>Returns the base-x logarithm of a number.
+Can either provide a specified base, or if omitted then takes the base-10 of a
number.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">log</span><span
class="p">(</span><span class="n">base</span><span class="p">,</span> <span
class="n">numeric_expression</span><span class="p">)</span>
+<span class="n">log</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>
+<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>
+<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="log10">
<h3><code class="docutils literal notranslate"><span
class="pre">log10</span></code><a class="headerlink" href="#log10"
title="Permalink to this heading">¶</a></h3>
<p>Returns the base-10 logarithm of a number.</p>
<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="id15">
-<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
+<section id="id16">
+<h4>Arguments<a class="headerlink" href="#id16" 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>
@@ -1883,12 +2004,12 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</section>
<section id="log2">
<h3><code class="docutils literal notranslate"><span
class="pre">log2</span></code><a class="headerlink" href="#log2"
title="Permalink to this heading">¶</a></h3>
-<p>Returns the base-2 logarithm or a number.</p>
+<p>Returns the base-2 logarithm of a number.</p>
<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="id16">
-<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
+<section id="id17">
+<h4>Arguments<a class="headerlink" href="#id17" 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>
@@ -1904,23 +2025,33 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</section>
<section id="power">
<h3><code class="docutils literal notranslate"><span
class="pre">power</span></code><a class="headerlink" href="#power"
title="Permalink to this heading">¶</a></h3>
-<p>Returns a base number raised to the power of an exponent.</p>
+<p>Returns a base expression raised to the power of an exponent.</p>
<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="id17">
-<h4>Arguments<a class="headerlink" href="#id17" 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>power</strong>: Base numeric expression to operate on.
+<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>
<li><p><strong>exponent</strong>: Exponent numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
</ul>
</section>
+<section id="aliases">
+<h4>Aliases<a class="headerlink" href="#aliases" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>pow</p></li>
+</ul>
+</section>
+</section>
+<section id="pow">
+<h3><code class="docutils literal notranslate"><span
class="pre">pow</span></code><a class="headerlink" href="#pow" title="Permalink
to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" href="#power">power</a>.</em></p>
</section>
<section id="random">
<h3><code class="docutils literal notranslate"><span
class="pre">random</span></code><a class="headerlink" href="#random"
title="Permalink to this heading">¶</a></h3>
-<p>Returns a random float value between 0 and 1.
+<p>Returns a random float value in the range [0, 1).
The random seed is unique to each row.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">random</span><span
class="p">()</span>
</pre></div>
@@ -1932,8 +2063,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="id18">
-<h4>Arguments<a class="headerlink" href="#id18" 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>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1948,8 +2079,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="id19">
-<h4>Arguments<a class="headerlink" href="#id19" 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>
@@ -1962,8 +2093,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="id20">
-<h4>Arguments<a class="headerlink" href="#id20" 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>
@@ -1976,8 +2107,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="id21">
-<h4>Arguments<a class="headerlink" href="#id21" 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>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1990,8 +2121,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="id22">
-<h4>Arguments<a class="headerlink" href="#id22" 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 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>
@@ -2004,8 +2135,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="id23">
-<h4>Arguments<a class="headerlink" href="#id23" 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>
@@ -2018,8 +2149,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="id24">
-<h4>Arguments<a class="headerlink" href="#id24" 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>
@@ -2032,8 +2163,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="id25">
-<h4>Arguments<a class="headerlink" href="#id25" 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>
@@ -2055,8 +2186,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="id26">
-<h4>Arguments<a class="headerlink" href="#id26" 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>expression1, expression_n</strong>:
Expression to use if previous expressions are <em>null</em>.
@@ -2072,8 +2203,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="id27">
-<h4>Arguments<a class="headerlink" href="#id27" 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>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>
@@ -2115,6 +2246,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal" href="#translate">translate</a></p></li>
<li><p><a class="reference internal" href="#trim">trim</a></p></li>
<li><p><a class="reference internal" href="#upper">upper</a></p></li>
+<li><p><a class="reference internal" href="#uuid">uuid</a></p></li>
</ul>
<section id="ascii">
<h3><code class="docutils literal notranslate"><span
class="pre">ascii</span></code><a class="headerlink" href="#ascii"
title="Permalink to this heading">¶</a></h3>
@@ -2122,8 +2254,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="id28">
-<h4>Arguments<a class="headerlink" href="#id28" 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>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2138,8 +2270,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="id29">
-<h4>Arguments<a class="headerlink" href="#id29" 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>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2157,8 +2289,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="id30">
-<h4>Arguments<a class="headerlink" href="#id30" 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>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2186,8 +2318,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="id31">
-<h4>Arguments<a class="headerlink" href="#id31" 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>str</strong>: String expression to concatenate.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2203,8 +2335,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="id32">
-<h4>Arguments<a class="headerlink" href="#id32" 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>separator</strong>: Separator to insert between concatenated
strings.</p></li>
<li><p><strong>str</strong>: String expression to concatenate.
@@ -2221,8 +2353,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="id33">
-<h4>Arguments<a class="headerlink" href="#id33" 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>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
@@ -2239,8 +2371,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="id34">
-<h4>Arguments<a class="headerlink" href="#id34" 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>
@@ -2256,8 +2388,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="id35">
-<h4>Arguments<a class="headerlink" href="#id35" 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>
@@ -2273,15 +2405,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="id36">
-<h4>Arguments<a class="headerlink" href="#id36" 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 operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
</ul>
</section>
-<section id="aliases">
-<h4>Aliases<a class="headerlink" href="#aliases" title="Permalink to this
heading">¶</a></h4>
+<section id="id38">
+<h4>Aliases<a class="headerlink" href="#id38" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>char_length</p></li>
<li><p>character_length</p></li>
@@ -2297,8 +2429,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="id37">
-<h4>Arguments<a class="headerlink" href="#id37" 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>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2310,12 +2442,12 @@ Can be a constant, column, or function, and any
combination of string operators.
</section>
<section id="lpad">
<h3><code class="docutils literal notranslate"><span
class="pre">lpad</span></code><a class="headerlink" href="#lpad"
title="Permalink to this heading">¶</a></h3>
-<p>Pads the left side a string with another string to a specified string
length.</p>
+<p>Pads the left side of a string with another string to a specified string
length.</p>
<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="id38">
-<h4>Arguments<a class="headerlink" href="#id38" 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>
@@ -2334,8 +2466,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="id39">
-<h4>Arguments<a class="headerlink" href="#id39" 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>
@@ -2345,8 +2477,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="id40">
-<h4>Arguments<a class="headerlink" href="#id40" 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>
@@ -2359,8 +2491,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="id41">
-<h4>Arguments<a class="headerlink" href="#id41" title="Permalink to this
heading">¶</a></h4>
+<section id="id43">
+<h4>Arguments<a class="headerlink" href="#id43" 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>
@@ -2376,8 +2508,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="id42">
-<h4>Arguments<a class="headerlink" href="#id42" 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 repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2391,8 +2523,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="id43">
-<h4>Arguments<a class="headerlink" href="#id43" 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 repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2409,8 +2541,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="id44">
-<h4>Arguments<a class="headerlink" href="#id44" 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 repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2423,8 +2555,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="id45">
-<h4>Arguments<a class="headerlink" href="#id45" 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>
@@ -2436,12 +2568,12 @@ Can be a constant, column, or function, and any
combination of string operators.
</section>
<section id="rpad">
<h3><code class="docutils literal notranslate"><span
class="pre">rpad</span></code><a class="headerlink" href="#rpad"
title="Permalink to this heading">¶</a></h3>
-<p>right side a string with another string to a specified string length.</p>
+<p>Pads the right side of a string with another string to a specified string
length.</p>
<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="id46">
-<h4>Arguments<a class="headerlink" href="#id46" 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>
@@ -2460,8 +2592,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="id47">
-<h4>Arguments<a class="headerlink" href="#id47" 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 operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2474,13 +2606,13 @@ Can be a constant, column, or function, and any
combination of string operators.
</section>
<section id="split-part">
<h3><code class="docutils literal notranslate"><span
class="pre">split_part</span></code><a class="headerlink" href="#split-part"
title="Permalink to this heading">¶</a></h3>
-<p>Splits a string based on a specified delimiter and returns the substring a
the
+<p>Splits a string based on a specified delimiter and returns the substring in
the
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="id48">
-<h4>Arguments<a class="headerlink" href="#id48" 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 spit.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2495,8 +2627,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="id49">
-<h4>Arguments<a class="headerlink" href="#id49" 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 test.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2512,8 +2644,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="id50">
-<h4>Arguments<a class="headerlink" href="#id50" 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>
@@ -2529,8 +2661,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="id51">
-<h4>Arguments<a class="headerlink" href="#id51" 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>
@@ -2561,8 +2693,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="id52">
-<h4>Arguments<a class="headerlink" href="#id52" 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>int</strong>: Integer expression to convert.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2575,8 +2707,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="id53">
-<h4>Arguments<a class="headerlink" href="#id53" 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 operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2593,8 +2725,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="id54">
-<h4>Arguments<a class="headerlink" href="#id54" 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 operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2604,6 +2736,13 @@ Can be a constant, column, or function, and any
combination of string operators.
<a class="reference internal" href="#lower">lower</a></p>
</section>
</section>
+<section id="uuid">
+<h3><code class="docutils literal notranslate"><span
class="pre">uuid</span></code><a class="headerlink" href="#uuid"
title="Permalink to this heading">¶</a></h3>
+<p>Returns UUID v4 string value which is unique per row.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">uuid</span><span
class="p">()</span>
+</pre></div>
+</div>
+</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>
@@ -2619,8 +2758,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="id55">
-<h4>Arguments<a class="headerlink" href="#id55" 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>
@@ -2635,8 +2774,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="id56">
-<h4>Arguments<a class="headerlink" href="#id56" 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>
@@ -2659,9 +2798,13 @@ regular expression. The following flags are
supported.</p>
<h2>Time and Date Functions<a class="headerlink"
href="#time-and-date-functions" title="Permalink to this heading">¶</a></h2>
<ul class="simple">
<li><p><a class="reference internal" href="#now">now</a></p></li>
+<li><p><a class="reference internal"
href="#current-date">current_date</a></p></li>
+<li><p><a class="reference internal"
href="#current-time">current_time</a></p></li>
<li><p><a class="reference internal" href="#date-bin">date_bin</a></p></li>
<li><p><a class="reference internal" href="#date-trunc">date_trunc</a></p></li>
+<li><p><a class="reference internal" href="#datetrunc">datetrunc</a></p></li>
<li><p><a class="reference internal" href="#date-part">date_part</a></p></li>
+<li><p><a class="reference internal" href="#datepart">datepart</a></p></li>
<li><p><a class="reference internal" href="#extract">extract</a></p></li>
<li><p><a class="reference internal"
href="#to-timestamp">to_timestamp</a></p></li>
<li><p><a class="reference internal"
href="#to-timestamp-millis">to_timestamp_millis</a></p></li>
@@ -2678,6 +2821,24 @@ no matter when in the query plan the function
executes.</p>
</pre></div>
</div>
</section>
+<section id="current-date">
+<h3><code class="docutils literal notranslate"><span
class="pre">current_date</span></code><a class="headerlink"
href="#current-date" title="Permalink to this heading">¶</a></h3>
+<p>Returns the current UTC date.</p>
+<p>The <code class="docutils literal notranslate"><span
class="pre">current_date()</span></code> return value is determined at query
time and will return the same date,
+no matter when in the query plan the function executes.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">current_date</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
+<section id="current-time">
+<h3><code class="docutils literal notranslate"><span
class="pre">current_time</span></code><a class="headerlink"
href="#current-time" title="Permalink to this heading">¶</a></h3>
+<p>Returns the current UTC time.</p>
+<p>The <code class="docutils literal notranslate"><span
class="pre">current_time()</span></code> return value is determined at query
time and will return the same time,
+no matter when in the query plan the function executes.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">current_time</span><span
class="p">()</span>
+</pre></div>
+</div>
+</section>
<section id="date-bin">
<h3><code class="docutils literal notranslate"><span
class="pre">date_bin</span></code><a class="headerlink" href="#date-bin"
title="Permalink to this heading">¶</a></h3>
<p>Calculates time intervals and returns the start of the interval nearest to
the specified timestamp.
@@ -2689,8 +2850,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="id57">
-<h4>Arguments<a class="headerlink" href="#id57" 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>interval</strong>: Bin interval.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on.
@@ -2719,8 +2880,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="id58">
-<h4>Arguments<a class="headerlink" href="#id58" 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>precision</strong>: Time precision to truncate to.
The following precisions are supported:</p>
@@ -2738,6 +2899,16 @@ The following precisions are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
+<section id="id61">
+<h4>Aliases<a class="headerlink" href="#id61" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>datetrunc</p></li>
+</ul>
+</section>
+</section>
+<section id="datetrunc">
+<h3><code class="docutils literal notranslate"><span
class="pre">datetrunc</span></code><a class="headerlink" href="#datetrunc"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#date-trunc">date_trunc</a>.</em></p>
</section>
<section id="date-part">
<h3><code class="docutils literal notranslate"><span
class="pre">date_part</span></code><a class="headerlink" href="#date-part"
title="Permalink to this heading">¶</a></h3>
@@ -2745,8 +2916,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="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>part</strong>: Part of the date to return.
The following date parts are supported:</p>
@@ -2769,6 +2940,16 @@ The following date parts 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>
+<ul class="simple">
+<li><p>datepart</p></li>
+</ul>
+</section>
+</section>
+<section id="datepart">
+<h3><code class="docutils literal notranslate"><span
class="pre">datepart</span></code><a class="headerlink" href="#datepart"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#date-part">date_part</a>.</em></p>
</section>
<section id="extract">
<h3><code class="docutils literal notranslate"><span
class="pre">extract</span></code><a class="headerlink" href="#extract"
title="Permalink to this heading">¶</a></h3>
@@ -2777,8 +2958,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="id60">
-<h4>Arguments<a class="headerlink" href="#id60" 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>field</strong>: Part or field of the date to return.
The following date fields are supported:</p>
@@ -2811,8 +2992,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="id61">
-<h4>Arguments<a class="headerlink" href="#id61" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2828,8 +3009,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="id62">
-<h4>Arguments<a class="headerlink" href="#id62" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2845,8 +3026,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="id63">
-<h4>Arguments<a class="headerlink" href="#id63" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2862,8 +3043,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="id64">
-<h4>Arguments<a class="headerlink" href="#id64" title="Permalink to this
heading">¶</a></h4>
+<section id="id68">
+<h4>Arguments<a class="headerlink" href="#id68" 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>
@@ -2878,8 +3059,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="id65">
-<h4>Arguments<a class="headerlink" href="#id65" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -2890,20 +3071,48 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<section id="hashing-functions">
<h2>Hashing Functions<a class="headerlink" href="#hashing-functions"
title="Permalink to this heading">¶</a></h2>
<ul class="simple">
+<li><p><a class="reference internal" href="#digest">digest</a></p></li>
<li><p><a class="reference internal" href="#md5">md5</a></p></li>
<li><p><a class="reference internal" href="#sha224">sha224</a></p></li>
<li><p><a class="reference internal" href="#sha256">sha256</a></p></li>
<li><p><a class="reference internal" href="#sha384">sha384</a></p></li>
<li><p><a class="reference internal" href="#sha512">sha512</a></p></li>
</ul>
+<section id="digest">
+<h3><code class="docutils literal notranslate"><span
class="pre">digest</span></code><a class="headerlink" href="#digest"
title="Permalink to this heading">¶</a></h3>
+<p>Computes the binary hash of an expression using the specified algorithm.</p>
+<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="id70">
+<h4>Arguments<a class="headerlink" href="#id70" 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>
+<li><p><strong>algorithm</strong>: String expression specifying algorithm to
use.
+Must be one of:</p>
+<ul>
+<li><p>md5</p></li>
+<li><p>sha224</p></li>
+<li><p>sha256</p></li>
+<li><p>sha384</p></li>
+<li><p>sha512</p></li>
+<li><p>blake2s</p></li>
+<li><p>blake2b</p></li>
+<li><p>blake3</p></li>
+</ul>
+</li>
+</ul>
+</section>
+</section>
<section id="md5">
<h3><code class="docutils literal notranslate"><span
class="pre">md5</span></code><a class="headerlink" href="#md5" title="Permalink
to this heading">¶</a></h3>
<p>Computes an MD5 128-bit checksum for a string expression.</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="id66">
-<h4>Arguments<a class="headerlink" href="#id66" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2916,8 +3125,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="id67">
-<h4>Arguments<a class="headerlink" href="#id67" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2930,8 +3139,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="id68">
-<h4>Arguments<a class="headerlink" href="#id68" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2944,8 +3153,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="id69">
-<h4>Arguments<a class="headerlink" href="#id69" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -2958,8 +3167,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="id70">
-<h4>Arguments<a class="headerlink" href="#id70" 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>
@@ -2970,19 +3179,19 @@ Can be a constant, column, or function, and any
combination of string operators.
<section id="other-functions">
<h2>Other Functions<a class="headerlink" href="#other-functions"
title="Permalink to this heading">¶</a></h2>
<ul class="simple">
-<li><p><a class="reference internal" href="#array">array</a></p></li>
+<li><p><a class="reference internal" href="#make-array">make_array</a></p></li>
<li><p><a class="reference internal" href="#arrow-cast">arrow_cast</a></p></li>
<li><p><a class="reference internal"
href="#arrow-typeof">arrow_typeof</a></p></li>
<li><p><a class="reference internal" href="#struct">struct</a></p></li>
</ul>
-<section id="array">
-<h3><code class="docutils literal notranslate"><span
class="pre">array</span></code><a class="headerlink" href="#array"
title="Permalink to this heading">¶</a></h3>
+<section id="make-array">
+<h3><code class="docutils literal notranslate"><span
class="pre">make_array</span></code><a class="headerlink" href="#make-array"
title="Permalink to this heading">¶</a></h3>
<p>Returns an Arrow array using the specified input expressions.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">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>
+<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="id71">
-<h4>Arguments<a class="headerlink" href="#id71" 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_n</strong>: Expression to include in the output
array.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -2996,8 +3205,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="id72">
-<h4>Arguments<a class="headerlink" href="#id72" 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>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3013,8 +3222,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="id73">
-<h4>Arguments<a class="headerlink" href="#id73" 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>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3030,8 +3239,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="id74">
-<h4>Arguments<a class="headerlink" href="#id74" 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_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 6c4e4ed878..822d9a5efd 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -323,6 +323,11 @@
FULL OUTER JOIN
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#natural-join">
+ NATURAL JOIN
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#cross-join">
CROSS JOIN
@@ -457,7 +462,7 @@ By default <code class="docutils literal notranslate"><span
class="pre">ALL</spa
</section>
<section id="join-clause">
<h2>JOIN clause<a class="headerlink" href="#join-clause" title="Permalink to
this heading">¶</a></h2>
-<p>DataFusion supports <code class="docutils literal notranslate"><span
class="pre">INNER</span> <span class="pre">JOIN</span></code>, <code
class="docutils literal notranslate"><span class="pre">LEFT</span> <span
class="pre">OUTER</span> <span class="pre">JOIN</span></code>, <code
class="docutils literal notranslate"><span class="pre">RIGHT</span> <span
class="pre">OUTER</span> <span class="pre">JOIN</span></code>, <code
class="docutils literal notranslate"><span class="pre">FULL</span> [...]
+<p>DataFusion supports <code class="docutils literal notranslate"><span
class="pre">INNER</span> <span class="pre">JOIN</span></code>, <code
class="docutils literal notranslate"><span class="pre">LEFT</span> <span
class="pre">OUTER</span> <span class="pre">JOIN</span></code>, <code
class="docutils literal notranslate"><span class="pre">RIGHT</span> <span
class="pre">OUTER</span> <span class="pre">JOIN</span></code>, <code
class="docutils literal notranslate"><span class="pre">FULL</span> [...]
<p>The following examples are based on this table:</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">select</span><span
class="w"> </span><span class="o">*</span><span class="w"> </span><span
class="k">from</span><span class="w"> </span><span class="n">x</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
@@ -520,6 +525,19 @@ either side of the join where there is not a match.</p>
</pre></div>
</div>
</section>
+<section id="natural-join">
+<h3>NATURAL JOIN<a class="headerlink" href="#natural-join" title="Permalink to
this heading">¶</a></h3>
+<p>A natural join defines an inner join based on common column names found
between the input tables. When no common
+column names are found, it behaves like a cross join.</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>❯ select * from x natural join x y;
++----------+----------+
+| column_1 | column_2 |
++----------+----------+
+| 1 | 2 |
++----------+----------+
+</pre></div>
+</div>
+</section>
<section id="cross-join">
<h3>CROSS JOIN<a class="headerlink" href="#cross-join" title="Permalink to
this heading">¶</a></h3>
<p>A cross join produces a cartesian product that matches every row in the
left side of the join with every row in the
