You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2024/05/11 18:35:48 UTC
(datafusion-python) branch asf-staging updated: Publish built docs triggered by 7d4a40cc73c37bcf41ccd3c6480627b03c9f93cc
This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-staging
in repository https://gitbox.apache.org/repos/asf/datafusion-python.git
The following commit(s) were added to refs/heads/asf-staging by this push:
new 56b7b0a Publish built docs triggered by 7d4a40cc73c37bcf41ccd3c6480627b03c9f93cc
56b7b0a is described below
commit 56b7b0a759c5dbe252fed67fa6ab6f967c9295cb
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Sat May 11 18:35:44 2024 +0000
Publish built docs triggered by 7d4a40cc73c37bcf41ccd3c6480627b03c9f93cc
---
_sources/api/object_store.rst.txt | 2 +-
.../common-operations/expressions.rst.txt | 94 +++++
.../user-guide/common-operations/functions.rst.txt | 3 +-
.../user-guide/common-operations/index.rst.txt | 1 +
_sources/user-guide/configuration.rst.txt | 4 +-
api.html | 5 +
api/dataframe.html | 5 +
api/execution_context.html | 5 +
api/expression.html | 5 +
api/functions.html | 5 +
api/object_store.html | 5 +
contributor-guide/introduction.html | 5 +
generated/datafusion.DataFrame.html | 5 +
generated/datafusion.Expr.html | 5 +
generated/datafusion.RuntimeConfig.html | 5 +
generated/datafusion.SessionConfig.html | 5 +
generated/datafusion.SessionContext.html | 5 +
generated/datafusion.functions.functions.html | 443 ++++++++++++---------
.../datafusion.object_store.object_store.html | 5 +
genindex.html | 5 +
index.html | 5 +
objects.inv | Bin 2915 -> 2930 bytes
py-modindex.html | 5 +
search.html | 5 +
searchindex.js | 2 +-
user-guide/basics.html | 5 +
user-guide/common-operations/aggregations.html | 39 +-
user-guide/common-operations/basic-info.html | 39 +-
.../{select-and-filter.html => expressions.html} | 217 +++++-----
user-guide/common-operations/functions.html | 58 +--
user-guide/common-operations/index.html | 12 +
user-guide/common-operations/joins.html | 13 +-
.../common-operations/select-and-filter.html | 13 +-
user-guide/common-operations/udf-and-udfa.html | 5 +
user-guide/common-operations/windows.html | 27 +-
user-guide/configuration.html | 7 +-
user-guide/introduction.html | 7 +-
user-guide/io/avro.html | 5 +
user-guide/io/csv.html | 5 +
user-guide/io/index.html | 5 +
user-guide/io/json.html | 5 +
user-guide/io/parquet.html | 5 +
user-guide/sql.html | 5 +
43 files changed, 731 insertions(+), 375 deletions(-)
diff --git a/_sources/api/object_store.rst.txt b/_sources/api/object_store.rst.txt
index eeb6c43..8d78f07 100644
--- a/_sources/api/object_store.rst.txt
+++ b/_sources/api/object_store.rst.txt
@@ -19,7 +19,7 @@
.. currentmodule:: datafusion.object_store
ObjectStore
-=========
+===========
.. autosummary::
:toctree: ../generated/
diff --git a/_sources/user-guide/common-operations/expressions.rst.txt b/_sources/user-guide/common-operations/expressions.rst.txt
new file mode 100644
index 0000000..ebb514f
--- /dev/null
+++ b/_sources/user-guide/common-operations/expressions.rst.txt
@@ -0,0 +1,94 @@
+.. Licensed to the Apache Software Foundation (ASF) under one
+.. or more contributor license agreements. See the NOTICE file
+.. distributed with this work for additional information
+.. regarding copyright ownership. The ASF licenses this file
+.. to you under the Apache License, Version 2.0 (the
+.. "License"); you may not use this file except in compliance
+.. with the License. You may obtain a copy of the License at
+
+.. http://www.apache.org/licenses/LICENSE-2.0
+
+.. Unless required by applicable law or agreed to in writing,
+.. software distributed under the License is distributed on an
+.. "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+.. KIND, either express or implied. See the License for the
+.. specific language governing permissions and limitations
+.. under the License.
+
+Expressions
+===========
+
+In DataFusion an expression is an abstraction that represents a computation.
+Expressions are used as the primary inputs and ouputs for most functions within
+DataFusion. As such, expressions can be combined to create expression trees, a
+concept shared across most compilers and databases.
+
+Column
+------
+
+The first expression most new users will interact with is the Column, which is created by calling :func:`col`.
+This expression represents a column within a DataFrame. The function :func:`col` takes as in input a string
+and returns an expression as it's output.
+
+Literal
+-------
+
+Literal expressions represent a single value. These are helpful in a wide range of operations where
+a specific, known value is of interest. You can create a literal expression using the function :func:`lit`.
+The type of the object passed to the :func:`lit` function will be used to convert it to a known data type.
+
+In the following example we create expressions for the column named `color` and the literal scalar string `red`.
+The resultant variable `red_units` is itself also an expression.
+
+.. ipython:: python
+
+ red_units = col("color") == lit("red")
+
+Boolean
+-------
+
+When combining expressions that evaluate to a boolean value, you can combine these expressions using boolean operators.
+It is important to note that in order to combine these expressions, you *must* use bitwise operators. See the following
+examples for the and, or, and not operations.
+
+
+.. ipython:: python
+
+ red_or_green_units = (col("color") == lit("red")) | (col("color") == lit("green"))
+ heavy_red_units = (col("color") == lit("red")) & (col("weight") > lit(42))
+ not_red_units = ~(col("color") == lit("red"))
+
+Functions
+---------
+
+As mentioned before, most functions in DataFusion return an expression at their output. This allows us to create
+a wide variety of expressions built up from other expressions. For example, :func:`.alias` is a function that takes
+as it input a single expression and returns an expression in which the name of the expression has changed.
+
+The following example shows a series of expressions that are built up from functions operating on expressions.
+
+.. ipython:: python
+
+ from datafusion import SessionContext
+ from datafusion import column, lit
+ from datafusion import functions as f
+ import random
+
+ ctx = SessionContext()
+ df = ctx.from_pydict(
+ {
+ "name": ["Albert", "Becca", "Carlos", "Dante"],
+ "age": [42, 67, 27, 71],
+ "years_in_position": [13, 21, 10, 54],
+ },
+ name="employees"
+ )
+
+ age_col = col("age")
+ renamed_age = age_col.alias("age_in_years")
+ start_age = age_col - col("years_in_position")
+ started_young = start_age < lit(18)
+ can_retire = age_col > lit(65)
+ long_timer = started_young & can_retire
+
+ df.filter(long_timer).select(col("name"), renamed_age, col("years_in_position"))
diff --git a/_sources/user-guide/common-operations/functions.rst.txt b/_sources/user-guide/common-operations/functions.rst.txt
index 7e5c592..50b4930 100644
--- a/_sources/user-guide/common-operations/functions.rst.txt
+++ b/_sources/user-guide/common-operations/functions.rst.txt
@@ -92,13 +92,12 @@ DataFusion offers a range of helpful options.
f.left(col('"Name"'), literal(4)).alias("code")
)
-This also includes the functions for regular expressions :func:`.regexp_replace` and :func:`.regexp_match`
+This also includes the functions for regular expressions like :func:`.regexp_match`
.. ipython:: python
df.select(
f.regexp_match(col('"Name"'), literal("Char")).alias("dragons"),
- f.regexp_replace(col('"Name"'), literal("saur"), literal("fleur")).alias("flowers")
)
diff --git a/_sources/user-guide/common-operations/index.rst.txt b/_sources/user-guide/common-operations/index.rst.txt
index 950afb9..b15b04c 100644
--- a/_sources/user-guide/common-operations/index.rst.txt
+++ b/_sources/user-guide/common-operations/index.rst.txt
@@ -23,6 +23,7 @@ Common Operations
basic-info
select-and-filter
+ expressions
joins
functions
aggregations
diff --git a/_sources/user-guide/configuration.rst.txt b/_sources/user-guide/configuration.rst.txt
index 63b0dc3..0c1a481 100644
--- a/_sources/user-guide/configuration.rst.txt
+++ b/_sources/user-guide/configuration.rst.txt
@@ -16,7 +16,7 @@
.. under the License.
Configuration
-========
+=============
Let's look at how we can configure DataFusion. When creating a :code:`SessionContext`, you can pass in
a :code:`SessionConfig` and :code:`RuntimeConfig` object. These two cover a wide range of options.
@@ -48,4 +48,4 @@ a :code:`SessionConfig` and :code:`RuntimeConfig` object. These two cover a wide
You can read more about available :code:`SessionConfig` options `here <https://arrow.apache.org/datafusion/user-guide/configs.html>`_,
-and about :code:`RuntimeConfig` options `here https://docs.rs/datafusion/latest/datafusion/execution/runtime_env/struct.RuntimeConfig.html`_.
+and about :code:`RuntimeConfig` options `here <https://docs.rs/datafusion/latest/datafusion/execution/runtime_env/struct.RuntimeConfig.html>`_.
diff --git a/api.html b/api.html
index eef339a..94f34f4 100644
--- a/api.html
+++ b/api.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/common-operations/joins.html">
Joins
diff --git a/api/dataframe.html b/api/dataframe.html
index 63c06d7..38e50d1 100644
--- a/api/dataframe.html
+++ b/api/dataframe.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/api/execution_context.html b/api/execution_context.html
index 4772d68..6b76f71 100644
--- a/api/execution_context.html
+++ b/api/execution_context.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/api/expression.html b/api/expression.html
index ce68ca5..6d1dd25 100644
--- a/api/expression.html
+++ b/api/expression.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/api/functions.html b/api/functions.html
index abcdd51..328e6aa 100644
--- a/api/functions.html
+++ b/api/functions.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/api/object_store.html b/api/object_store.html
index ec712cb..9563b33 100644
--- a/api/object_store.html
+++ b/api/object_store.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/contributor-guide/introduction.html b/contributor-guide/introduction.html
index 8b9f90a..da2b1e7 100644
--- a/contributor-guide/introduction.html
+++ b/contributor-guide/introduction.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/generated/datafusion.DataFrame.html b/generated/datafusion.DataFrame.html
index 25644a1..aa6cb27 100644
--- a/generated/datafusion.DataFrame.html
+++ b/generated/datafusion.DataFrame.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/generated/datafusion.Expr.html b/generated/datafusion.Expr.html
index eb2c6b2..1839618 100644
--- a/generated/datafusion.Expr.html
+++ b/generated/datafusion.Expr.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/generated/datafusion.RuntimeConfig.html b/generated/datafusion.RuntimeConfig.html
index 4a7b558..bd128e5 100644
--- a/generated/datafusion.RuntimeConfig.html
+++ b/generated/datafusion.RuntimeConfig.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/generated/datafusion.SessionConfig.html b/generated/datafusion.SessionConfig.html
index 5de0184..d23c9a3 100644
--- a/generated/datafusion.SessionConfig.html
+++ b/generated/datafusion.SessionConfig.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/generated/datafusion.SessionContext.html b/generated/datafusion.SessionContext.html
index 316c480..3cc82f4 100644
--- a/generated/datafusion.SessionContext.html
+++ b/generated/datafusion.SessionContext.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/generated/datafusion.functions.functions.html b/generated/datafusion.functions.functions.html
index 1949e26..b3ef57a 100644
--- a/generated/datafusion.functions.functions.html
+++ b/generated/datafusion.functions.functions.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
@@ -2227,13 +2232,15 @@
<span id="datafusion-functions-functions"></span><h1>datafusion.functions.functions<a class="headerlink" href="#module-datafusion.functions.functions" title="Link to this heading">¶</a></h1>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.abs">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">abs</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.abs" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">abs</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">num</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.abs" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.acos">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">acos</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.acos" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">acos</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">num</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.acos" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.acosh">
@@ -2268,7 +2275,7 @@
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">exprs</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
@@ -2278,189 +2285,219 @@
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_append">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_append</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_append" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_append</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_append" title="Link [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_cat">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_cat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_cat" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_cat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">exprs</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_cat" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_concat">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_concat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_concat" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_concat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">exprs</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_concat" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_dims">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_dims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_dims" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_dims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_dims" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_distinct">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_distinct</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_distinct" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_distinct</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_distinct" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_element">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_element</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_element" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_element</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_element" title="Li [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_except">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_except</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_except" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_except</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_except" [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_extract">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_extract</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_extract" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_extract</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_extract" title="Li [...]
+<dd><p>array_element</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_has">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_has</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_has" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_has</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_has" title= [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_has_all">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_has_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_has_all" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_has_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_has_all [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_has_any">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_has_any</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_has_any" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_has_any</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_has_any [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_indexof">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_indexof</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_indexof" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_indexof</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">index</span></span><span class="o"><span class="pre">=</sp [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_intersect">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_intersect</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_intersect" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_intersect</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_inter [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_join">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_join</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">expr</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delim</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_join" title="Link to thi [...]
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_join</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delimiter</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_join" title="Link t [...]
+<dd><p>array_to_string</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_length">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_length" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_length" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_ndims">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_ndims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_ndims" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_ndims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_ndims" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_pop_back">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_pop_back</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_pop_back" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_pop_back</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_pop_back" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_pop_front">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_pop_front</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_pop_front" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_pop_front</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_pop_front" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_position">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_position</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_position" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_position</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">index</span></span><span class="o"><span class="pre">=</s [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_positions">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_positions</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_positions" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_positions</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_positions" title [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_prepend">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_prepend</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_prepend" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_prepend</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_prepend" title="Li [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_push_back">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_push_back</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_push_back" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_push_back</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_push_back" title [...]
+<dd><p>array_append</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_push_front">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_push_front</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_push_front" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_push_front</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_push_front" tit [...]
+<dd><p>array_prepend</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_remove">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_remove</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_remove" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_remove</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_remove" title="Link [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_remove_all">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_remove_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_remove_all" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_remove_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_remove_all" tit [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_remove_n">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_remove_n</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_remove_n" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_remove_n</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">max</span></span></em><span class="sig-paren">)</span><a [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_repeat">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_repeat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_repeat" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_repeat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">count</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_repeat" title="Link [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_replace">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_replace</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_replace" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_replace</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_replace" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_replace_all">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_replace_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_replace_all" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_replace_all</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_replace_all" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_replace_n">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_replace_n</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_replace_n" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_replace_n</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_replace_n" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_resize">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_resize</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_resize" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_resize</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">size</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">value</span></span></em><span class="sig-paren">)</span><a cla [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_slice">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_slice</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_slice" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_slice</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">begin</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">end</span></span></em>, <em class="sig-param"><span class="n"> [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_to_string">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_to_string</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">expr</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delim</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_to_string" title="L [...]
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_to_string</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delimiter</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_to_string" tit [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.array_union">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_union</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_union" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">array_union</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">array2</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.array_union" title="Link t [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.arrow_typeof">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">arrow_typeof</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.arrow_typeof" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">arrow_typeof</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg_1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.arrow_typeof" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.ascii">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">ascii</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.ascii" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">ascii</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.ascii" title="Link to this definition">¶</a></dt>
<dd><p>Returns the numeric code of the first character of the argument. In UTF8 encoding, returns the Unicode code point of the character. In other multibyte encodings, the argument must be an ASCII character.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.asin">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">asin</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.asin" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">asin</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">num</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.asin" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.asinh">
@@ -2494,7 +2531,7 @@
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.bit_length">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">bit_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.bit_length" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">bit_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.bit_length" title="Link to this definition">¶</a></dt>
<dd><p>Returns number of bits in the string (8 times the octet_length).</p>
</dd></dl>
@@ -2542,18 +2579,19 @@
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.char_length">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">char_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.char_length" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">char_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">string</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.char_length" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.character_length">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">character_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.character_length" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">character_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">string</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.character_length" title="Link to this definition">¶</a></dt>
<dd><p>Returns number of characters in the string.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.chr">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">chr</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.chr" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">chr</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.chr" title="Link to this definition">¶</a></dt>
<dd><p>Returns the character with the given code.</p>
</dd></dl>
@@ -2626,43 +2664,49 @@ Other NULL arguments are ignored.</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.current_date">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">current_date</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.current_date" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">current_date</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.current_date" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.current_time">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">current_time</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.current_time" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">current_time</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.current_time" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.date_bin">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">date_bin</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.date_bin" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">date_bin</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">stride</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">source</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">origin</span></span></em><span class="sig-paren">)</span><a cla [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.date_part">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">date_part</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.date_part" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">date_part</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">part</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">date</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.date_part" title="Link to this d [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.date_trunc">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">date_trunc</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.date_trunc" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">date_trunc</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">part</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">date</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.date_trunc" title="Link to this [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.datepart">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">datepart</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.datepart" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">datepart</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">part</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">date</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.datepart" title="Link to this def [...]
+<dd><p>date_part</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.datetrunc">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">datetrunc</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.datetrunc" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">datetrunc</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">part</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">date</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.datetrunc" title="Link to this d [...]
+<dd><p>date_trunc</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.decode">
<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">decode</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">encoding</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.decode" title="Link to this de [...]
-<dd></dd></dl>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.degrees">
@@ -2679,7 +2723,8 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.encode">
<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">encode</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">encoding</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.encode" title="Link to this de [...]
-<dd></dd></dl>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.exp">
@@ -2698,8 +2743,9 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.flatten">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">flatten</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.flatten" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">flatten</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.flatten" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.floor">
@@ -2708,8 +2754,9 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.from_unixtime">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">from_unixtime</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.from_unixtime" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">from_unixtime</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">unixtime</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.from_unixtime" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.gcd">
@@ -2734,8 +2781,9 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.isnan">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">isnan</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">expr</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.isnan" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">isnan</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">num</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.isnan" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.iszero">
@@ -2760,138 +2808,162 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.length">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.length" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">string</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.length" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_append">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_append</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_append" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_append</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_append" title="Link t [...]
+<dd><p>array_append</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_dims">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_dims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_dims" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_dims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_dims" title="Link to this definition">¶</a></dt>
+<dd><p>array_dims</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_distinct">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_distinct</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_distinct" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_distinct</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_distinct" title="Link to this definition">¶</a></dt>
+<dd><p>array_distinct</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_element">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_element</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_element" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_element</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_element" title="Link [...]
+<dd><p>array_element</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_except">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_except</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_except" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_except</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_except" ti [...]
+<dd><p>array_except</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_extract">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_extract</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_extract" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_extract</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_extract" title="Link [...]
+<dd><p>array_element</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_indexof">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_indexof</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_indexof" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_indexof</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">index</span></span><span class="o"><span class="pre">=</spa [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_intersect">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_intersect</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_intersect" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_intersect</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">first_array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">second_array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_interse [...]
+<dd><p>array_intersect</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_join">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_join</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">expr</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delim</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_join" title="Link to this [...]
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_join</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delimiter</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_join" title="Link to [...]
+<dd><p>array_to_string</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_length">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_length" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_length</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_length" title="Link to this definition">¶</a></dt>
+<dd><p>array_length</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_ndims">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_ndims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_ndims" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_ndims</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_ndims" title="Link to this definition">¶</a></dt>
+<dd><p>array_ndims</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_position">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_position</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_position" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_position</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">index</span></span><span class="o"><span class="pre">=</sp [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_positions">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_positions</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_positions" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_positions</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_positions" title=" [...]
+<dd><p>array_positions</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_prepend">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_prepend</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_prepend" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_prepend</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_prepend" title="Link [...]
+<dd><p>array_prepend</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_push_back">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_push_back</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_push_back" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_push_back</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_push_back" title=" [...]
+<dd><p>array_append</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_push_front">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_push_front</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_push_front" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_push_front</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">array</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_push_front" title [...]
+<dd><p>array_prepend</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_remove">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_remove</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_remove" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_remove</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_remove" title="Link t [...]
+<dd><p>array_remove</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_remove_all">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_remove_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_remove_all" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_remove_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_remove_all" title [...]
+<dd><p>array_remove_all</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_remove_n">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_remove_n</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_remove_n" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_remove_n</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">element</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">max</span></span></em><span class="sig-paren">)</span><a c [...]
+<dd><p>array_remove_n</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_replace">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_replace</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_replace" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_replace</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_replace" title="Link to this definition">¶</a></dt>
+<dd><p>array_replace</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_replace_all">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_replace_all</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_replace_all" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_replace_all</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_replace_all" title="Link to this definition">¶</a></dt>
+<dd><p>array_replace_all</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_replace_n">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_replace_n</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_replace_n" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_replace_n</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_replace_n" title="Link to this definition">¶</a></dt>
+<dd><p>array_replace_n</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_resize">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_resize</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_resize" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_resize</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">size</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">value</span></span></em><span class="sig-paren">)</span><a clas [...]
+<dd><p>array_resize</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_slice">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_slice</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_slice" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_slice</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">begin</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">end</span></span></em>, <em class="sig-param"><span class="n">< [...]
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_to_string">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_to_string</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">expr</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delim</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_to_string" title="Lin [...]
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_to_string</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delimiter</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_to_string" title [...]
+<dd><p>array_to_string</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.list_union">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_union</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_union" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">list_union</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">array1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">array2</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.list_union" title="Link to [...]
+<dd><p>array_union</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.ln">
@@ -2915,7 +2987,7 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.lower">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">lower</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.lower" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">lower</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.lower" title="Link to this definition">¶</a></dt>
<dd><p>Converts the string to all lower case</p>
</dd></dl>
@@ -2933,7 +3005,7 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.make_array">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">make_array</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.make_array" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">make_array</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">exprs</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.make_array" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
@@ -2943,7 +3015,7 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.md5">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">md5</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.md5" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">md5</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input_arg</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.md5" title="Link to this definition">¶</a></dt>
<dd><p>Computes the MD5 hash of the argument, with the result written in hexadecimal.</p>
</dd></dl>
@@ -2970,13 +3042,14 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.now">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">now</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.now" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">now</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.now" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.nullif">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">nullif</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">expr1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">expr2</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.nullif" title="Link to this defin [...]
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">nullif</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg_1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">arg_2</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.nullif" title="Link to this defin [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.octet_length">
@@ -3017,18 +3090,20 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.range">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">range</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.range" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">range</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">start</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">stop</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">step</span></span></em><span class="sig-paren">)</span><a class="head [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.regexp_match">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">regexp_match</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.regexp_match" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">regexp_match</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input_arg1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">input_arg2</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.regexp_match" tit [...]
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.regexp_replace">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">regexp_replace</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.regexp_replace" title="Link to this definition">¶</a></dt>
-<dd><p>Replaces substring(s) matching a POSIX regular expression</p>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">regexp_replace</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">arg2</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">arg3</span></span></em>, <em class="sig-param"><span class="n [...]
+<dd><p>Replaces substring(s) matching a POSIX regular expression.</p>
</dd></dl>
<dl class="py function">
@@ -3078,13 +3153,13 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.repeat">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">repeat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.repeat" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">repeat</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">string</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">n</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.repeat" title="Link to this definiti [...]
<dd><p>Repeats string the specified number of times.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.replace">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">replace</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.replace" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">replace</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.replace" title="Link to this definition">¶</a></dt>
<dd><p>Replaces all occurrences in string of substring from with substring to.</p>
</dd></dl>
@@ -3119,23 +3194,27 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.sha224">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha224</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha224" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha224</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input_arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha224" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.sha256">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha256</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha256" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha256</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input_arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha256" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.sha384">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha384</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha384" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha384</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input_arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha384" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.sha512">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha512</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha512" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">sha512</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">input_arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.sha512" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.signum">
@@ -3154,7 +3233,7 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.split_part">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">split_part</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.split_part" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">split_part</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">string</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">delimiter</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">index</span></span></em><span class="sig-paren">)</span><a [...]
<dd><p>Splits string at occurrences of delimiter and returns the n’th field (counting from one).</p>
</dd></dl>
@@ -3165,7 +3244,7 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.starts_with">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">starts_with</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.starts_with" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">starts_with</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg1</span></span></em>, <em class="sig-param"><span class="n"><span class="pre">arg2</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.starts_with" title="Link to th [...]
<dd><p>Returns true if string starts with prefix.</p>
</dd></dl>
@@ -3192,8 +3271,8 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.struct">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">struct</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.struct" title="Link to this definition">¶</a></dt>
-<dd><p>r#struct</p>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">struct</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.struct" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
</dd></dl>
<dl class="py function">
@@ -3208,17 +3287,19 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.tan">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">tan</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.tan" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">tan</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">num</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.tan" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.tanh">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">tanh</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.tanh" title="Link to this definition">¶</a></dt>
-<dd></dd></dl>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">tanh</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">num</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.tanh" title="Link to this definition">¶</a></dt>
+<dd><p>$FUNC</p>
+</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.to_hex">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">to_hex</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.to_hex" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">to_hex</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.to_hex" title="Link to this definition">¶</a></dt>
<dd><p>Converts the number to its equivalent hexadecimal representation.</p>
</dd></dl>
@@ -3261,13 +3342,13 @@ Standard algorithms are md5, sha224, sha256, sha384, sha512, blake2s, blake2b, a
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.upper">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">upper</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.upper" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">upper</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">arg1</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.upper" title="Link to this definition">¶</a></dt>
<dd><p>Converts the string to all upper case.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.functions.uuid">
-<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">uuid</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="o"><span class="pre">*</span></span><span class="n"><span class="pre">args</span></span></em><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.uuid" title="Link to this definition">¶</a></dt>
+<span class="sig-prename descclassname"><span class="pre">datafusion.functions.functions.</span></span><span class="sig-name descname"><span class="pre">uuid</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="headerlink" href="#datafusion.functions.functions.uuid" title="Link to this definition">¶</a></dt>
<dd></dd></dl>
<dl class="py function">
diff --git a/generated/datafusion.object_store.object_store.html b/generated/datafusion.object_store.object_store.html
index b171ff4..ecac9cd 100644
--- a/generated/datafusion.object_store.object_store.html
+++ b/generated/datafusion.object_store.object_store.html
@@ -135,6 +135,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/common-operations/joins.html">
Joins
diff --git a/genindex.html b/genindex.html
index 635b50e..0bf8a61 100644
--- a/genindex.html
+++ b/genindex.html
@@ -133,6 +133,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/common-operations/joins.html">
Joins
diff --git a/index.html b/index.html
index d9c82cc..fce35a1 100644
--- a/index.html
+++ b/index.html
@@ -135,6 +135,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/common-operations/joins.html">
Joins
diff --git a/objects.inv b/objects.inv
index f9a0644..19f5d21 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/py-modindex.html b/py-modindex.html
index 46af645..c1072a8 100644
--- a/py-modindex.html
+++ b/py-modindex.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/common-operations/joins.html">
Joins
diff --git a/search.html b/search.html
index 514d8a4..6f89013 100644
--- a/search.html
+++ b/search.html
@@ -140,6 +140,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/common-operations/joins.html">
Joins
diff --git a/searchindex.js b/searchindex.js
index 8ea670e..0f9f56b 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[0, "api-reference"]], "Aggregation": [[16, "aggregation"]], "Avro": [[26, "avro"]], "Basic Operations": [[17, "basic-operations"]], "CSV": [[27, "csv"]], "Column Selections": [[21, "column-selections"]], "Common Operations": [[19, "common-operations"]], "Concepts": [[15, "concepts"]], "Conditional": [[18, "conditional"]], "Configuration": [[24, "configuration"]], "DataFrame": [[1, "dataframe"]], "DataFusion in Python": [[14, "datafusion-i [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[0, "api-reference"]], "Aggregation": [[16, "aggregation"]], "Avro": [[27, "avro"]], "Basic Operations": [[17, "basic-operations"]], "Boolean": [[18, "boolean"]], "CSV": [[28, "csv"]], "Column": [[18, "column"]], "Column Selections": [[22, "column-selections"]], "Common Operations": [[20, "common-operations"]], "Concepts": [[15, "concepts"]], "Conditional": [[19, "conditional"]], "Configuration": [[25, "configuration"]], "DataFrame": [[1, [...]
\ No newline at end of file
diff --git a/user-guide/basics.html b/user-guide/basics.html
index b4ac08b..1d3bcc0 100644
--- a/user-guide/basics.html
+++ b/user-guide/basics.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="common-operations/joins.html">
Joins
diff --git a/user-guide/common-operations/aggregations.html b/user-guide/common-operations/aggregations.html
index a768c0d..c35b574 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
@@ -412,7 +417,7 @@ For performing an aggregation, DataFusion provides the <a class="reference inter
<span class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">APPROX_DISTINCT</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span class="p">)</span> <span class="o">|</span> <span class="n">APPROX_MEDIAN</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span class="p">)</span> <span class="o">|</span> <span class="n">APPROX_PERCENTILE_CONT</span><span class="p">(</span><span class="n">foo_ [...]
<span class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="mi">8</span> <span class="o">|</span> <span class="mf">0.6648406270711174</span> <span class="o">|</span> <span class="mf">0.6648406270711174</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">8</span> <span class="o">|</span> <span class="mf">0.7259722187761173</span> <span class="o">|</span> <span class="mf">0.7259722187761173</span> <span class="o">|</span>
<span class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
</pre></div>
</div>
@@ -421,28 +426,28 @@ the <code class="code docutils literal notranslate"><span class="pre">group_by</
<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">12</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">aggregate</span><span class="p">([</span><span class="n">col_a</span><span class="p">],</span> <span class="p">[</span><span class="n">f</span><span class="o">.</span><span class="n">sum</span><span class="p">(</span><span class="n">col_c</s [...]
<span class="n">Out</span><span class="p">[</span><span class="mi">12</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+-----+----------------+--------------------+----------------------+</span>
-<span class="o">|</span> <span class="n">a</span> <span class="o">|</span> <span class="n">SUM</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span class="p">)</span> <span class="o">|</span> <span class="n">MAX</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span class="p">)</span> <span class="o">|</span> <span class="n">MIN</span><span class="p">(</span><span [...]
-<span class="o">+-----+----------------+--------------------+----------------------+</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="mi">244</span> <span class="o">|</span> <span class="mf">0.9359101741687502</span> <span class="o">|</span> <span class="mf">0.058844576416049454</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="mi">91</span> <span class="o">|</span> <span class="mf">0.8118384852259612</span> <span class="o">|</span> <span class="mf">0.578517502762024</span> <span class="o">|</span>
-<span class="o">+-----+----------------+--------------------+----------------------+</span>
+<span class="o">+-----+----------------+--------------------+---------------------+</span>
+<span class="o">|</span> <span class="n">a</span> <span class="o">|</span> <span class="n">SUM</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span class="p">)</span> <span class="o">|</span> <span class="n">MAX</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span class="p">)</span> <span class="o">|</span> <span class="n">MIN</span><span class="p">(</span><span [...]
+<span class="o">+-----+----------------+--------------------+---------------------+</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="mi">205</span> <span class="o">|</span> <span class="mf">0.9370810313634331</span> <span class="o">|</span> <span class="mf">0.287012337305256</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="mi">333</span> <span class="o">|</span> <span class="mf">0.8741868408264222</span> <span class="o">|</span> <span class="mf">0.06892104326534854</span> <span class="o">|</span>
+<span class="o">+-----+----------------+--------------------+---------------------+</span>
</pre></div>
</div>
<p>More than one column can be used for grouping</p>
<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">13</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">aggregate</span><span class="p">([</span><span class="n">col_a</span><span class="p">,</span> <span class="n">col_b</span><span class="p">],</span> <span class="p">[</span><span class="n">f</span><span class="o">.</span><span class="n">sum</ [...]
<span class="n">Out</span><span class="p">[</span><span class="mi">13</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+-----+-------+----------------+----------------------+----------------------+</span>
-<span class="o">|</span> <span class="n">a</span> <span class="o">|</span> <span class="n">b</span> <span class="o">|</span> <span class="n">SUM</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span class="p">)</span> <span class="o">|</span> <span class="n">MAX</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span class="p">)</span> <span class="o">|</span> [...]
-<span class="o">+-----+-------+----------------+----------------------+----------------------+</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="n">one</span> <span class="o">|</span> <span class="mi">83</span> <span class="o">|</span> <span class="mf">0.9359101741687502</span> <span class="o">|</span> <span class="mf">0.9018455091695036</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="n">three</span> <span class="o">|</span> <span class="mi">4</span> <span class="o">|</span> <span class="mf">0.8118384852259612</span> <span class="o">|</span> <span class="mf">0.8118384852259612</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="n">two</span> <span class="o">|</span> <span class="mi">48</span> <span class="o">|</span> <span class="mf">0.578517502762024</span> <span class="o">|</span> <span class="mf">0.578517502762024</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="n">one</span> <span class="o">|</span> <span class="mi">39</span> <span class="o">|</span> <span class="mf">0.7231708726871017</span> <span class="o">|</span> <span class="mf">0.7231708726871017</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="n">two</span> <span class="o">|</span> <span class="mi">108</span> <span class="o">|</span> <span class="mf">0.5705040279845847</span> <span class="o">|</span> <span class="mf">0.30327062720677633</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="n">three</span> <span class="o">|</span> <span class="mi">53</span> <span class="o">|</span> <span class="mf">0.058844576416049454</span> <span class="o">|</span> <span class="mf">0.058844576416049454</span> <span class="o">|</span>
-<span class="o">+-----+-------+----------------+----------------------+----------------------+</span>
+<span class="o">+-----+-------+----------------+---------------------+---------------------+</span>
+<span class="o">|</span> <span class="n">a</span> <span class="o">|</span> <span class="n">b</span> <span class="o">|</span> <span class="n">SUM</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span class="p">)</span> <span class="o">|</span> <span class="n">MAX</span><span class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span class="p">)</span> <span class="o">|</span> [...]
+<span class="o">+-----+-------+----------------+---------------------+---------------------+</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="n">one</span> <span class="o">|</span> <span class="mi">39</span> <span class="o">|</span> <span class="mf">0.287012337305256</span> <span class="o">|</span> <span class="mf">0.287012337305256</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="n">two</span> <span class="o">|</span> <span class="mi">94</span> <span class="o">|</span> <span class="mf">0.8034857098653344</span> <span class="o">|</span> <span class="mf">0.1555007547499314</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="n">three</span> <span class="o">|</span> <span class="mi">78</span> <span class="o">|</span> <span class="mf">0.06892104326534854</span> <span class="o">|</span> <span class="mf">0.06892104326534854</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="n">three</span> <span class="o">|</span> <span class="mi">89</span> <span class="o">|</span> <span class="mf">0.5336624972126576</span> <span class="o">|</span> <span class="mf">0.5336624972126576</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span> <span class="n">two</span> <span class="o">|</span> <span class="mi">77</span> <span class="o">|</span> <span class="mf">0.9370810313634331</span> <span class="o">|</span> <span class="mf">0.9370810313634331</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span> <span class="n">one</span> <span class="o">|</span> <span class="mi">161</span> <span class="o">|</span> <span class="mf">0.8741868408264222</span> <span class="o">|</span> <span class="mf">0.8437164615695262</span> <span class="o">|</span>
+<span class="o">+-----+-------+----------------+---------------------+---------------------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/basic-info.html b/user-guide/common-operations/basic-info.html
index f157c3a..0e4a87e 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
@@ -396,11 +401,11 @@
<span class="o">+-----+---------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span class="n">random</span> <span class="o">|</span> <span class="n">groups</span> <span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> <span class="n">python</span> <span class="o">|</span> <span class="mi">875</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span class="mi">868</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span> <span class="n">java</span> <span class="o">|</span> <span class="mi">31</span> <span class="o">|</span> <span class="n">B</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">4</span> <span class="o">|</span> <span class="n">haskell</span> <span class="o">|</span> <span class="mi">249</span> <span class="o">|</span> <span class="n">C</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span class="mi">280</span> <span class="o">|</span> <span class="n">B</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> <span class="n">python</span> <span class="o">|</span> <span class="mi">208</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span class="mi">342</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span> <span class="n">java</span> <span class="o">|</span> <span class="mi">595</span> <span class="o">|</span> <span class="n">B</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">4</span> <span class="o">|</span> <span class="n">haskell</span> <span class="o">|</span> <span class="mi">924</span> <span class="o">|</span> <span class="n">C</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span class="mi">836</span> <span class="o">|</span> <span class="n">B</span> <span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -411,8 +416,8 @@
<span class="o">+-----+--------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span class="n">random</span> <span class="o">|</span> <span class="n">groups</span> <span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> <span class="n">python</span> <span class="o">|</span> <span class="mi">875</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span class="mi">868</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> <span class="n">python</span> <span class="o">|</span> <span class="mi">208</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span class="mi">342</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -430,11 +435,11 @@ passing them to an Arrow table, and then converting them to a pandas DataFrame.<
<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">to_pandas</span><span class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span class="mi">8</span><span class="p">]:</span>
<span class="n">nrs</span> <span class="n">names</span> <span class="n">random</span> <span class="n">groups</span>
-<span class="mi">0</span> <span class="mi">1</span> <span class="n">python</span> <span class="mi">875</span> <span class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span class="n">ruby</span> <span class="mi">868</span> <span class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span class="n">java</span> <span class="mi">31</span> <span class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span class="n">haskell</span> <span class="mi">249</span> <span class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span class="n">go</span> <span class="mi">280</span> <span class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span class="n">python</span> <span class="mi">208</span> <span class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span class="n">ruby</span> <span class="mi">342</span> <span class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span class="n">java</span> <span class="mi">595</span> <span class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span class="n">haskell</span> <span class="mi">924</span> <span class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span class="n">go</span> <span class="mi">836</span> <span class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal" href="../../generated/datafusion.DataFrame.html#datafusion.DataFrame.describe" title="datafusion.DataFrame.describe"><code class="xref py py-meth docutils literal notranslate"><span class="pre">DataFrame.describe()</span></code></a> shows a quick statistic summary of your data:</p>
@@ -446,11 +451,11 @@ passing them to an Arrow table, and then converting them to a pandas DataFrame.<
<span class="o">+------------+--------------------+-------+--------------------+--------+</span>
<span class="o">|</span> <span class="n">count</span> <span class="o">|</span> <span class="mf">5.0</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span class="mf">5.0</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">null_count</span> <span class="o">|</span> <span class="mf">5.0</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span class="mf">5.0</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">mean</span> <span class="o">|</span> <span class="mf">3.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span class="mf">460.6</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">std</span> <span class="o">|</span> <span class="mf">1.5811388300841898</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span class="mf">387.18509785372675</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span>
-<span class="o">|</span> <span class="nb">min</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span class="mf">31.0</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
-<span class="o">|</span> <span class="nb">max</span> <span class="o">|</span> <span class="mf">5.0</span> <span class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span class="mf">875.0</span> <span class="o">|</span> <span class="n">C</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">median</span> <span class="o">|</span> <span class="mf">3.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span class="mf">280.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">mean</span> <span class="o">|</span> <span class="mf">3.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span class="mf">581.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">std</span> <span class="o">|</span> <span class="mf">1.5811388300841898</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span class="mf">307.86360616350873</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="nb">min</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span class="mf">208.0</span> <span class="o">|</span> <span class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="nb">max</span> <span class="o">|</span> <span class="mf">5.0</span> <span class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span class="mf">924.0</span> <span class="o">|</span> <span class="n">C</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">median</span> <span class="o">|</span> <span class="mf">3.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span class="mf">595.0</span> <span class="o">|</span> <span class="n">null</span> <span class="o">|</span>
<span class="o">+------------+--------------------+-------+--------------------+--------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/select-and-filter.html b/user-guide/common-operations/expressions.html
similarity index 52%
copy from user-guide/common-operations/select-and-filter.html
copy to user-guide/common-operations/expressions.html
index 19f2e34..955ec42 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/expressions.html
@@ -5,7 +5,7 @@
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
- <title>Column Selections — Apache Arrow DataFusion documentation</title>
+ <title>Expressions — Apache Arrow DataFusion documentation</title>
<link href="../../_static/styles/theme.css?digest=1999514e3f237ded88cf" rel="stylesheet">
<link href="../../_static/styles/pydata-sphinx-theme.css?digest=1999514e3f237ded88cf" rel="stylesheet">
@@ -34,7 +34,7 @@
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
<link rel="next" title="Joins" href="joins.html" />
- <link rel="prev" title="Basic Operations" href="basic-info.html" />
+ <link rel="prev" title="Column Selections" href="select-and-filter.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -131,9 +131,14 @@
Basic Operations
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="select-and-filter.html">
+ Column Selections
+ </a>
+ </li>
<li class="toctree-l2 current active">
<a class="current reference internal" href="#">
- Column Selections
+ Expressions
</a>
</li>
<li class="toctree-l2">
@@ -344,9 +349,34 @@
<div class="toc-item">
+<div class="tocsection onthispage pt-5 pb-3">
+ <i class="fas fa-list"></i> On this page
+</div>
<nav id="bd-toc-nav">
-
+ <ul class="visible nav section-nav flex-column">
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#column">
+ Column
+ </a>
+ </li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#literal">
+ Literal
+ </a>
+ </li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#boolean">
+ Boolean
+ </a>
+ </li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#functions">
+ Functions
+ </a>
+ </li>
+</ul>
+
</nav>
</div>
@@ -354,7 +384,7 @@
<div class="tocsection editthispage">
- <a href="https://github.com/apache/arrow-datafusion-python/edit/main/docs/source/user-guide/common-operations/select-and-filter.rst">
+ <a href="https://github.com/apache/arrow-datafusion-python/edit/main/docs/source/user-guide/common-operations/expressions.rst">
<i class="fas fa-pencil-alt"></i> Edit this page
</a>
</div>
@@ -373,116 +403,91 @@
<div>
- <section id="column-selections">
-<h1>Column Selections<a class="headerlink" href="#column-selections" title="Link to this heading">¶</a></h1>
-<p>Use <a class="reference internal" href="../../generated/datafusion.DataFrame.html#datafusion.DataFrame.select_columns" title="datafusion.DataFrame.select_columns"><code class="xref py py-meth docutils literal notranslate"><span class="pre">DataFrame.select_columns()</span></code></a> for basic column selection.</p>
-<p>DataFusion can work with several file types, to start simple we can use a subset of the
-<a class="reference external" href="https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page">TLC Trip Record Data</a></p>
-<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">1</span><span class="p">]:</span> <span class="kn">import</span> <span class="nn">urllib.request</span>
+ <section id="expressions">
+<h1>Expressions<a class="headerlink" href="#expressions" title="Link to this heading">¶</a></h1>
+<p>In DataFusion an expression is an abstraction that represents a computation.
+Expressions are used as the primary inputs and ouputs for most functions within
+DataFusion. As such, expressions can be combined to create expression trees, a
+concept shared across most compilers and databases.</p>
+<section id="column">
+<h2>Column<a class="headerlink" href="#column" title="Link to this heading">¶</a></h2>
+<p>The first expression most new users will interact with is the Column, which is created by calling <code class="xref py py-func docutils literal notranslate"><span class="pre">col()</span></code>.
+This expression represents a column within a DataFrame. The function <code class="xref py py-func docutils literal notranslate"><span class="pre">col()</span></code> takes as in input a string
+and returns an expression as it’s output.</p>
+</section>
+<section id="literal">
+<h2>Literal<a class="headerlink" href="#literal" title="Link to this heading">¶</a></h2>
+<p>Literal expressions represent a single value. These are helpful in a wide range of operations where
+a specific, known value is of interest. You can create a literal expression using the function <code class="xref py py-func docutils literal notranslate"><span class="pre">lit()</span></code>.
+The type of the object passed to the <code class="xref py py-func docutils literal notranslate"><span class="pre">lit()</span></code> function will be used to convert it to a known data type.</p>
+<p>In the following example we create expressions for the column named <cite>color</cite> and the literal scalar string <cite>red</cite>.
+The resultant variable <cite>red_units</cite> is itself also an expression.</p>
+<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">1</span><span class="p">]:</span> <span class="n">red_units</span> <span class="o">=</span> <span class="n">col</span><span class="p">(</span><span class="s2">"color"</span><span class="p">)</span> <span class="o">==</span> <span class="n">lit</span><span class="p">(</span><span class="s2">"red"</span><span class="p">)</span>
+</pre></div>
+</div>
+</section>
+<section id="boolean">
+<h2>Boolean<a class="headerlink" href="#boolean" title="Link to this heading">¶</a></h2>
+<p>When combining expressions that evaluate to a boolean value, you can combine these expressions using boolean operators.
+It is important to note that in order to combine these expressions, you <em>must</em> use bitwise operators. See the following
+examples for the and, or, and not operations.</p>
+<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">2</span><span class="p">]:</span> <span class="n">red_or_green_units</span> <span class="o">=</span> <span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s2">"color"</span><span class="p">)</span> <span class="o">==</span> <span class="n">lit</span><span class="p">(</span><span class="s2">"r [...]
-<span class="n">In</span> <span class="p">[</span><span class="mi">2</span><span class="p">]:</span> <span class="kn">from</span> <span class="nn">datafusion</span> <span class="kn">import</span> <span class="n">SessionContext</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="n">heavy_red_units</span> <span class="o">=</span> <span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s2">"color"</span><span class="p">)</span> <span class="o">==</span> <span class="n">lit</span><span class="p">(</span><span class="s2">"red"</span><span class="p">))</span> <span class="o">&</span> <span class="p">( [...]
-<span class="n">In</span> <span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="n">urllib</span><span class="o">.</span><span class="n">request</span><span class="o">.</span><span class="n">urlretrieve</span><span class="p">(</span><span class="s2">"https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet"</span><span class="p">,</span>
- <span class="o">...</span><span class="p">:</span> <span class="s2">"yellow_trip_data.parquet"</span><span class="p">)</span>
- <span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f9a88f1cb90</span><span class="o">></span><span class="p">)</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">4</span><span class="p">]:</span> <span class="n">not_red_units</span> <span class="o">=</span> <span class="o">~</span><span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s2">"color"</span><span class="p">)</span> <span class="o">==</span> <span class="n">lit</span><span class="p">(</span><span class="s2">"red"</span><span class="p">))</span>
+</pre></div>
+</div>
+</section>
+<section id="functions">
+<h2>Functions<a class="headerlink" href="#functions" title="Link to this heading">¶</a></h2>
+<p>As mentioned before, most functions in DataFusion return an expression at their output. This allows us to create
+a wide variety of expressions built up from other expressions. For example, <a class="reference internal" href="../../generated/datafusion.functions.functions.html#datafusion.functions.functions.alias" title="datafusion.functions.functions.alias"><code class="xref py py-func docutils literal notranslate"><span class="pre">alias()</span></code></a> is a function that takes
+as it input a single expression and returns an expression in which the name of the expression has changed.</p>
+<p>The following example shows a series of expressions that are built up from functions operating on expressions.</p>
+<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">5</span><span class="p">]:</span> <span class="kn">from</span> <span class="nn">datafusion</span> <span class="kn">import</span> <span class="n">SessionContext</span>
-<span class="n">In</span> <span class="p">[</span><span class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span class="o">=</span> <span class="n">SessionContext</span><span class="p">()</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">6</span><span class="p">]:</span> <span class="kn">from</span> <span class="nn">datafusion</span> <span class="kn">import</span> <span class="n">column</span><span class="p">,</span> <span class="n">lit</span>
-<span class="n">In</span> <span class="p">[</span><span class="mi">5</span><span class="p">]:</span> <span class="n">df</span> <span class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span class="n">read_parquet</span><span class="p">(</span><span class="s2">"yellow_trip_data.parquet"</span><span class="p">)</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">7</span><span class="p">]:</span> <span class="kn">from</span> <span class="nn">datafusion</span> <span class="kn">import</span> <span class="n">functions</span> <span class="k">as</span> <span class="n">f</span>
-<span class="n">In</span> <span class="p">[</span><span class="mi">6</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">select_columns</span><span class="p">(</span><span class="s2">"trip_distance"</span><span class="p">,</span> <span class="s2">"passenger_count"</span><span class="p">)</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">6</span><span class="p">]:</span>
-<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+---------------+-----------------+</span>
-<span class="o">|</span> <span class="n">trip_distance</span> <span class="o">|</span> <span class="n">passenger_count</span> <span class="o">|</span>
-<span class="o">+---------------+-----------------+</span>
-<span class="o">|</span> <span class="mf">2.1</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">0.2</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">14.7</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">10.6</span> <span class="o">|</span> <span class="mf">0.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">4.94</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">1.6</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">4.1</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">5.7</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">9.1</span> <span class="o">|</span> <span class="mf">1.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">2.7</span> <span class="o">|</span> <span class="mf">2.0</span> <span class="o">|</span>
-<span class="o">+---------------+-----------------+</span>
-</pre></div>
-</div>
-<p>For mathematical or logical operations use <a class="reference internal" href="../../generated/datafusion.functions.functions.html#datafusion.functions.functions.col" title="datafusion.functions.functions.col"><code class="xref py py-func docutils literal notranslate"><span class="pre">col()</span></code></a> to select columns, and give meaningful names to the resulting
-operations using <a class="reference internal" href="../../generated/datafusion.functions.functions.html#datafusion.functions.functions.alias" title="datafusion.functions.functions.alias"><code class="xref py py-func docutils literal notranslate"><span class="pre">alias()</span></code></a></p>
-<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">7</span><span class="p">]:</span> <span class="kn">from</span> <span class="nn">datafusion</span> <span class="kn">import</span> <span class="n">col</span><span class="p">,</span> <span class="n">lit</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span class="kn">import</span> <span class="nn">random</span>
-<span class="n">In</span> <span class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">select</span><span class="p">((</span><span class="n">col</span><span class="p">(</span><span class="s2">"tip_amount"</span><span class="p">)</span> <span class="o">+</span> <span class="n">col</span><span class="p">(</span><span class="s2">"tolls_amount"</span><span class="p">))</span><span class="o">.</ [...]
-<span class="n">Out</span><span class="p">[</span><span class="mi">8</span><span class="p">]:</span>
-<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+-----------------+</span>
-<span class="o">|</span> <span class="n">tips_plus_tolls</span> <span class="o">|</span>
-<span class="o">+-----------------+</span>
-<span class="o">|</span> <span class="mf">0.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">0.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">8.65</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">6.05</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">4.06</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">2.35</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">0.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">0.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">0.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mf">3.15</span> <span class="o">|</span>
-<span class="o">+-----------------+</span>
-</pre></div>
-</div>
-<div class="admonition warning">
-<p class="admonition-title">Warning</p>
-<p>Please be aware that all identifiers are effectively made lower-case in SQL, so if your file has capital letters
-(ex: Name) you must put your column name in double quotes or the selection won’t work. As an alternative for simple
-column selection use <a class="reference internal" href="../../generated/datafusion.DataFrame.html#datafusion.DataFrame.select_columns" title="datafusion.DataFrame.select_columns"><code class="xref py py-meth docutils literal notranslate"><span class="pre">DataFrame.select_columns()</span></code></a> without double quotes</p>
-</div>
-<p>For selecting columns with capital letters use <code class="docutils literal notranslate"><span class="pre">'"VendorID"'</span></code></p>
-<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">9</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">select</span><span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s1">'"VendorID"'</span><span class="p">))</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">9</span><span class="p">]:</span>
-<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+----------+</span>
-<span class="o">|</span> <span class="n">VendorID</span> <span class="o">|</span>
-<span class="o">+----------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">+----------+</span>
-</pre></div>
-</div>
-<p>To combine it with literal values use the <code class="xref py py-func docutils literal notranslate"><span class="pre">lit()</span></code></p>
-<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">10</span><span class="p">]:</span> <span class="n">large_trip_distance</span> <span class="o">=</span> <span class="n">col</span><span class="p">(</span><span class="s2">"trip_distance"</span><span class="p">)</span> <span class="o">></span> <span class="n">lit</span><span class="p">(</span><span class="mf">5.0</span><span cla [...]
+<span class="n">In</span> <span class="p">[</span><span class="mi">9</span><span class="p">]:</span> <span class="n">ctx</span> <span class="o">=</span> <span class="n">SessionContext</span><span class="p">()</span>
+
+<span class="n">In</span> <span class="p">[</span><span class="mi">10</span><span class="p">]:</span> <span class="n">df</span> <span class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span class="n">from_pydict</span><span class="p">(</span>
+ <span class="o">....</span><span class="p">:</span> <span class="p">{</span>
+ <span class="o">....</span><span class="p">:</span> <span class="s2">"name"</span><span class="p">:</span> <span class="p">[</span><span class="s2">"Albert"</span><span class="p">,</span> <span class="s2">"Becca"</span><span class="p">,</span> <span class="s2">"Carlos"</span><span class="p">,</span> <span class="s2">"Dante"</span><span class="p">],</span>
+ <span class="o">....</span><span class="p">:</span> <span class="s2">"age"</span><span class="p">:</span> <span class="p">[</span><span class="mi">42</span><span class="p">,</span> <span class="mi">67</span><span class="p">,</span> <span class="mi">27</span><span class="p">,</span> <span class="mi">71</span><span class="p">],</span>
+ <span class="o">....</span><span class="p">:</span> <span class="s2">"years_in_position"</span><span class="p">:</span> <span class="p">[</span><span class="mi">13</span><span class="p">,</span> <span class="mi">21</span><span class="p">,</span> <span class="mi">10</span><span class="p">,</span> <span class="mi">54</span><span class="p">],</span>
+ <span class="o">....</span><span class="p">:</span> <span class="p">},</span>
+ <span class="o">....</span><span class="p">:</span> <span class="n">name</span><span class="o">=</span><span class="s2">"employees"</span>
+ <span class="o">....</span><span class="p">:</span> <span class="p">)</span>
+ <span class="o">....</span><span class="p">:</span>
+
+<span class="n">In</span> <span class="p">[</span><span class="mi">11</span><span class="p">]:</span> <span class="n">age_col</span> <span class="o">=</span> <span class="n">col</span><span class="p">(</span><span class="s2">"age"</span><span class="p">)</span>
-<span class="n">In</span> <span class="p">[</span><span class="mi">11</span><span class="p">]:</span> <span class="n">low_passenger_count</span> <span class="o">=</span> <span class="n">col</span><span class="p">(</span><span class="s2">"passenger_count"</span><span class="p">)</span> <span class="o"><</span> <span class="n">lit</span><span class="p">(</span><span class="mi">4</span><span class="p">)</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">12</span><span class="p">]:</span> <span class="n">renamed_age</span> <span class="o">=</span> <span class="n">age_col</span><span class="o">.</span><span class="n">alias</span><span class="p">(</span><span class="s2">"age_in_years"</span><span class="p">)</span>
-<span class="n">In</span> <span class="p">[</span><span class="mi">12</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">select</span><span class="p">((</span><span class="n">large_trip_distance</span> <span class="o">&</span> <span class="n">low_passenger_count</span><span class="p">)</span><span class="o">.</span><span class="n">alias</span><span class="p">(</span><span class="s2">"lonely_trips"</span><span class="p">))</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">12</span><span class="p">]:</span>
+<span class="n">In</span> <span class="p">[</span><span class="mi">13</span><span class="p">]:</span> <span class="n">start_age</span> <span class="o">=</span> <span class="n">age_col</span> <span class="o">-</span> <span class="n">col</span><span class="p">(</span><span class="s2">"years_in_position"</span><span class="p">)</span>
+
+<span class="n">In</span> <span class="p">[</span><span class="mi">14</span><span class="p">]:</span> <span class="n">started_young</span> <span class="o">=</span> <span class="n">start_age</span> <span class="o"><</span> <span class="n">lit</span><span class="p">(</span><span class="mi">18</span><span class="p">)</span>
+
+<span class="n">In</span> <span class="p">[</span><span class="mi">15</span><span class="p">]:</span> <span class="n">can_retire</span> <span class="o">=</span> <span class="n">age_col</span> <span class="o">></span> <span class="n">lit</span><span class="p">(</span><span class="mi">65</span><span class="p">)</span>
+
+<span class="n">In</span> <span class="p">[</span><span class="mi">16</span><span class="p">]:</span> <span class="n">long_timer</span> <span class="o">=</span> <span class="n">started_young</span> <span class="o">&</span> <span class="n">can_retire</span>
+
+<span class="n">In</span> <span class="p">[</span><span class="mi">17</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">long_timer</span><span class="p">)</span><span class="o">.</span><span class="n">select</span><span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s2">"name"</span><span class="p">),</span> <span class="n">renamed_age</span><spa [...]
+<span class="n">Out</span><span class="p">[</span><span class="mi">17</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+--------------+</span>
-<span class="o">|</span> <span class="n">lonely_trips</span> <span class="o">|</span>
-<span class="o">+--------------+</span>
-<span class="o">|</span> <span class="n">false</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">false</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">true</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">true</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">false</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">false</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">false</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">true</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">true</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">false</span> <span class="o">|</span>
-<span class="o">+--------------+</span>
+<span class="o">+-------+--------------+-------------------+</span>
+<span class="o">|</span> <span class="n">name</span> <span class="o">|</span> <span class="n">age_in_years</span> <span class="o">|</span> <span class="n">years_in_position</span> <span class="o">|</span>
+<span class="o">+-------+--------------+-------------------+</span>
+<span class="o">|</span> <span class="n">Dante</span> <span class="o">|</span> <span class="mi">71</span> <span class="o">|</span> <span class="mi">54</span> <span class="o">|</span>
+<span class="o">+-------+--------------+-------------------+</span>
</pre></div>
</div>
+</section>
</section>
@@ -491,11 +496,11 @@ column selection use <a class="reference internal" href="../../generated/datafus
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="basic-info.html" title="previous page">
+ <a class='left-prev' id="prev-link" href="select-and-filter.html" title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">Basic Operations</p>
+ <p class="prev-next-title">Column Selections</p>
</div>
</a>
<a class='right-next' id="next-link" href="joins.html" title="next page">
diff --git a/user-guide/common-operations/functions.html b/user-guide/common-operations/functions.html
index b0dcb56..5fc85d6 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
@@ -417,7 +422,7 @@ In here we will cover some of the more popular use cases. If you want to view al
<span class="o">...</span><span class="p">:</span> <span class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'pokemon.csv'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f9a988c7e10</span><span class="o">></span><span class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'pokemon.csv'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f314c6aa150</span><span class="o">></span><span class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span class="o">=</span> <span class="n">SessionContext</span><span class="p">()</span>
@@ -491,16 +496,16 @@ In here we will cover some of the more popular use cases. If you want to view al
<span class="o">+--------------------------------+</span>
<span class="o">|</span> <span class="n">now</span><span class="p">()</span> <span class="o">|</span>
<span class="o">+--------------------------------+</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">01</span><span class="n">T20</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mf">28.094992690</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span class="o">-</span><span class="mi">05</span><span class="o">-</span><span class="mi">11</span><span class="n">T18</span><span class="p">:</span><span class="mi">35</span><span class="p">:</span><span class="mf">40.367508275</span><span class="n">Z</span> <span class="o">|</span>
<span class="o">+--------------------------------+</span>
</pre></div>
</div>
@@ -553,28 +558,27 @@ DataFusion offers a range of helpful options.</p>
<span class="o">+-----+---------------------------+------+</span>
</pre></div>
</div>
-<p>This also includes the functions for regular expressions <a class="reference internal" href="../../generated/datafusion.functions.functions.html#datafusion.functions.functions.regexp_replace" title="datafusion.functions.functions.regexp_replace"><code class="xref py py-func docutils literal notranslate"><span class="pre">regexp_replace()</span></code></a> and <a class="reference internal" href="../../generated/datafusion.functions.functions.html#datafusion.functions.functions.regexp_m [...]
+<p>This also includes the functions for regular expressions like <a class="reference internal" href="../../generated/datafusion.functions.functions.html#datafusion.functions.functions.regexp_match" title="datafusion.functions.functions.regexp_match"><code class="xref py py-func docutils literal notranslate"><span class="pre">regexp_match()</span></code></a></p>
<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">14</span><span class="p">]:</span> <span class="n">df</span><span class="o">.</span><span class="n">select</span><span class="p">(</span>
<span class="o">....</span><span class="p">:</span> <span class="n">f</span><span class="o">.</span><span class="n">regexp_match</span><span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s1">'"Name"'</span><span class="p">),</span> <span class="n">literal</span><span class="p">(</span><span class="s2">"Char"</span><span class="p">))</span><span class="o">.</span><span class="n">alias</span><span class="p">(</span><span [...]
- <span class="o">....</span><span class="p">:</span> <span class="n">f</span><span class="o">.</span><span class="n">regexp_replace</span><span class="p">(</span><span class="n">col</span><span class="p">(</span><span class="s1">'"Name"'</span><span class="p">),</span> <span class="n">literal</span><span class="p">(</span><span class="s2">"saur"</span><span class="p">),</span> <span class="n">literal</span><span class="p">(</span><span class="s2">"f [...]
<span class="o">....</span><span class="p">:</span> <span class="p">)</span>
<span class="o">....</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span class="mi">14</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+---------+---------------------------+</span>
-<span class="o">|</span> <span class="n">dragons</span> <span class="o">|</span> <span class="n">flowers</span> <span class="o">|</span>
-<span class="o">+---------+---------------------------+</span>
-<span class="o">|</span> <span class="o">|</span> <span class="n">Bulbafleur</span> <span class="o">|</span>
-<span class="o">|</span> <span class="o">|</span> <span class="n">Ivyfleur</span> <span class="o">|</span>
-<span class="o">|</span> <span class="o">|</span> <span class="n">Venufleur</span> <span class="o">|</span>
-<span class="o">|</span> <span class="o">|</span> <span class="n">VenufleurMega</span> <span class="n">Venusaur</span> <span class="o">|</span>
-<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span> <span class="n">Charmander</span> <span class="o">|</span>
-<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span> <span class="n">Charmeleon</span> <span class="o">|</span>
-<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span> <span class="n">Charizard</span> <span class="o">|</span>
-<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span> <span class="n">CharizardMega</span> <span class="n">Charizard</span> <span class="n">X</span> <span class="o">|</span>
-<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span> <span class="n">CharizardMega</span> <span class="n">Charizard</span> <span class="n">Y</span> <span class="o">|</span>
-<span class="o">|</span> <span class="o">|</span> <span class="n">Squirtle</span> <span class="o">|</span>
-<span class="o">+---------+---------------------------+</span>
+<span class="o">+---------+</span>
+<span class="o">|</span> <span class="n">dragons</span> <span class="o">|</span>
+<span class="o">+---------+</span>
+<span class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="p">[</span><span class="n">Char</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span>
+<span class="o">+---------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/index.html b/user-guide/common-operations/index.html
index e46b876..96a21e6 100644
--- a/user-guide/common-operations/index.html
+++ b/user-guide/common-operations/index.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
@@ -379,6 +384,13 @@
<ul>
<li class="toctree-l1"><a class="reference internal" href="basic-info.html">Basic Operations</a></li>
<li class="toctree-l1"><a class="reference internal" href="select-and-filter.html">Column Selections</a></li>
+<li class="toctree-l1"><a class="reference internal" href="expressions.html">Expressions</a><ul>
+<li class="toctree-l2"><a class="reference internal" href="expressions.html#column">Column</a></li>
+<li class="toctree-l2"><a class="reference internal" href="expressions.html#literal">Literal</a></li>
+<li class="toctree-l2"><a class="reference internal" href="expressions.html#boolean">Boolean</a></li>
+<li class="toctree-l2"><a class="reference internal" href="expressions.html#functions">Functions</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal" href="joins.html">Joins</a><ul>
<li class="toctree-l2"><a class="reference internal" href="joins.html#inner-join">Inner Join</a></li>
<li class="toctree-l2"><a class="reference internal" href="joins.html#left-join">Left Join</a></li>
diff --git a/user-guide/common-operations/joins.html b/user-guide/common-operations/joins.html
index 601f54c..95500b5 100644
--- a/user-guide/common-operations/joins.html
+++ b/user-guide/common-operations/joins.html
@@ -34,7 +34,7 @@
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
<link rel="next" title="Functions" href="functions.html" />
- <link rel="prev" title="Column Selections" href="select-and-filter.html" />
+ <link rel="prev" title="Expressions" href="expressions.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2 current active">
<a class="current reference internal" href="#">
Joins
@@ -482,9 +487,9 @@ is no match. Unmatched rows will have null values.</p>
<span class="o">|</span> <span class="n">customer_id</span> <span class="o">|</span> <span class="n">customer</span> <span class="o">|</span> <span class="nb">id</span> <span class="o">|</span> <span class="n">name</span> <span class="o">|</span>
<span class="o">+-------------+----------+----+-----------+</span>
<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> <span class="n">Alice</span> <span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> <span class="n">CityCabs</span> <span class="o">|</span>
-<span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span class="n">UrbanGo</span> <span class="o">|</span>
<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span> <span class="n">Bob</span> <span class="o">|</span> <span class="mi">2</span> <span class="o">|</span> <span class="n">MetroRide</span> <span class="o">|</span>
<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span> <span class="n">Charlie</span> <span class="o">|</span> <span class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span class="n">UrbanGo</span> <span class="o">|</span>
<span class="o">+-------------+----------+----+-----------+</span>
</pre></div>
</div>
@@ -529,11 +534,11 @@ the right table.</p>
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="select-and-filter.html" title="previous page">
+ <a class='left-prev' id="prev-link" href="expressions.html" title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">Column Selections</p>
+ <p class="prev-next-title">Expressions</p>
</div>
</a>
<a class='right-next' id="next-link" href="functions.html" title="next page">
diff --git a/user-guide/common-operations/select-and-filter.html b/user-guide/common-operations/select-and-filter.html
index 19f2e34..b7c24bd 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/select-and-filter.html
@@ -33,7 +33,7 @@
<script src="../../_static/sphinx_highlight.js?v=dc90522c"></script>
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="Joins" href="joins.html" />
+ <link rel="next" title="Expressions" href="expressions.html" />
<link rel="prev" title="Basic Operations" href="basic-info.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
@@ -385,7 +390,7 @@
<span class="n">In</span> <span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="n">urllib</span><span class="o">.</span><span class="n">request</span><span class="o">.</span><span class="n">urlretrieve</span><span class="p">(</span><span class="s2">"https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="s2">"yellow_trip_data.parquet"</span><span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f9a88f1cb90</span><span class="o">></span><span class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f314c6c3ed0</span><span class="o">></span><span class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span class="o">=</span> <span class="n">SessionContext</span><span class="p">()</span>
@@ -498,10 +503,10 @@ column selection use <a class="reference internal" href="../../generated/datafus
<p class="prev-next-title">Basic Operations</p>
</div>
</a>
- <a class='right-next' id="next-link" href="joins.html" title="next page">
+ <a class='right-next' id="next-link" href="expressions.html" title="next page">
<div class="prev-next-info">
<p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">Joins</p>
+ <p class="prev-next-title">Expressions</p>
</div>
<i class="fas fa-angle-right"></i>
</a>
diff --git a/user-guide/common-operations/udf-and-udfa.html b/user-guide/common-operations/udf-and-udfa.html
index 72558de..f1950c6 100644
--- a/user-guide/common-operations/udf-and-udfa.html
+++ b/user-guide/common-operations/udf-and-udfa.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
diff --git a/user-guide/common-operations/windows.html b/user-guide/common-operations/windows.html
index eeaaf6f..b9b9f55 100644
--- a/user-guide/common-operations/windows.html
+++ b/user-guide/common-operations/windows.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="joins.html">
Joins
@@ -392,7 +397,7 @@ produce a result for each individual row, unlike an aggregate function that prov
<span class="o">...</span><span class="p">:</span> <span class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'pokemon.csv'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f9a88f4cc50</span><span class="o">></span><span class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span class="s1">'pokemon.csv'</span><span class="p">,</span> <span class="o"><</span><span class="n">http</span><span class="o">.</span><span class="n">client</span><span class="o">.</span><span class="n">HTTPMessage</span> <span class="n">at</span> <span class="mh">0x7f313cd9cf50</span><span class="o">></span><span class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span class="mi">6</span><span class="p">]:</span> <span class="n">ctx</span> <span class="o">=</span> <span class="n">SessionContext</span><span class="p">()</span>
@@ -448,16 +453,16 @@ a list of <a class="reference internal" href="../../generated/datafusion.functio
<span class="o">+------------+--------+------+</span>
<span class="o">|</span> <span class="n">Name</span> <span class="o">|</span> <span class="n">Attack</span> <span class="o">|</span> <span class="n">rank</span> <span class="o">|</span>
<span class="o">+------------+--------+------+</span>
-<span class="o">|</span> <span class="n">Exeggcute</span> <span class="o">|</span> <span class="mi">40</span> <span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bulbasaur</span> <span class="o">|</span> <span class="mi">49</span> <span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Oddish</span> <span class="o">|</span> <span class="mi">50</span> <span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Tangela</span> <span class="o">|</span> <span class="mi">55</span> <span class="o">|</span> <span class="mi">4</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ivysaur</span> <span class="o">|</span> <span class="mi">62</span> <span class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Gloom</span> <span class="o">|</span> <span class="mi">65</span> <span class="o">|</span> <span class="mi">6</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bellsprout</span> <span class="o">|</span> <span class="mi">75</span> <span class="o">|</span> <span class="mi">7</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Vileplume</span> <span class="o">|</span> <span class="mi">80</span> <span class="o">|</span> <span class="mi">8</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Venusaur</span> <span class="o">|</span> <span class="mi">82</span> <span class="o">|</span> <span class="mi">9</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Weepinbell</span> <span class="o">|</span> <span class="mi">90</span> <span class="o">|</span> <span class="mi">10</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Dratini</span> <span class="o">|</span> <span class="mi">64</span> <span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Dragonair</span> <span class="o">|</span> <span class="mi">84</span> <span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Dragonite</span> <span class="o">|</span> <span class="mi">134</span> <span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Clefairy</span> <span class="o">|</span> <span class="mi">45</span> <span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Clefable</span> <span class="o">|</span> <span class="mi">70</span> <span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Mankey</span> <span class="o">|</span> <span class="mi">80</span> <span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Machop</span> <span class="o">|</span> <span class="mi">80</span> <span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Machoke</span> <span class="o">|</span> <span class="mi">100</span> <span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Primeape</span> <span class="o">|</span> <span class="mi">105</span> <span class="o">|</span> <span class="mi">4</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Hitmonchan</span> <span class="o">|</span> <span class="mi">105</span> <span class="o">|</span> <span class="mi">4</span> <span class="o">|</span>
<span class="o">+------------+--------+------+</span>
</pre></div>
</div>
diff --git a/user-guide/configuration.html b/user-guide/configuration.html
index e19aaf5..0673231 100644
--- a/user-guide/configuration.html
+++ b/user-guide/configuration.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="common-operations/joins.html">
Joins
@@ -402,7 +407,7 @@ a <code class="code docutils literal notranslate"><span class="pre">SessionConfi
</pre></div>
</div>
<p>You can read more about available <code class="code docutils literal notranslate"><span class="pre">SessionConfig</span></code> options <a class="reference external" href="https://arrow.apache.org/datafusion/user-guide/configs.html">here</a>,
-and about <code class="code docutils literal notranslate"><span class="pre">RuntimeConfig</span></code> options <a href="#id1"><span class="problematic" id="id2">`here https://docs.rs/datafusion/latest/datafusion/execution/runtime_env/struct.RuntimeConfig.html`_</span></a>.</p>
+and about <code class="code docutils literal notranslate"><span class="pre">RuntimeConfig</span></code> options <a class="reference external" href="https://docs.rs/datafusion/latest/datafusion/execution/runtime_env/struct.RuntimeConfig.html">here</a>.</p>
</section>
diff --git a/user-guide/introduction.html b/user-guide/introduction.html
index 67fbcb1..6185f78 100644
--- a/user-guide/introduction.html
+++ b/user-guide/introduction.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="common-operations/joins.html">
Joins
@@ -397,7 +402,7 @@ DataFusion through various examples and highlight the most effective ways of usi
<div class="highlight-ipython notranslate"><div class="highlight"><pre><span></span><span class="n">In</span> <span class="p">[</span><span class="mi">1</span><span class="p">]:</span> <span class="kn">import</span> <span class="nn">datafusion</span>
<span class="n">In</span> <span class="p">[</span><span class="mi">2</span><span class="p">]:</span> <span class="n">datafusion</span><span class="o">.</span><span class="n">__version__</span>
-<span class="n">Out</span><span class="p">[</span><span class="mi">2</span><span class="p">]:</span> <span class="s1">'36.0.0'</span>
+<span class="n">Out</span><span class="p">[</span><span class="mi">2</span><span class="p">]:</span> <span class="s1">'37.1.0'</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/io/avro.html b/user-guide/io/avro.html
index 7264dbc..cf3186f 100644
--- a/user-guide/io/avro.html
+++ b/user-guide/io/avro.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../common-operations/joins.html">
Joins
diff --git a/user-guide/io/csv.html b/user-guide/io/csv.html
index 22581ac..c716865 100644
--- a/user-guide/io/csv.html
+++ b/user-guide/io/csv.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../common-operations/joins.html">
Joins
diff --git a/user-guide/io/index.html b/user-guide/io/index.html
index a7e8303..0fc0c83 100644
--- a/user-guide/io/index.html
+++ b/user-guide/io/index.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../common-operations/joins.html">
Joins
diff --git a/user-guide/io/json.html b/user-guide/io/json.html
index 1601641..19d4d38 100644
--- a/user-guide/io/json.html
+++ b/user-guide/io/json.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../common-operations/joins.html">
Joins
diff --git a/user-guide/io/parquet.html b/user-guide/io/parquet.html
index 53f0c00..e74078b 100644
--- a/user-guide/io/parquet.html
+++ b/user-guide/io/parquet.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../common-operations/joins.html">
Joins
diff --git a/user-guide/sql.html b/user-guide/sql.html
index 235e9e5..d15cf79 100644
--- a/user-guide/sql.html
+++ b/user-guide/sql.html
@@ -136,6 +136,11 @@
Column Selections
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="common-operations/expressions.html">
+ Expressions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="common-operations/joins.html">
Joins
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org