(arrow-datafusion) branch asf-site updated: Publish built docs triggered by 234217e439ccf598d704fd7645560f04f25e8a6f

[github-bot]

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 13db071704 Publish built docs triggered by 
234217e439ccf598d704fd7645560f04f25e8a6f
13db071704 is described below

commit 13db0717041b7c306aa11639e3efd252b993ae86
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sun Nov 26 12:00:49 2023 +0000

    Publish built docs triggered by 234217e439ccf598d704fd7645560f04f25e8a6f
---
 _sources/user-guide/sql/scalar_functions.md.txt |  18 +
 searchindex.js                                  |   2 +-
 user-guide/sql/scalar_functions.html            | 653 +++++++++++++-----------
 3 files changed, 363 insertions(+), 310 deletions(-)

diff --git a/_sources/user-guide/sql/scalar_functions.md.txt 
b/_sources/user-guide/sql/scalar_functions.md.txt
index eda46ef8a7..e7ebbc9f1f 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -637,6 +637,7 @@ nullif(expression1, expression2)
 - [uuid](#uuid)
 - [overlay](#overlay)
 - [levenshtein](#levenshtein)
+- [substr_index](#substr_index)
 
 ### `ascii`
 
@@ -1152,6 +1153,23 @@ levenshtein(str1, str2)
 - **str1**: String expression to compute Levenshtein distance with str2.
 - **str2**: String expression to compute Levenshtein distance with str1.
 
+### `substr_index`
+
+Returns the substring from str before count occurrences of the delimiter delim.
+If count is positive, everything to the left of the final delimiter (counting 
from the left) is returned.
+If count is negative, everything to the right of the final delimiter (counting 
from the right) is returned.
+For example, `substr_index('www.apache.org', '.', 1) = www`, 
`substr_index('www.apache.org', '.', -1) = org`
+
+```
+substr_index(str, delim, count)
+```
+
+#### Arguments
+
+- **str**: String expression to operate on.
+- **delim**: the string to find in str to split str.
+- **count**: The number of times to search for the delimiter. Can be both a 
positive or negative number.
+
 ## Binary String Functions
 
 - [decode](#decode)
diff --git a/searchindex.js b/searchindex.js
index 066184cc1a..f10e42ea9f 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", 
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans", 
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ 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", 
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans", 
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html 
b/user-guide/sql/scalar_functions.html
index 13d2f69fed..f54f4ff908 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1481,6 +1481,22 @@
      </li>
     </ul>
    </li>
+   <li class="toc-h3 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#substr-index">
+     <code class="docutils literal notranslate">
+      <span class="pre">
+       substr_index
+      </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="#id67">
+       Arguments
+      </a>
+     </li>
+    </ul>
+   </li>
   </ul>
  </li>
  <li class="toc-h2 nav-item toc-entry">
@@ -1498,7 +1514,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="#id68">
        Arguments
       </a>
      </li>
@@ -1514,7 +1530,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="#id69">
        Arguments
       </a>
      </li>
@@ -1537,7 +1553,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="#id70">
        Arguments
       </a>
      </li>
@@ -1553,7 +1569,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="#id71">
        Arguments
       </a>
      </li>
@@ -1603,7 +1619,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id71">
+      <a class="reference internal nav-link" href="#id72">
        Arguments
       </a>
      </li>
@@ -1619,12 +1635,12 @@
     </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="#id73">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id73">
+      <a class="reference internal nav-link" href="#id74">
        Aliases
       </a>
      </li>
@@ -1649,12 +1665,12 @@
     </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="#id75">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id75">
+      <a class="reference internal nav-link" href="#id76">
        Aliases
       </a>
      </li>
@@ -1679,7 +1695,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id76">
+      <a class="reference internal nav-link" href="#id77">
        Arguments
       </a>
      </li>
@@ -1695,7 +1711,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id77">
+      <a class="reference internal nav-link" href="#id78">
        Arguments
       </a>
      </li>
@@ -1711,7 +1727,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id78">
+      <a class="reference internal nav-link" href="#id79">
        Arguments
       </a>
      </li>
@@ -1736,7 +1752,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id79">
+      <a class="reference internal nav-link" href="#id80">
        Arguments
       </a>
      </li>
@@ -1752,7 +1768,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id80">
+      <a class="reference internal nav-link" href="#id81">
        Arguments
       </a>
      </li>
@@ -1768,7 +1784,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id81">
+      <a class="reference internal nav-link" href="#id82">
        Arguments
       </a>
      </li>
@@ -1791,7 +1807,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id82">
+      <a class="reference internal nav-link" href="#id83">
        Arguments
       </a>
      </li>
@@ -1801,7 +1817,7 @@
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id83">
+      <a class="reference internal nav-link" href="#id84">
        Aliases
       </a>
      </li>
@@ -1826,17 +1842,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id84">
+      <a class="reference internal nav-link" href="#id85">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id85">
+      <a class="reference internal nav-link" href="#id86">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id86">
+      <a class="reference internal nav-link" href="#id87">
        Aliases
       </a>
      </li>
@@ -1852,7 +1868,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id87">
+      <a class="reference internal nav-link" href="#id88">
        Arguments
       </a>
      </li>
@@ -1868,7 +1884,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id88">
+      <a class="reference internal nav-link" href="#id89">
        Arguments
       </a>
      </li>
@@ -1884,7 +1900,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id89">
+      <a class="reference internal nav-link" href="#id90">
        Arguments
       </a>
      </li>
@@ -1900,17 +1916,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id90">
+      <a class="reference internal nav-link" href="#id91">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id91">
+      <a class="reference internal nav-link" href="#id92">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id92">
+      <a class="reference internal nav-link" href="#id93">
        Aliases
       </a>
      </li>
@@ -1926,17 +1942,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id93">
+      <a class="reference internal nav-link" href="#id94">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id94">
+      <a class="reference internal nav-link" href="#id95">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id95">
+      <a class="reference internal nav-link" href="#id96">
        Aliases
       </a>
      </li>
@@ -1970,7 +1986,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id96">
+      <a class="reference internal nav-link" href="#id97">
        Arguments
       </a>
      </li>
@@ -1986,7 +2002,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id97">
+      <a class="reference internal nav-link" href="#id98">
        Arguments
       </a>
      </li>
@@ -2020,17 +2036,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id98">
+      <a class="reference internal nav-link" href="#id99">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id99">
+      <a class="reference internal nav-link" href="#id100">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id100">
+      <a class="reference internal nav-link" href="#id101">
        Aliases
       </a>
      </li>
@@ -2046,17 +2062,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id101">
+      <a class="reference internal nav-link" href="#id102">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id102">
+      <a class="reference internal nav-link" href="#id103">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id103">
+      <a class="reference internal nav-link" href="#id104">
        Aliases
       </a>
      </li>
@@ -2072,17 +2088,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id104">
+      <a class="reference internal nav-link" href="#id105">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id105">
+      <a class="reference internal nav-link" href="#id106">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id106">
+      <a class="reference internal nav-link" href="#id107">
        Aliases
       </a>
      </li>
@@ -2098,12 +2114,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id107">
+      <a class="reference internal nav-link" href="#id108">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id108">
+      <a class="reference internal nav-link" href="#id109">
        Example
       </a>
      </li>
@@ -2119,12 +2135,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id109">
+      <a class="reference internal nav-link" href="#id110">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id110">
+      <a class="reference internal nav-link" href="#id111">
        Example
       </a>
      </li>
@@ -2140,17 +2156,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id111">
+      <a class="reference internal nav-link" href="#id112">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id112">
+      <a class="reference internal nav-link" href="#id113">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id113">
+      <a class="reference internal nav-link" href="#id114">
        Aliases
       </a>
      </li>
@@ -2166,17 +2182,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id114">
+      <a class="reference internal nav-link" href="#id115">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id115">
+      <a class="reference internal nav-link" href="#id116">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id116">
+      <a class="reference internal nav-link" href="#id117">
        Aliases
       </a>
      </li>
@@ -2210,12 +2226,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id117">
+      <a class="reference internal nav-link" href="#id118">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id118">
+      <a class="reference internal nav-link" href="#id119">
        Example
       </a>
      </li>
@@ -2231,17 +2247,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id119">
+      <a class="reference internal nav-link" href="#id120">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id120">
+      <a class="reference internal nav-link" href="#id121">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id121">
+      <a class="reference internal nav-link" href="#id122">
        Aliases
       </a>
      </li>
@@ -2257,17 +2273,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id122">
+      <a class="reference internal nav-link" href="#id123">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id123">
+      <a class="reference internal nav-link" href="#id124">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id124">
+      <a class="reference internal nav-link" href="#id125">
        Aliases
       </a>
      </li>
@@ -2283,17 +2299,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id125">
+      <a class="reference internal nav-link" href="#id126">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id126">
+      <a class="reference internal nav-link" href="#id127">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id127">
+      <a class="reference internal nav-link" href="#id128">
        Aliases
       </a>
      </li>
@@ -2309,17 +2325,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id128">
+      <a class="reference internal nav-link" href="#id129">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id129">
+      <a class="reference internal nav-link" href="#id130">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id130">
+      <a class="reference internal nav-link" href="#id131">
        Aliases
       </a>
      </li>
@@ -2335,17 +2351,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id131">
+      <a class="reference internal nav-link" href="#id132">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id132">
+      <a class="reference internal nav-link" href="#id133">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id133">
+      <a class="reference internal nav-link" href="#id134">
        Aliases
       </a>
      </li>
@@ -2361,17 +2377,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id134">
+      <a class="reference internal nav-link" href="#id135">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id135">
+      <a class="reference internal nav-link" href="#id136">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id136">
+      <a class="reference internal nav-link" href="#id137">
        Aliases
       </a>
      </li>
@@ -2387,12 +2403,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id137">
+      <a class="reference internal nav-link" href="#id138">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id138">
+      <a class="reference internal nav-link" href="#id139">
        Aliases
       </a>
      </li>
@@ -2408,17 +2424,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id139">
+      <a class="reference internal nav-link" href="#id140">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id140">
+      <a class="reference internal nav-link" href="#id141">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id141">
+      <a class="reference internal nav-link" href="#id142">
        Aliases
       </a>
      </li>
@@ -2434,17 +2450,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id142">
+      <a class="reference internal nav-link" href="#id143">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id143">
+      <a class="reference internal nav-link" href="#id144">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id144">
+      <a class="reference internal nav-link" href="#id145">
        Aliases
       </a>
      </li>
@@ -2460,17 +2476,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id145">
+      <a class="reference internal nav-link" href="#id146">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id146">
+      <a class="reference internal nav-link" href="#id147">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id147">
+      <a class="reference internal nav-link" href="#id148">
        Aliases
       </a>
      </li>
@@ -2486,12 +2502,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id148">
+      <a class="reference internal nav-link" href="#id149">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id149">
+      <a class="reference internal nav-link" href="#id150">
        Example
       </a>
      </li>
@@ -2507,12 +2523,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id150">
+      <a class="reference internal nav-link" href="#id151">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id151">
+      <a class="reference internal nav-link" href="#id152">
        Example
       </a>
      </li>
@@ -2744,17 +2760,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id152">
+      <a class="reference internal nav-link" href="#id153">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id153">
+      <a class="reference internal nav-link" href="#id154">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id154">
+      <a class="reference internal nav-link" href="#id155">
        Aliases
       </a>
      </li>
@@ -2779,12 +2795,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id155">
+      <a class="reference internal nav-link" href="#id156">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id156">
+      <a class="reference internal nav-link" href="#id157">
        Aliases
       </a>
      </li>
@@ -2809,7 +2825,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id157">
+      <a class="reference internal nav-link" href="#id158">
        Arguments
       </a>
      </li>
@@ -2825,7 +2841,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id158">
+      <a class="reference internal nav-link" href="#id159">
        Arguments
       </a>
      </li>
@@ -2848,7 +2864,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id159">
+      <a class="reference internal nav-link" href="#id160">
        Arguments
       </a>
      </li>
@@ -2871,7 +2887,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id160">
+      <a class="reference internal nav-link" href="#id161">
        Arguments
       </a>
      </li>
@@ -2887,7 +2903,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id161">
+      <a class="reference internal nav-link" href="#id162">
        Arguments
       </a>
      </li>
@@ -2903,7 +2919,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id162">
+      <a class="reference internal nav-link" href="#id163">
        Arguments
       </a>
      </li>
@@ -2919,7 +2935,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id163">
+      <a class="reference internal nav-link" href="#id164">
        Arguments
       </a>
      </li>
@@ -2935,7 +2951,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id164">
+      <a class="reference internal nav-link" href="#id165">
        Arguments
       </a>
      </li>
@@ -2951,7 +2967,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id165">
+      <a class="reference internal nav-link" href="#id166">
        Arguments
       </a>
      </li>
@@ -2974,12 +2990,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id166">
+      <a class="reference internal nav-link" href="#id167">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id167">
+      <a class="reference internal nav-link" href="#id168">
        Example
       </a>
      </li>
@@ -2995,12 +3011,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id168">
+      <a class="reference internal nav-link" href="#id169">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id169">
+      <a class="reference internal nav-link" href="#id170">
        Example
       </a>
      </li>
@@ -3715,6 +3731,7 @@ Can be a constant, column, or function, and any 
combination of arithmetic operat
 <li><p><a class="reference internal" href="#uuid">uuid</a></p></li>
 <li><p><a class="reference internal" href="#overlay">overlay</a></p></li>
 <li><p><a class="reference internal" 
href="#levenshtein">levenshtein</a></p></li>
+<li><p><a class="reference internal" 
href="#substr-index">substr_index</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="Link 
to this heading">¶</a></h3>
@@ -4243,6 +4260,24 @@ For example, <code class="docutils literal 
notranslate"><span class="pre">levens
 </ul>
 </section>
 </section>
+<section id="substr-index">
+<h3><code class="docutils literal notranslate"><span 
class="pre">substr_index</span></code><a class="headerlink" 
href="#substr-index" title="Link to this heading">¶</a></h3>
+<p>Returns the substring from str before count occurrences of the delimiter 
delim.
+If count is positive, everything to the left of the final delimiter (counting 
from the left) is returned.
+If count is negative, everything to the right of the final delimiter (counting 
from the right) is returned.
+For example, <code class="docutils literal notranslate"><span 
class="pre">substr_index('www.apache.org',</span> <span class="pre">'.',</span> 
<span class="pre">1)</span> <span class="pre">=</span> <span 
class="pre">www</span></code>, <code class="docutils literal notranslate"><span 
class="pre">substr_index('www.apache.org',</span> <span class="pre">'.',</span> 
<span class="pre">-1)</span> <span class="pre">=</span> <span 
class="pre">org</span></code></p>
+<div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">substr_index</span><span 
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span 
class="n">delim</span><span class="p">,</span> <span 
class="n">count</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id67">
+<h4>Arguments<a class="headerlink" href="#id67" title="Link to this 
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>str</strong>: String expression to operate on.</p></li>
+<li><p><strong>delim</strong>: the string to find in str to split str.</p></li>
+<li><p><strong>count</strong>: The number of times to search for the 
delimiter. Can be both a positive or negative number.</p></li>
+</ul>
+</section>
+</section>
 </section>
 <section id="binary-string-functions">
 <h2>Binary String Functions<a class="headerlink" 
href="#binary-string-functions" title="Link to this heading">¶</a></h2>
@@ -4256,8 +4291,8 @@ For example, <code class="docutils literal 
notranslate"><span class="pre">levens
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">encode</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="nb">format</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id67">
-<h4>Arguments<a class="headerlink" href="#id67" title="Link to this 
heading">¶</a></h4>
+<section id="id68">
+<h4>Arguments<a class="headerlink" href="#id68" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression containing string or binary 
data</p></li>
 <li><p><strong>format</strong>: Supported formats are: <code class="docutils 
literal notranslate"><span class="pre">base64</span></code>, <code 
class="docutils literal notranslate"><span 
class="pre">hex</span></code></p></li>
@@ -4272,8 +4307,8 @@ For example, <code class="docutils literal 
notranslate"><span class="pre">levens
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">decode</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="nb">format</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id68">
-<h4>Arguments<a class="headerlink" href="#id68" title="Link to this 
heading">¶</a></h4>
+<section id="id69">
+<h4>Arguments<a class="headerlink" href="#id69" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression containing encoded string 
data</p></li>
 <li><p><strong>format</strong>: Same arguments as <a class="reference 
internal" href="#encode">encode</a></p></li>
@@ -4297,8 +4332,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="id69">
-<h4>Arguments<a class="headerlink" href="#id69" title="Link to this 
heading">¶</a></h4>
+<section id="id70">
+<h4>Arguments<a class="headerlink" href="#id70" title="Link 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>
@@ -4313,8 +4348,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="id70">
-<h4>Arguments<a class="headerlink" href="#id70" title="Link to this 
heading">¶</a></h4>
+<section id="id71">
+<h4>Arguments<a class="headerlink" href="#id71" title="Link 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>
@@ -4390,8 +4425,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="id71">
-<h4>Arguments<a class="headerlink" href="#id71" title="Link to this 
heading">¶</a></h4>
+<section id="id72">
+<h4>Arguments<a class="headerlink" href="#id72" title="Link 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.
@@ -4420,8 +4455,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="id72">
-<h4>Arguments<a class="headerlink" href="#id72" title="Link to this 
heading">¶</a></h4>
+<section id="id73">
+<h4>Arguments<a class="headerlink" href="#id73" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>precision</strong>: Time precision to truncate to.
 The following precisions are supported:</p>
@@ -4440,8 +4475,8 @@ The following precisions are supported:</p>
 Can be a constant, column, or function.</p></li>
 </ul>
 </section>
-<section id="id73">
-<h4>Aliases<a class="headerlink" href="#id73" title="Link to this 
heading">¶</a></h4>
+<section id="id74">
+<h4>Aliases<a class="headerlink" href="#id74" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>datetrunc</p></li>
 </ul>
@@ -4457,8 +4492,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="id74">
-<h4>Arguments<a class="headerlink" href="#id74" title="Link to this 
heading">¶</a></h4>
+<section id="id75">
+<h4>Arguments<a class="headerlink" href="#id75" title="Link 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>
@@ -4481,8 +4516,8 @@ The following date parts are supported:</p>
 Can be a constant, column, or function.</p></li>
 </ul>
 </section>
-<section id="id75">
-<h4>Aliases<a class="headerlink" href="#id75" title="Link to this 
heading">¶</a></h4>
+<section id="id76">
+<h4>Aliases<a class="headerlink" href="#id76" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>datepart</p></li>
 </ul>
@@ -4499,8 +4534,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="id76">
-<h4>Arguments<a class="headerlink" href="#id76" title="Link to this 
heading">¶</a></h4>
+<section id="id77">
+<h4>Arguments<a class="headerlink" href="#id77" title="Link 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>
@@ -4534,8 +4569,8 @@ return the corresponding 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="id77">
-<h4>Arguments<a class="headerlink" href="#id77" title="Link to this 
heading">¶</a></h4>
+<section id="id78">
+<h4>Arguments<a class="headerlink" href="#id78" title="Link 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>
@@ -4552,8 +4587,8 @@ return the corresponding 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="id78">
-<h4>Arguments<a class="headerlink" href="#id78" title="Link to this 
heading">¶</a></h4>
+<section id="id79">
+<h4>Arguments<a class="headerlink" href="#id79" title="Link 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>
@@ -4581,8 +4616,8 @@ return the corresponding timestamp.</p>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span 
class="n">to_timestamp_nanos</span><span class="p">(</span><span 
class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id79">
-<h4>Arguments<a class="headerlink" href="#id79" title="Link to this 
heading">¶</a></h4>
+<section id="id80">
+<h4>Arguments<a class="headerlink" href="#id80" title="Link 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>
@@ -4599,8 +4634,8 @@ return the corresponding 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="id80">
-<h4>Arguments<a class="headerlink" href="#id80" title="Link to this 
heading">¶</a></h4>
+<section id="id81">
+<h4>Arguments<a class="headerlink" href="#id81" title="Link 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>
@@ -4615,8 +4650,8 @@ return the corresponding 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="id81">
-<h4>Arguments<a class="headerlink" href="#id81" title="Link to this 
heading">¶</a></h4>
+<section id="id82">
+<h4>Arguments<a class="headerlink" href="#id82" title="Link 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>
@@ -4693,8 +4728,8 @@ Can be a constant, column, or function, and any 
combination of arithmetic operat
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_append</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id82">
-<h4>Arguments<a class="headerlink" href="#id82" title="Link to this 
heading">¶</a></h4>
+<section id="id83">
+<h4>Arguments<a class="headerlink" href="#id83" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -4712,8 +4747,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id83">
-<h4>Aliases<a class="headerlink" href="#id83" title="Link to this 
heading">¶</a></h4>
+<section id="id84">
+<h4>Aliases<a class="headerlink" href="#id84" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_push_back</p></li>
 <li><p>list_append</p></li>
@@ -4731,16 +4766,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_concat</span><span 
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span 
class="o">...</span><span class="p">,</span> <span 
class="n">array_n</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id84">
-<h4>Arguments<a class="headerlink" href="#id84" title="Link to this 
heading">¶</a></h4>
+<section id="id85">
+<h4>Arguments<a class="headerlink" href="#id85" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression to concatenate.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>array_n</strong>: Subsequent array column or literal array to 
concatenate.</p></li>
 </ul>
 </section>
-<section id="id85">
-<h4>Example<a class="headerlink" href="#id85" title="Link to this 
heading">¶</a></h4>
+<section id="id86">
+<h4>Example<a class="headerlink" href="#id86" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5, 
6]);
 +---------------------------------------------------+
 | array_concat(List([1,2]),List([3,4]),List([5,6])) |
@@ -4750,8 +4785,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id86">
-<h4>Aliases<a class="headerlink" href="#id86" title="Link to this 
heading">¶</a></h4>
+<section id="id87">
+<h4>Aliases<a class="headerlink" href="#id87" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_cat</p></li>
 <li><p>list_cat</p></li>
@@ -4765,8 +4800,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_has</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id87">
-<h4>Arguments<a class="headerlink" href="#id87" title="Link to this 
heading">¶</a></h4>
+<section id="id88">
+<h4>Arguments<a class="headerlink" href="#id88" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -4781,8 +4816,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_has_all</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">sub</span><span class="o">-</span><span class="n">array</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Link to this 
heading">¶</a></h4>
+<section id="id89">
+<h4>Arguments<a class="headerlink" href="#id89" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -4797,8 +4832,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_has_any</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">sub</span><span class="o">-</span><span class="n">array</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id89">
-<h4>Arguments<a class="headerlink" href="#id89" title="Link to this 
heading">¶</a></h4>
+<section id="id90">
+<h4>Arguments<a class="headerlink" href="#id90" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -4813,15 +4848,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_dims</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id90">
-<h4>Arguments<a class="headerlink" href="#id90" title="Link to this 
heading">¶</a></h4>
+<section id="id91">
+<h4>Arguments<a class="headerlink" href="#id91" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id91">
-<h4>Example<a class="headerlink" href="#id91" title="Link to this 
heading">¶</a></h4>
+<section id="id92">
+<h4>Example<a class="headerlink" href="#id92" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
 +---------------------------------+
 | array_dims(List([1,2,3,4,5,6])) |
@@ -4831,8 +4866,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id92">
-<h4>Aliases<a class="headerlink" href="#id92" title="Link to this 
heading">¶</a></h4>
+<section id="id93">
+<h4>Aliases<a class="headerlink" href="#id93" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_dims</p></li>
 </ul>
@@ -4844,16 +4879,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_element</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">index</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id93">
-<h4>Arguments<a class="headerlink" href="#id93" title="Link to this 
heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>index</strong>: Index to extract the element from the 
array.</p></li>
 </ul>
 </section>
-<section id="id94">
-<h4>Example<a class="headerlink" href="#id94" title="Link to this 
heading">¶</a></h4>
+<section id="id95">
+<h4>Example<a class="headerlink" href="#id95" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_element([1, 2, 3, 4], 3);
 +-----------------------------------------+
 | array_element(List([1,2,3,4]),Int64(3)) |
@@ -4863,8 +4898,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id95">
-<h4>Aliases<a class="headerlink" href="#id95" title="Link to this 
heading">¶</a></h4>
+<section id="id96">
+<h4>Aliases<a class="headerlink" href="#id96" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_extract</p></li>
 <li><p>list_element</p></li>
@@ -4886,8 +4921,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_fill</span><span 
class="p">(</span><span class="n">element</span><span class="p">,</span> <span 
class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Link to this 
heading">¶</a></h4>
+<section id="id97">
+<h4>Arguments<a class="headerlink" href="#id97" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -4903,8 +4938,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p>Does not change arrays that are already flat</p></li>
 </ul>
 <p>The flattened array contains all the elements from all source arrays.</p>
-<section id="id97">
-<h4>Arguments<a class="headerlink" href="#id97" title="Link to this 
heading">¶</a></h4>
+<section id="id98">
+<h4>Arguments<a class="headerlink" href="#id98" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -4928,16 +4963,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_length</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">dimension</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id98">
-<h4>Arguments<a class="headerlink" href="#id98" title="Link to this 
heading">¶</a></h4>
+<section id="id99">
+<h4>Arguments<a class="headerlink" href="#id99" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>dimension</strong>: Array dimension.</p></li>
 </ul>
 </section>
-<section id="id99">
-<h4>Example<a class="headerlink" href="#id99" title="Link to this 
heading">¶</a></h4>
+<section id="id100">
+<h4>Example<a class="headerlink" href="#id100" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_length([1, 2, 3, 4, 5]);
 +---------------------------------+
 | array_length(List([1,2,3,4,5])) |
@@ -4947,8 +4982,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id100">
-<h4>Aliases<a class="headerlink" href="#id100" title="Link to this 
heading">¶</a></h4>
+<section id="id101">
+<h4>Aliases<a class="headerlink" href="#id101" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_length</p></li>
 </ul>
@@ -4960,15 +4995,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_ndims</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id101">
-<h4>Arguments<a class="headerlink" href="#id101" title="Link to this 
heading">¶</a></h4>
+<section id="id102">
+<h4>Arguments<a class="headerlink" href="#id102" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id102">
-<h4>Example<a class="headerlink" href="#id102" title="Link to this 
heading">¶</a></h4>
+<section id="id103">
+<h4>Example<a class="headerlink" href="#id103" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_ndims([[1, 2, 3], [4, 5, 
6]]);
 +----------------------------------+
 | array_ndims(List([1,2,3,4,5,6])) |
@@ -4978,8 +5013,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id103">
-<h4>Aliases<a class="headerlink" href="#id103" title="Link to this 
heading">¶</a></h4>
+<section id="id104">
+<h4>Aliases<a class="headerlink" href="#id104" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_ndims</p></li>
 </ul>
@@ -4991,16 +5026,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_prepend</span><span 
class="p">(</span><span class="n">element</span><span class="p">,</span> <span 
class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id104">
-<h4>Arguments<a class="headerlink" href="#id104" title="Link to this 
heading">¶</a></h4>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>element</strong>: Element to prepend to the array.</p></li>
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id105">
-<h4>Example<a class="headerlink" href="#id105" title="Link to this 
heading">¶</a></h4>
+<section id="id106">
+<h4>Example<a class="headerlink" href="#id106" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_prepend(1, [2, 3, 4]);
 +---------------------------------------+
 | array_prepend(Int64(1),List([2,3,4])) |
@@ -5010,8 +5045,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id106">
-<h4>Aliases<a class="headerlink" href="#id106" title="Link to this 
heading">¶</a></h4>
+<section id="id107">
+<h4>Aliases<a class="headerlink" href="#id107" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_push_front</p></li>
 <li><p>list_prepend</p></li>
@@ -5025,15 +5060,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_pop_first</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id107">
-<h4>Arguments<a class="headerlink" href="#id107" title="Link to this 
heading">¶</a></h4>
+<section id="id108">
+<h4>Arguments<a class="headerlink" href="#id108" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id108">
-<h4>Example<a class="headerlink" href="#id108" title="Link to this 
heading">¶</a></h4>
+<section id="id109">
+<h4>Example<a class="headerlink" href="#id109" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_pop_first([1, 2, 3]);
 +-------------------------------+
 | array_pop_first(List([1,2,3])) |
@@ -5050,15 +5085,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_pop_back</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id109">
-<h4>Arguments<a class="headerlink" href="#id109" title="Link to this 
heading">¶</a></h4>
+<section id="id110">
+<h4>Arguments<a class="headerlink" href="#id110" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id110">
-<h4>Example<a class="headerlink" href="#id110" title="Link to this 
heading">¶</a></h4>
+<section id="id111">
+<h4>Example<a class="headerlink" href="#id111" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_pop_back([1, 2, 3]);
 +-------------------------------+
 | array_pop_back(List([1,2,3])) |
@@ -5076,8 +5111,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <span class="n">array_position</span><span class="p">(</span><span 
class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">,</span> <span 
class="n">index</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Link to this 
heading">¶</a></h4>
+<section id="id112">
+<h4>Arguments<a class="headerlink" href="#id112" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5085,8 +5120,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>index</strong>: Index at which to start searching.</p></li>
 </ul>
 </section>
-<section id="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Link to this 
heading">¶</a></h4>
+<section id="id113">
+<h4>Example<a class="headerlink" href="#id113" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_position([1, 2, 2, 3, 1, 4], 
2);
 +----------------------------------------------+
 | array_position(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5096,8 +5131,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id113">
-<h4>Aliases<a class="headerlink" href="#id113" title="Link to this 
heading">¶</a></h4>
+<section id="id114">
+<h4>Aliases<a class="headerlink" href="#id114" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_indexof</p></li>
 <li><p>list_indexof</p></li>
@@ -5111,16 +5146,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_positions</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this 
heading">¶</a></h4>
+<section id="id115">
+<h4>Arguments<a class="headerlink" href="#id115" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>element</strong>: Element to search for positions in the 
array.</p></li>
 </ul>
 </section>
-<section id="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this 
heading">¶</a></h4>
+<section id="id116">
+<h4>Example<a class="headerlink" href="#id116" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_positions([1, 2, 2, 3, 1, 
4], 2);
 +-----------------------------------------------+
 | array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5130,8 +5165,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id116">
-<h4>Aliases<a class="headerlink" href="#id116" title="Link to this 
heading">¶</a></h4>
+<section id="id117">
+<h4>Aliases<a class="headerlink" href="#id117" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_positions</p></li>
 </ul>
@@ -5151,16 +5186,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_repeat</span><span 
class="p">(</span><span class="n">element</span><span class="p">,</span> <span 
class="n">count</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Link to this 
heading">¶</a></h4>
+<section id="id118">
+<h4>Arguments<a class="headerlink" href="#id118" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>element</strong>: Element expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>count</strong>: Value of how many times to repeat the 
element.</p></li>
 </ul>
 </section>
-<section id="id118">
-<h4>Example<a class="headerlink" href="#id118" title="Link to this 
heading">¶</a></h4>
+<section id="id119">
+<h4>Example<a class="headerlink" href="#id119" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_repeat(1, 3);
 +---------------------------------+
 | array_repeat(Int64(1),Int64(3)) |
@@ -5185,16 +5220,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_remove</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id119">
-<h4>Arguments<a class="headerlink" href="#id119" title="Link to this 
heading">¶</a></h4>
+<section id="id120">
+<h4>Arguments<a class="headerlink" href="#id120" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>element</strong>: Element to be removed from the array.</p></li>
 </ul>
 </section>
-<section id="id120">
-<h4>Example<a class="headerlink" href="#id120" title="Link to this 
heading">¶</a></h4>
+<section id="id121">
+<h4>Example<a class="headerlink" href="#id121" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_remove([1, 2, 2, 3, 2, 1, 
4], 2);
 +----------------------------------------------+
 | array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -5204,8 +5239,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id121">
-<h4>Aliases<a class="headerlink" href="#id121" title="Link to this 
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove</p></li>
 </ul>
@@ -5217,8 +5252,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_remove_n</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">,</span> <span 
class="nb">max</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id122">
-<h4>Arguments<a class="headerlink" href="#id122" title="Link to this 
heading">¶</a></h4>
+<section id="id123">
+<h4>Arguments<a class="headerlink" href="#id123" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5226,8 +5261,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>max</strong>: Number of first occurrences to remove.</p></li>
 </ul>
 </section>
-<section id="id123">
-<h4>Example<a class="headerlink" href="#id123" title="Link to this 
heading">¶</a></h4>
+<section id="id124">
+<h4>Example<a class="headerlink" href="#id124" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_remove_n([1, 2, 2, 3, 2, 1, 
4], 2, 2);
 +---------------------------------------------------------+
 | array_remove_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(2)) |
@@ -5237,8 +5272,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id124">
-<h4>Aliases<a class="headerlink" href="#id124" title="Link to this 
heading">¶</a></h4>
+<section id="id125">
+<h4>Aliases<a class="headerlink" href="#id125" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove_n</p></li>
 </ul>
@@ -5250,16 +5285,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span 
class="n">array_remove_all</span><span class="p">(</span><span 
class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id125">
-<h4>Arguments<a class="headerlink" href="#id125" title="Link to this 
heading">¶</a></h4>
+<section id="id126">
+<h4>Arguments<a class="headerlink" href="#id126" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>element</strong>: Element to be removed from the array.</p></li>
 </ul>
 </section>
-<section id="id126">
-<h4>Example<a class="headerlink" href="#id126" title="Link to this 
heading">¶</a></h4>
+<section id="id127">
+<h4>Example<a class="headerlink" href="#id127" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_remove_all([1, 2, 2, 3, 2, 
1, 4], 2);
 +--------------------------------------------------+
 | array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -5269,8 +5304,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id127">
-<h4>Aliases<a class="headerlink" href="#id127" title="Link to this 
heading">¶</a></h4>
+<section id="id128">
+<h4>Aliases<a class="headerlink" href="#id128" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove_all</p></li>
 </ul>
@@ -5282,8 +5317,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_replace</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">from</span><span class="p">,</span> <span class="n">to</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id128">
-<h4>Arguments<a class="headerlink" href="#id128" title="Link to this 
heading">¶</a></h4>
+<section id="id129">
+<h4>Arguments<a class="headerlink" href="#id129" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5291,8 +5326,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>to</strong>: Final element.</p></li>
 </ul>
 </section>
-<section id="id129">
-<h4>Example<a class="headerlink" href="#id129" title="Link to this 
heading">¶</a></h4>
+<section id="id130">
+<h4>Example<a class="headerlink" href="#id130" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_replace([1, 2, 2, 3, 2, 1, 
4], 2, 5);
 +--------------------------------------------------------+
 | array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -5302,8 +5337,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id130">
-<h4>Aliases<a class="headerlink" href="#id130" title="Link to this 
heading">¶</a></h4>
+<section id="id131">
+<h4>Aliases<a class="headerlink" href="#id131" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_replace</p></li>
 </ul>
@@ -5315,8 +5350,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_replace_n</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">from</span><span class="p">,</span> <span class="n">to</span><span 
class="p">,</span> <span class="nb">max</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Link to this 
heading">¶</a></h4>
+<section id="id132">
+<h4>Arguments<a class="headerlink" href="#id132" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5325,8 +5360,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
 </ul>
 </section>
-<section id="id132">
-<h4>Example<a class="headerlink" href="#id132" title="Link to this 
heading">¶</a></h4>
+<section id="id133">
+<h4>Example<a class="headerlink" href="#id133" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_replace_n([1, 2, 2, 3, 2, 1, 
4], 2, 5, 2);
 +-------------------------------------------------------------------+
 | array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
@@ -5336,8 +5371,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id133">
-<h4>Aliases<a class="headerlink" href="#id133" title="Link to this 
heading">¶</a></h4>
+<section id="id134">
+<h4>Aliases<a class="headerlink" href="#id134" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_replace_n</p></li>
 </ul>
@@ -5349,8 +5384,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span 
class="n">array_replace_all</span><span class="p">(</span><span 
class="n">array</span><span class="p">,</span> <span class="n">from</span><span 
class="p">,</span> <span class="n">to</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Link to this 
heading">¶</a></h4>
+<section id="id135">
+<h4>Arguments<a class="headerlink" href="#id135" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5358,8 +5393,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>to</strong>: Final element.</p></li>
 </ul>
 </section>
-<section id="id135">
-<h4>Example<a class="headerlink" href="#id135" title="Link to this 
heading">¶</a></h4>
+<section id="id136">
+<h4>Example<a class="headerlink" href="#id136" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_replace_all([1, 2, 2, 3, 2, 
1, 4], 2, 5);
 +------------------------------------------------------------+
 | array_replace_all(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -5369,8 +5404,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id136">
-<h4>Aliases<a class="headerlink" href="#id136" title="Link to this 
heading">¶</a></h4>
+<section id="id137">
+<h4>Aliases<a class="headerlink" href="#id137" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_replace_all</p></li>
 </ul>
@@ -5382,8 +5417,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_slice</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">begin</span><span class="p">,</span> <span class="n">end</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id137">
-<h4>Example<a class="headerlink" href="#id137" title="Link to this 
heading">¶</a></h4>
+<section id="id138">
+<h4>Example<a class="headerlink" href="#id138" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_slice([1, 2, 3, 4, 5, 6, 7, 
8], 3, 6);
 +--------------------------------------------------------+
 | array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
@@ -5393,8 +5428,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id138">
-<h4>Aliases<a class="headerlink" href="#id138" title="Link to this 
heading">¶</a></h4>
+<section id="id139">
+<h4>Aliases<a class="headerlink" href="#id139" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_slice</p></li>
 </ul>
@@ -5406,16 +5441,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_to_string</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">delimiter</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id139">
-<h4>Arguments<a class="headerlink" href="#id139" title="Link to this 
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>delimiter</strong>: Array element separator.</p></li>
 </ul>
 </section>
-<section id="id140">
-<h4>Example<a class="headerlink" href="#id140" title="Link to this 
heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_to_string([[1, 2, 3, 4], [5, 
6, 7, 8]], &#39;,&#39;);
 +----------------------------------------------------+
 | array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(&quot;,&quot;)) |
@@ -5425,8 +5460,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id141">
-<h4>Aliases<a class="headerlink" href="#id141" title="Link to this 
heading">¶</a></h4>
+<section id="id142">
+<h4>Aliases<a class="headerlink" href="#id142" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_join</p></li>
 <li><p>list_join</p></li>
@@ -5440,8 +5475,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_union</span><span 
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span 
class="n">array2</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id142">
-<h4>Arguments<a class="headerlink" href="#id142" title="Link to this 
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array1</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5449,8 +5484,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id143">
-<h4>Example<a class="headerlink" href="#id143" title="Link to this 
heading">¶</a></h4>
+<section id="id144">
+<h4>Example<a class="headerlink" href="#id144" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_union([1, 2, 3, 4], [5, 6, 
3, 4]);
 +----------------------------------------------------+
 | array_union([1, 2, 3, 4], [5, 6, 3, 4]);           |
@@ -5467,8 +5502,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </div>
 </section>
 <hr class="docutils" />
-<section id="id144">
-<h4>Aliases<a class="headerlink" href="#id144" title="Link to this 
heading">¶</a></h4>
+<section id="id145">
+<h4>Aliases<a class="headerlink" href="#id145" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_union</p></li>
 </ul>
@@ -5480,8 +5515,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_except</span><span 
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span 
class="n">array2</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Link to this 
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array1</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5489,8 +5524,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id146">
-<h4>Example<a class="headerlink" href="#id146" title="Link to this 
heading">¶</a></h4>
+<section id="id147">
+<h4>Example<a class="headerlink" href="#id147" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6, 
3, 4]);
 +----------------------------------------------------+
 | array_except([1, 2, 3, 4], [5, 6, 3, 4]);           |
@@ -5507,8 +5542,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </div>
 </section>
 <hr class="docutils" />
-<section id="id147">
-<h4>Aliases<a class="headerlink" href="#id147" title="Link to this 
heading">¶</a></h4>
+<section id="id148">
+<h4>Aliases<a class="headerlink" href="#id148" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_except</p></li>
 </ul>
@@ -5520,15 +5555,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">cardinality</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id148">
-<h4>Arguments<a class="headerlink" href="#id148" title="Link to this 
heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id149">
-<h4>Example<a class="headerlink" href="#id149" title="Link to this 
heading">¶</a></h4>
+<section id="id150">
+<h4>Example<a class="headerlink" href="#id150" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6, 
7, 8]]);
 +--------------------------------------+
 | cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -5545,15 +5580,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">empty</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id150">
-<h4>Arguments<a class="headerlink" href="#id150" title="Link to this 
heading">¶</a></h4>
+<section id="id151">
+<h4>Arguments<a class="headerlink" href="#id151" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id151">
-<h4>Example<a class="headerlink" href="#id151" title="Link to this 
heading">¶</a></h4>
+<section id="id152">
+<h4>Example<a class="headerlink" href="#id152" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select empty([1]);
 +------------------+
 | empty(List([1])) |
@@ -5666,16 +5701,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">make_array</span><span 
class="p">(</span><span class="n">expression1</span><span class="p">[,</span> 
<span class="o">...</span><span class="p">,</span> <span 
class="n">expression_n</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this 
heading">¶</a></h4>
+<section id="id153">
+<h4>Arguments<a class="headerlink" href="#id153" title="Link 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
 string operators.</p></li>
 </ul>
 </section>
-<section id="id153">
-<h4>Example<a class="headerlink" href="#id153" title="Link to this 
heading">¶</a></h4>
+<section id="id154">
+<h4>Example<a class="headerlink" href="#id154" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select make_array(1, 2, 3, 4, 5);
 +----------------------------------------------------------+
 | make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
@@ -5685,8 +5720,8 @@ string operators.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id154">
-<h4>Aliases<a class="headerlink" href="#id154" title="Link to this 
heading">¶</a></h4>
+<section id="id155">
+<h4>Aliases<a class="headerlink" href="#id155" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>make_list</p></li>
 </ul>
@@ -5702,16 +5737,16 @@ string operators.</p></li>
 <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">delimiter</span><span class="p">[,</span> <span 
class="n">null_str</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this 
heading">¶</a></h4>
+<section id="id156">
+<h4>Arguments<a class="headerlink" href="#id156" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>str</strong>: String expression to split.</p></li>
 <li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
 <li><p><strong>null_str</strong>: Substring values to be replaced with <code 
class="docutils literal notranslate"><span 
class="pre">NULL</span></code></p></li>
 </ul>
 </section>
-<section id="id156">
-<h4>Aliases<a class="headerlink" href="#id156" title="Link to this 
heading">¶</a></h4>
+<section id="id157">
+<h4>Aliases<a class="headerlink" href="#id157" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>string_to_list</p></li>
 </ul>
@@ -5728,8 +5763,8 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">trim_array</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">n</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id157">
-<h4>Arguments<a class="headerlink" href="#id157" title="Link to this 
heading">¶</a></h4>
+<section id="id158">
+<h4>Arguments<a class="headerlink" href="#id158" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5742,8 +5777,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <p>Returns an Arrow array between start and stop with step. <code 
class="docutils literal notranslate"><span class="pre">SELECT</span> <span 
class="pre">range(2,</span> <span class="pre">10,</span> <span 
class="pre">3)</span> <span class="pre">-&gt;</span> <span 
class="pre">[2,</span> <span class="pre">5,</span> <span 
class="pre">8]</span></code></p>
 <p>The range start..end contains all values with start &lt;= x &lt; end. It is 
empty if start &gt;= end.</p>
 <p>Step can not be 0 (then the range will be nonsense.).</p>
-<section id="id158">
-<h4>Arguments<a class="headerlink" href="#id158" title="Link to this 
heading">¶</a></h4>
+<section id="id159">
+<h4>Arguments<a class="headerlink" href="#id159" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>start</strong>: start of the range</p></li>
 <li><p><strong>end</strong>: end of the range (not included)</p></li>
@@ -5784,8 +5819,8 @@ a struct type of fields <code class="docutils literal 
notranslate"><span class="
 <span class="o">+</span><span class="c1">-----------------+</span>
 </pre></div>
 </div>
-<section id="id159">
-<h4>Arguments<a class="headerlink" href="#id159" title="Link to this 
heading">¶</a></h4>
+<section id="id160">
+<h4>Arguments<a class="headerlink" href="#id160" title="Link 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
@@ -5810,8 +5845,8 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">digest</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="n">algorithm</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id160">
-<h4>Arguments<a class="headerlink" href="#id160" title="Link to this 
heading">¶</a></h4>
+<section id="id161">
+<h4>Arguments<a class="headerlink" href="#id161" title="Link 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>
@@ -5837,8 +5872,8 @@ Must be one of:</p>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">md5</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id161">
-<h4>Arguments<a class="headerlink" href="#id161" title="Link to this 
heading">¶</a></h4>
+<section id="id162">
+<h4>Arguments<a class="headerlink" href="#id162" title="Link 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>
@@ -5851,8 +5886,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="id162">
-<h4>Arguments<a class="headerlink" href="#id162" title="Link to this 
heading">¶</a></h4>
+<section id="id163">
+<h4>Arguments<a class="headerlink" href="#id163" title="Link 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>
@@ -5865,8 +5900,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="id163">
-<h4>Arguments<a class="headerlink" href="#id163" title="Link to this 
heading">¶</a></h4>
+<section id="id164">
+<h4>Arguments<a class="headerlink" href="#id164" title="Link 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>
@@ -5879,8 +5914,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="id164">
-<h4>Arguments<a class="headerlink" href="#id164" title="Link to this 
heading">¶</a></h4>
+<section id="id165">
+<h4>Arguments<a class="headerlink" href="#id165" title="Link 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>
@@ -5893,8 +5928,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="id165">
-<h4>Arguments<a class="headerlink" href="#id165" title="Link to this 
heading">¶</a></h4>
+<section id="id166">
+<h4>Arguments<a class="headerlink" href="#id166" title="Link 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>
@@ -5914,8 +5949,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="n">datatype</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id166">
-<h4>Arguments<a class="headerlink" href="#id166" title="Link to this 
heading">¶</a></h4>
+<section id="id167">
+<h4>Arguments<a class="headerlink" href="#id167" title="Link 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
@@ -5924,8 +5959,8 @@ string operators.</p></li>
 to cast to, as a string. The format is the same as that returned by [<code 
class="docutils literal notranslate"><span 
class="pre">arrow_typeof</span></code>]</p></li>
 </ul>
 </section>
-<section id="id167">
-<h4>Example<a class="headerlink" href="#id167" title="Link to this 
heading">¶</a></h4>
+<section id="id168">
+<h4>Example<a class="headerlink" href="#id168" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select arrow_cast(-5, &#39;Int8&#39;) as 
a,
   arrow_cast(&#39;foo&#39;, &#39;Dictionary(Int32, Utf8)&#39;) as b,
   arrow_cast(&#39;bar&#39;, &#39;LargeUtf8&#39;) as c,
@@ -5947,16 +5982,16 @@ to cast to, as a string. The format is the same as that 
returned by [<code class
 <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="id168">
-<h4>Arguments<a class="headerlink" href="#id168" title="Link to this 
heading">¶</a></h4>
+<section id="id169">
+<h4>Arguments<a class="headerlink" href="#id169" title="Link 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
 string operators.</p></li>
 </ul>
 </section>
-<section id="id169">
-<h4>Example<a class="headerlink" href="#id169" title="Link to this 
heading">¶</a></h4>
+<section id="id170">
+<h4>Example<a class="headerlink" href="#id170" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select arrow_typeof(&#39;foo&#39;), 
arrow_typeof(1);
 +---------------------------+------------------------+
 | arrow_typeof(Utf8(&quot;foo&quot;)) | arrow_typeof(Int64(1)) |