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 0b1ec6fd Publish built docs triggered by
89751b552e8c5388e9cc994acadf1de5b896422f
0b1ec6fd is described below
commit 0b1ec6fd4ccab0598d3fec83a18eacfb02ecfeda
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Mar 17 06:50:11 2026 +0000
Publish built docs triggered by 89751b552e8c5388e9cc994acadf1de5b896422f
---
.../autoapi/datafusion/functions/index.rst.txt | 258 +++++++++++++++++---
autoapi/datafusion/functions/index.html | 264 +++++++++++++++++----
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 36 +--
user-guide/common-operations/basic-info.html | 34 +--
user-guide/common-operations/functions.html | 20 +-
6 files changed, 480 insertions(+), 134 deletions(-)
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index a02fee8f..a95aa5f5 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -287,8 +287,8 @@ Module Contents
Returns the arc cosine or inverse cosine of a number.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [1.0]})
>>> result = df.select(dfn.functions.acos(dfn.col("a")).alias("acos"))
@@ -300,8 +300,8 @@ Module Contents
Returns inverse hyperbolic cosine.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [1.0]})
>>> result = df.select(dfn.functions.acosh(dfn.col("a")).alias("acosh"))
@@ -631,11 +631,30 @@ Module Contents
Casts an expression to a specified data type.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1]})
+ >>> data_type = dfn.string_literal("Float64")
+ >>> result = df.select(
+ ... dfn.functions.arrow_cast(dfn.col("a"), data_type).alias("c")
+ ... )
+ >>> result.collect_column("c")[0].as_py()
+ 1.0
+
.. py:function:: arrow_typeof(arg: datafusion.expr.Expr) ->
datafusion.expr.Expr
Returns the Arrow type of the expression.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1]})
+ >>> result = df.select(dfn.functions.arrow_typeof(dfn.col("a")).alias("t"))
+ >>> result.collect_column("t")[0].as_py()
+ 'Int64'
+
.. py:function:: ascii(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -646,8 +665,8 @@ Module Contents
Returns the arc sine or inverse sine of a number.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.asin(dfn.col("a")).alias("asin"))
@@ -659,8 +678,8 @@ Module Contents
Returns inverse hyperbolic sine.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.asinh(dfn.col("a")).alias("asinh"))
@@ -672,8 +691,8 @@ Module Contents
Returns inverse tangent of a number.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.atan(dfn.col("a")).alias("atan"))
@@ -685,8 +704,8 @@ Module Contents
Returns inverse tangent of a division given in the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"y": [0.0], "x": [1.0]})
>>> result = df.select(
@@ -699,8 +718,8 @@ Module Contents
Returns inverse hyperbolic tangent.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.atanh(dfn.col("a")).alias("atanh"))
@@ -842,6 +861,15 @@ Module Contents
Returns the value of the first expr in ``args`` which is not NULL.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [None, 1], "b": [2, 3]})
+ >>> result = df.select(
+ ... dfn.functions.coalesce(dfn.col("a"), dfn.col("b")).alias("c"))
+ >>> result.collect_column("c")[0].as_py()
+ 2
+
.. py:function:: col(name: str) -> datafusion.expr.Expr
@@ -880,8 +908,8 @@ Module Contents
Returns the cosine of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0,-1,1]})
>>> cos_df = df.select(dfn.functions.cos(dfn.col("a")).alias("cos"))
@@ -893,8 +921,8 @@ Module Contents
Returns the hyperbolic cosine of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0,-1,1]})
>>> cosh_df = df.select(dfn.functions.cosh(dfn.col("a")).alias("cosh"))
@@ -906,8 +934,8 @@ Module Contents
Returns the cotangent of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> from math import pi
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [pi / 4]})
@@ -1057,8 +1085,8 @@ Module Contents
Converts the argument from radians to degrees.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> from math import pi
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0,pi,2*pi]})
@@ -1600,6 +1628,14 @@ Module Contents
Computes an MD5 128-bit checksum for a string expression.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello"]})
+ >>> result = df.select(dfn.functions.md5(dfn.col("a")).alias("md5"))
+ >>> result.collect_column("md5")[0].as_py()
+ '5d41402abc4b2a76b9719d911017c592'
+
.. py:function:: mean(expression: datafusion.expr.Expr, filter:
datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
@@ -1638,6 +1674,18 @@ Module Contents
Returns a struct with the given names and arguments pairs.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1]})
+ >>> result = df.select(
+ ... dfn.functions.named_struct(
+ ... [("x", dfn.lit(10)), ("y", dfn.lit(20))]
+ ... ).alias("s")
+ ... )
+ >>> result.collect_column("s")[0].as_py() == {"x": 10, "y": 20}
+ True
+
.. py:function:: nanvl(x: datafusion.expr.Expr, y: datafusion.expr.Expr) ->
datafusion.expr.Expr
@@ -1713,6 +1761,18 @@ Module Contents
Returns ``x`` if ``x`` is not ``NULL``. Otherwise returns ``y``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [None, 1], "b": [0, 0]})
+ >>> nvl_df = df.select(
+ ... dfn.functions.nvl(dfn.col("a"), dfn.col("b")).alias("nvl")
+ ... )
+ >>> nvl_df.collect_column("nvl")[0].as_py()
+ 0
+ >>> nvl_df.collect_column("nvl")[1].as_py()
+ 1
+
.. py:function:: octet_length(arg: datafusion.expr.Expr) ->
datafusion.expr.Expr
@@ -1780,8 +1840,8 @@ Module Contents
Converts the argument from degrees to radians.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> from math import pi
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [180.0]})
@@ -1843,15 +1903,38 @@ Module Contents
Optional start position (the first position is 1) to search for the regular
expression.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["abcabc"]})
+ >>> result = df.select(
+ ... dfn.functions.regexp_count(dfn.col("a"), dfn.lit("abc")).alias("c"))
+ >>> result.collect_column("c")[0].as_py()
+ 2
+
.. py:function:: regexp_instr(values: datafusion.expr.Expr, regex:
datafusion.expr.Expr, start: datafusion.expr.Expr | None = None, n:
datafusion.expr.Expr | None = None, flags: datafusion.expr.Expr | None = None,
sub_expr: datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
Returns the position of a regular expression match in a string.
- Searches ``values`` for the ``n``-th occurrence of ``regex``, starting at
position
- ``start`` (the first position is 1). Returns the starting or ending
position based
- on ``end_position``. Use ``flags`` to control regex behavior and
``sub_expr`` to
- return the position of a specific capture group instead of the entire match.
+ :param values: Data to search for the regular expression match.
+ :param regex: Regular expression to search for.
+ :param start: Optional position to start the search (the first position is
1).
+ :param n: Optional occurrence of the match to find (the first occurrence is
1).
+ :param flags: Optional regular expression flags to control regex behavior.
+ :param sub_expr: Optionally capture group position instead of the entire
match.
+
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello 42 world"]})
+ >>> result = df.select(
+ ... dfn.functions.regexp_instr(
+ ... dfn.col("a"), dfn.lit("\\d+")
+ ... ).alias("pos")
+ ... )
+ >>> result.collect_column("pos")[0].as_py()
+ 7
.. py:function:: regexp_like(string: datafusion.expr.Expr, regex:
datafusion.expr.Expr, flags: datafusion.expr.Expr | None = None) ->
datafusion.expr.Expr
@@ -1861,6 +1944,18 @@ Module Contents
Tests a string using a regular expression returning true if at least one
match,
false otherwise.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello123"]})
+ >>> result = df.select(
+ ... dfn.functions.regexp_like(
+ ... dfn.col("a"), dfn.lit("\\d+")
+ ... ).alias("m")
+ ... )
+ >>> result.collect_column("m")[0].as_py()
+ True
+
.. py:function:: regexp_match(string: datafusion.expr.Expr, regex:
datafusion.expr.Expr, flags: datafusion.expr.Expr | None = None) ->
datafusion.expr.Expr
@@ -1869,6 +1964,18 @@ Module Contents
Returns an array with each element containing the leftmost-first match of
the
corresponding index in ``regex`` to string in ``string``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello 42 world"]})
+ >>> result = df.select(
+ ... dfn.functions.regexp_match(
+ ... dfn.col("a"), dfn.lit("(\\d+)")
+ ... ).alias("m")
+ ... )
+ >>> result.collect_column("m")[0].as_py()
+ ['42']
+
.. py:function:: regexp_replace(string: datafusion.expr.Expr, pattern:
datafusion.expr.Expr, replacement: datafusion.expr.Expr, flags:
datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
@@ -1880,6 +1987,19 @@ Module Contents
Supported flags with the addition of 'g' can be found at
<https://docs.rs/regex/latest/regex/#grouping-and-flags>
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello 42"]})
+ >>> result = df.select(
+ ... dfn.functions.regexp_replace(
+ ... dfn.col("a"), dfn.lit("\\d+"),
+ ... dfn.lit("XX")
+ ... ).alias("r")
+ ... )
+ >>> result.collect_column("r")[0].as_py()
+ 'hello XX'
+
.. py:function:: regr_avgx(y: datafusion.expr.Expr, x: datafusion.expr.Expr,
filter: datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
@@ -2088,21 +2208,61 @@ Module Contents
Computes the SHA-224 hash of a binary string.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello"]})
+ >>> result = df.select(
+ ... dfn.functions.sha224(dfn.col("a")).alias("h")
+ ... )
+ >>> result.collect_column("h")[0].as_py().hex()
+ 'ea09ae9cc6768c50fcee903ed054556e5bfc8347907f12598aa24193'
+
.. py:function:: sha256(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
Computes the SHA-256 hash of a binary string.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello"]})
+ >>> result = df.select(
+ ... dfn.functions.sha256(dfn.col("a")).alias("h")
+ ... )
+ >>> result.collect_column("h")[0].as_py().hex()
+ '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824'
+
.. py:function:: sha384(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
Computes the SHA-384 hash of a binary string.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello"]})
+ >>> result = df.select(
+ ... dfn.functions.sha384(dfn.col("a")).alias("h")
+ ... )
+ >>> result.collect_column("h")[0].as_py().hex()
+ '59e1748777448c69de6b800d7a33bbfb9ff1b...
+
.. py:function:: sha512(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
Computes the SHA-512 hash of a binary string.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": ["hello"]})
+ >>> result = df.select(
+ ... dfn.functions.sha512(dfn.col("a")).alias("h")
+ ... )
+ >>> result.collect_column("h")[0].as_py().hex()
+ '9b71d224bd62f3785d96d46ad3ea3d73319bfb...
+
.. py:function:: signum(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2113,8 +2273,8 @@ Module Contents
Returns the sine of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.sin(dfn.col("a")).alias("sin"))
@@ -2126,8 +2286,8 @@ Module Contents
Returns the hyperbolic sine of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.sinh(dfn.col("a")).alias("sinh"))
@@ -2213,6 +2373,22 @@ Module Contents
Returns a struct with the given arguments.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1], "b": [2]})
+ >>> result = df.select(
+ ... dfn.functions.struct(
+ ... dfn.col("a"), dfn.col("b")
+ ... ).alias("s")
+ ... )
+
+ Children in the new struct will always be `c0`, ..., `cN-1`
+ for `N` children.
+
+ >>> result.collect_column("s")[0].as_py() == {"c0": 1, "c1": 2}
+ True
+
.. py:function:: substr(string: datafusion.expr.Expr, position:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2249,8 +2425,8 @@ Module Contents
Returns the tangent of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.tan(dfn.col("a")).alias("tan"))
@@ -2262,8 +2438,8 @@ Module Contents
Returns the hyperbolic tangent of the argument.
- Examples:
- ---------
+ .. rubric:: Examples
+
>>> ctx = dfn.SessionContext()
>>> df = ctx.from_pydict({"a": [0.0]})
>>> result = df.select(dfn.functions.tanh(dfn.col("a")).alias("tanh"))
@@ -2384,6 +2560,16 @@ Module Contents
Returns uuid v4 as a string value.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1]})
+ >>> result = df.select(
+ ... dfn.functions.uuid().alias("u")
+ ... )
+ >>> len(result.collect_column("u")[0].as_py()) == 36
+ True
+
.. py:function:: var(expression: datafusion.expr.Expr, filter:
datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index 94a0cc8f..c02ca01a 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -3455,8 +3455,7 @@
<dt class="sig sig-object py" id="datafusion.functions.acos">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the arc cosine or inverse cosine of a number.</p>
-<section id="examples">
-<h3>Examples:<a class="headerlink" href="#examples" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">acos</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
@@ -3464,15 +3463,13 @@
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.acosh">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">acosh</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.e [...]
<dd><p>Returns inverse hyperbolic cosine.</p>
-<section id="id1">
-<h3>Examples:<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">acosh</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
@@ -3480,7 +3477,6 @@
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -3861,12 +3857,31 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<dt class="sig sig-object py" id="datafusion.functions.arrow_cast">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">arrow_cast</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expr</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafu [...]
<dd><p>Casts an expression to a specified data type.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">data_type</span> <span
class="o">=</span> <span class="n">dfn</span><span class="o">.</span><span
class="n">string_literal</span><span class="p">(</span><span
class="s2">"Float64"</span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">arrow_cast</span><span class="p">(</span><span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"a"</span><span
class="p">),</span> <span class="n">data_type</span><span
class="p">)</span><span class="o">.</span><span class="n">alias</span><span
class="p">(</span><s [...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"c"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.arrow_typeof">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">dataf [...]
<dd><p>Returns the Arrow type of the expression.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">arrow_typeof</span><span class="p">(</span><span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"a"</s [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"t"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">'Int64'</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -3879,8 +3894,7 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<dt class="sig sig-object py" id="datafusion.functions.asin">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the arc sine or inverse sine of a number.</p>
-<section id="id2">
-<h3>Examples:<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">asin</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
@@ -3888,15 +3902,13 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.asinh">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">asinh</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.e [...]
<dd><p>Returns inverse hyperbolic sine.</p>
-<section id="id3">
-<h3>Examples:<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">asinh</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
@@ -3904,15 +3916,13 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.atan">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">atan</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns inverse tangent of a number.</p>
-<section id="id4">
-<h3>Examples:<a class="headerlink" href="#id4" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">atan</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
@@ -3920,15 +3930,13 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.atan2">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">atan2</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">y</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns inverse tangent of a division given in the argument.</p>
-<section id="id5">
-<h3>Examples:<a class="headerlink" href="#id5" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"y"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">],</span> <span
class="s2">"x"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
@@ -3937,15 +3945,13 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.atanh">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">atanh</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.e [...]
<dd><p>Returns inverse hyperbolic tangent.</p>
-<section id="id6">
-<h3>Examples:<a class="headerlink" href="#id6" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">atanh</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
@@ -3953,7 +3959,6 @@ be filled with the given <code class="docutils literal
notranslate"><span class=
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -4122,6 +4127,15 @@ detailed usage.</p>
<dt class="sig sig-object py" id="datafusion.functions.coalesce">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">coalesce</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><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title= [...]
<dd><p>Returns the value of the first expr in <code class="docutils literal
notranslate"><span class="pre">args</span></code> which is not NULL.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="kc">None</span><span class="p">,</span> <span
class="mi">1</span><span class="p">],</span> <span
class="s2">"b"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">2< [...]
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">coalesce</span><span class="p">(</span><span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"a"</span><span
class="p">),</span> <span class="n">dfn</span><span class="o">.</span><span
class="n">col</span><span class="p">(</span><span
class="s2">"b"</span [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"c"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">2</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4166,8 +4180,7 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dt class="sig sig-object py" id="datafusion.functions.cos">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">cos</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns the cosine of the argument.</p>
-<section id="id7">
-<h3>Examples:<a class="headerlink" href="#id7" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">0</span><span class="p">,</span><span
class="o">-</span><span class="mi">1</span><span class="p">,</span><span
class="mi">1</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">cos_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">cos</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
@@ -4175,15 +4188,13 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<span class="go">1.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.cosh">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">cosh</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the hyperbolic cosine of the argument.</p>
-<section id="id8">
-<h3>Examples:<a class="headerlink" href="#id8" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">0</span><span class="p">,</span><span
class="o">-</span><span class="mi">1</span><span class="p">,</span><span
class="mi">1</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">cosh_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">cosh</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
@@ -4191,15 +4202,13 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<span class="go">1.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.cot">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">cot</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns the cotangent of the argument.</p>
-<section id="id9">
-<h3>Examples:<a class="headerlink" href="#id9" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="kn">from</span><span class="w"> </span><span class="nn">math</span><span
class="w"> </span><span class="kn">import</span> <span class="n">pi</span>
<span class="gp">>>> </span><span class="n">ctx</span> <span
class="o">=</span> <span class="n">dfn</span><span class="o">.</span><span
class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="n">pi</span> <span class="o">/</span> <span
class="mi">4</span><span class="p">]})</span>
@@ -4213,7 +4222,6 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<span class="go">1.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -4378,8 +4386,7 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.degrees">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">degrees</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion [...]
<dd><p>Converts the argument from radians to degrees.</p>
-<section id="id10">
-<h3>Examples:<a class="headerlink" href="#id10" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="kn">from</span><span class="w"> </span><span class="nn">math</span><span
class="w"> </span><span class="kn">import</span> <span class="n">pi</span>
<span class="gp">>>> </span><span class="n">ctx</span> <span
class="o">=</span> <span class="n">dfn</span><span class="o">.</span><span
class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">0</span><span class="p">,</span><span
class="n">pi</span><span class="p">,</span><span class="mi">2</span><span
class="o">*</span><span class="n">pi</span><span class="p">]})</span>
@@ -4388,7 +4395,6 @@ column names or expressions.</p></li>
<span class="go">360.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -4974,6 +4980,14 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dt class="sig sig-object py" id="datafusion.functions.md5">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Computes an MD5 128-bit checksum for a string expression.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">md5</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"md5"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">'5d41402abc4b2a76b9719d911017c592'</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5022,6 +5036,18 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dt class="sig sig-object py" id="datafusion.functions.named_struct">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">named_struct</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">name_pairs</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><span
class="pre">tuple</span><span class="p [...]
<dd><p>Returns a struct with the given names and arguments pairs.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">named_struct</span><span class="p">(</span>
+<span class="gp">... </span> <span class="p">[(</span><span
class="s2">"x"</span><span class="p">,</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">lit</span><span
class="p">(</span><span class="mi">10</span><span class="p">)),</span> <span
class="p">(</span><span class="s2">"y"</span><span class="p">,</span>
<span class="n">dfn</span><span class="o">.</span><span
class="n">lit</span><span class="p">(</span><span class="mi">20</span><spa [...]
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"s"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"s"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span> <span
class="o">==</span> <span class="p">{</span><span
class="s2">"x"</span><span class="p">:</span> <span
class="mi">10</span><span class="p [...]
+<span class="go">True</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5109,6 +5135,18 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.nvl">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">nvl</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">x</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.expr. [...]
<dd><p>Returns <code class="docutils literal notranslate"><span
class="pre">x</span></code> if <code class="docutils literal notranslate"><span
class="pre">x</span></code> is not <code class="docutils literal
notranslate"><span class="pre">NULL</span></code>. Otherwise returns <code
class="docutils literal notranslate"><span class="pre">y</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="kc">None</span><span class="p">,</span> <span
class="mi">1</span><span class="p">],</span> <span
class="s2">"b"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">0< [...]
+<span class="gp">>>> </span><span class="n">nvl_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">nvl</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"b"</span><spa [...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">nvl_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"nvl"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">0</span>
+<span class="gp">>>> </span><span class="n">nvl_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"nvl"</span><span
class="p">)[</span><span class="mi">1</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5187,8 +5225,7 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.radians">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">radians</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion [...]
<dd><p>Converts the argument from degrees to radians.</p>
-<section id="id11">
-<h3>Examples:<a class="headerlink" href="#id11" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="kn">from</span><span class="w"> </span><span class="nn">math</span><span
class="w"> </span><span class="kn">import</span> <span class="n">pi</span>
<span class="gp">>>> </span><span class="n">ctx</span> <span
class="o">=</span> <span class="n">dfn</span><span class="o">.</span><span
class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">180.0</span><span class="p">]})</span>
@@ -5202,7 +5239,6 @@ column names or expressions.</p></li>
<span class="go">3.141593</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -5259,16 +5295,45 @@ column names or expressions.</p></li>
<dd><p>Returns the number of matches in a string.</p>
<p>Optional start position (the first position is 1) to search for the regular
expression.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"abcabc"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">regexp_count</span><span class="p">(</span><span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"a"</span><span
class="p">),</span> <span class="n">dfn</span><span class="o">.</span><span
class="n">lit</span><span class="p">(</span><span class="s2">"abc"
[...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"c"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">2</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.regexp_instr">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">regexp_instr</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">values</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">da [...]
<dd><p>Returns the position of a regular expression match in a string.</p>
-<p>Searches <code class="docutils literal notranslate"><span
class="pre">values</span></code> for the <code class="docutils literal
notranslate"><span class="pre">n</span></code>-th occurrence of <code
class="docutils literal notranslate"><span class="pre">regex</span></code>,
starting at position
-<code class="docutils literal notranslate"><span
class="pre">start</span></code> (the first position is 1). Returns the starting
or ending position based
-on <code class="docutils literal notranslate"><span
class="pre">end_position</span></code>. Use <code class="docutils literal
notranslate"><span class="pre">flags</span></code> to control regex behavior
and <code class="docutils literal notranslate"><span
class="pre">sub_expr</span></code> to
-return the position of a specific capture group instead of the entire
match.</p>
+<dl class="field-list simple">
+<dt class="field-odd">Parameters<span class="colon">:</span></dt>
+<dd class="field-odd"><ul class="simple">
+<li><p><strong>values</strong> – Data to search for the regular expression
match.</p></li>
+<li><p><strong>regex</strong> – Regular expression to search for.</p></li>
+<li><p><strong>start</strong> – Optional position to start the search (the
first position is 1).</p></li>
+<li><p><strong>n</strong> – Optional occurrence of the match to find (the
first occurrence is 1).</p></li>
+<li><p><strong>flags</strong> – Optional regular expression flags to control
regex behavior.</p></li>
+<li><p><strong>sub_expr</strong> – Optionally capture group position instead
of the entire match.</p></li>
+</ul>
+</dd>
+</dl>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello 42 world"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">regexp_instr</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">lit</span><span
class="p">(</span><span class="s2">"</span><span class="se">\\</span><span
class="s2">d+"</span><span class="p">)</span>
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"pos"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"pos"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">7</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5277,6 +5342,18 @@ return the position of a specific capture group instead
of the entire match.</p>
<dd><p>Find if any regular expression (regex) matches exist.</p>
<p>Tests a string using a regular expression returning true if at least one
match,
false otherwise.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello123"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">regexp_like</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">lit</span><span
class="p">(</span><span class="s2">"</span><span class="se">\\</span><span
class="s2">d+"</span><span class="p">)</span>
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"m"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"m"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">True</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5285,6 +5362,18 @@ false otherwise.</p>
<dd><p>Perform regular expression (regex) matching.</p>
<p>Returns an array with each element containing the leftmost-first match of
the
corresponding index in <code class="docutils literal notranslate"><span
class="pre">regex</span></code> to string in <code class="docutils literal
notranslate"><span class="pre">string</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello 42 world"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">regexp_match</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">lit</span><span
class="p">(</span><span class="s2">"(</span><span
class="se">\\</span><span class="s2">d+)"</span><span class="p">)</span>
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"m"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"m"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">['42']</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5295,6 +5384,19 @@ corresponding index in <code class="docutils literal
notranslate"><span class="p
<<a class="reference external"
href="https://docs.rs/regex/latest/regex/#syntax";>https://docs.rs/regex/latest/regex/#syntax</a>></p>
<p>Supported flags with the addition of ‘g’ can be found at
<<a class="reference external"
href="https://docs.rs/regex/latest/regex/#grouping-and-flags";>https://docs.rs/regex/latest/regex/#grouping-and-flags</a>></p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello 42"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">regexp_replace</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">lit</span><span
class="p">(</span><span class="s2">"</span><span class="se">\\</span><span
class="s2">d+"</span><span class="p">),</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">lit</span><span class="p">(</span><span
class="s2">"XX"</span><span class="p">)</span>
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"r"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"r"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">'hello XX'</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5550,24 +5652,64 @@ by default). If the string is already longer than
length then it is truncated.</
<dt class="sig sig-object py" id="datafusion.functions.sha224">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Computes the SHA-224 hash of a binary string.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sha224</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">))</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"h"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"h"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span><span
class="o">.</span><span class="n">hex</span><span class="p">()</span>
+<span
class="go">'ea09ae9cc6768c50fcee903ed054556e5bfc8347907f12598aa24193'</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.sha256">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Computes the SHA-256 hash of a binary string.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sha256</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">))</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"h"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"h"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span><span
class="o">.</span><span class="n">hex</span><span class="p">()</span>
+<span
class="go">'2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824'</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.sha384">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Computes the SHA-384 hash of a binary string.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sha384</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">))</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"h"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"h"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span><span
class="o">.</span><span class="n">hex</span><span class="p">()</span>
+<span class="go">'59e1748777448c69de6b800d7a33bbfb9ff1b...</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.sha512">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Computes the SHA-512 hash of a binary string.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="s2">"hello"</span><span
class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sha512</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">))</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"h"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"h"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span><span
class="o">.</span><span class="n">hex</span><span class="p">()</span>
+<span class="go">'9b71d224bd62f3785d96d46ad3ea3d73319bfb...</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5580,8 +5722,7 @@ by default). If the string is already longer than length
then it is truncated.</
<dt class="sig sig-object py" id="datafusion.functions.sin">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">sin</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns the sine of the argument.</p>
-<section id="id12">
-<h3>Examples:<a class="headerlink" href="#id12" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sin</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
@@ -5589,15 +5730,13 @@ by default). If the string is already longer than
length then it is truncated.</
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.sinh">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">sinh</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the hyperbolic sine of the argument.</p>
-<section id="id13">
-<h3>Examples:<a class="headerlink" href="#id13" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sinh</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
@@ -5605,7 +5744,6 @@ by default). If the string is already longer than length
then it is truncated.</
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -5703,6 +5841,22 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.struct">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="d [...]
<dd><p>Returns a struct with the given arguments.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">],</span> <span
class="s2">"b"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">2</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">struct</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"b"</span><span class="p">)</span>
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"s"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+</pre></div>
+</div>
+<p>Children in the new struct will always be <cite>c0</cite>, …,
<cite>cN-1</cite>
+for <cite>N</cite> children.</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">result</span><span class="o">.</span><span
class="n">collect_column</span><span class="p">(</span><span
class="s2">"s"</span><span class="p">)[</span><span
class="mi">0</span><span class="p">]</span><span class="o">.</span><span
class="n">as_py</span><span class="p">()</span> <span class="o">==</span> <span
class="p">{</span><span clas [...]
+<span class="go">True</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5746,8 +5900,7 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dt class="sig sig-object py" id="datafusion.functions.tan">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns the tangent of the argument.</p>
-<section id="id14">
-<h3>Examples:<a class="headerlink" href="#id14" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">tan</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
@@ -5755,15 +5908,13 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.tanh">
<span class="sig-prename descclassname"><span
class="pre">datafusion.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">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the hyperbolic tangent of the argument.</p>
-<section id="id15">
-<h3>Examples:<a class="headerlink" href="#id15" title="Link to this
heading">¶</a></h3>
+<p class="rubric">Examples</p>
<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">tanh</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
@@ -5771,7 +5922,6 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<span class="go">0.0</span>
</pre></div>
</div>
-</section>
</dd></dl>
<dl class="py function">
@@ -5887,6 +6037,16 @@ HH:MM:SS.nnnnnnnnn;</p>
<dt class="sig sig-object py" id="datafusion.functions.uuid">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">uuid</span></span><span
class="sig-paren">(</span><span class="sig-paren">)</span> <span
class="sig-return"><span class="sig-return-icon">→</span> <span
class="sig-return-typehint"><a class="reference internal"
href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span
class="pre">datafusion.expr.Expr</span></a></span [...]
<dd><p>Returns uuid v4 as a string value.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </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="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">uuid</span><span class="p">()</span><span class="o">.</span><span
class="n">alias</span><span class="p">(</span><span
class="s2">"u"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="nb">len</span><span
class="p">(</span><span class="n">result</span><span class="o">.</span><span
class="n">collect_column</span><span class="p">(</span><span
class="s2">"u"</span><span class="p">)[</span><span
class="mi">0</span><span class="p">]</span><span class="o">.</span><span
class="n">as_py</span><span class="p">())</span> <span class="o">==</span>
<span class="mi">36</span>
+<span class="go">True</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
diff --git a/searchindex.js b/searchindex.js
index 924d4d20..55b818c7 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[19, null]], "Additional
Resources": [[37, "additional-resources"]], "Aggregate Functions": [[24,
"aggregate-functions"], [31, "aggregate-functions"], [33,
"aggregate-functions"]], "Aggregation": [[24, null]], "Alternative Approach":
[[20, "alternative-approach"]], "Apache Iceberg": [[35, "apache-iceberg"]],
"Arrays": [[26, "arrays"]], "Arrow": [[39, null]], "Attributes": [[4,
"attributes"], [5, "attributes"], [7, "attributes"], [12, "attr [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[19, null]], "Additional
Resources": [[37, "additional-resources"]], "Aggregate Functions": [[24,
"aggregate-functions"], [31, "aggregate-functions"], [33,
"aggregate-functions"]], "Aggregation": [[24, null]], "Alternative Approach":
[[20, "alternative-approach"]], "Apache Iceberg": [[35, "apache-iceberg"]],
"Arrays": [[26, "arrays"]], "Arrow": [[39, null]], "Attributes": [[4,
"attributes"], [5, "attributes"], [7, "attributes"], [12, "attr [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 2e0c5ca4..45de1a6f 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -620,15 +620,15 @@ Pokemon set. Since there will be many entries of <code
class="docutils literal n
<span
class="o">+----------+--------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Poison</span><span
class="p">,</span> <span class="n">Grass</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="p">,</span> <span class="n">Grass</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Steel</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="p">[]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Fairy</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Poison</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">,</span> <span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Dragon</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ice</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span
class="p">,</span> <span class="p">]</span>
<span class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
@@ -644,15 +644,15 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Grass</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dark</span><span
class="p">,</span> <span class="n">Fighting</span><span class="p">,</span>
<span class="n">Psychic</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Water</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Ground</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Dragon</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">,</span> <span class="n">Ice</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Water</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
@@ -663,15 +663,15 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Grass</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Grass</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dark</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Poison</span><span
class="p">,</span> <span class="n">Fighting</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Dark</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index cbad3137..13bf320e 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -456,11 +456,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">325</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">893</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">689</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">349</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">824</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">267</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">687</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">749</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">531</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">211</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -471,8 +471,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">325</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">893</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">267</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">687</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -490,11 +490,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">325</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">893</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">689</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">349</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">824</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">267</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">687</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">749</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">531</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">211</span> <span
class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal"
href="../../autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.describe"
title="datafusion.dataframe.DataFrame.describe"><code class="xref py py-func
docutils literal notranslate"><span class="pre">describe()</span></code></a>
shows a quick statistic summary of your data:</p>
@@ -506,11 +506,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">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</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">616.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">265.18484119572145</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">325.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">893.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">689.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">489.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">242.45411937106783</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">211.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">749.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">531.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/functions.html
b/user-guide/common-operations/functions.html
index 7d68e875..212c1352 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -566,16 +566,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">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">50</span><span class="p">:</span><span
class="mf">15.663887695</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
<span class="o">+-------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
</pre></div>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
