This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 3c748b2b5e Publish built docs triggered by
ac827abe1b66b1dfa02ce65ae857477f68667843
3c748b2b5e is described below
commit 3c748b2b5e1123b23268a74e82164d522e48acca
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Oct 24 11:27:13 2024 +0000
Publish built docs triggered by ac827abe1b66b1dfa02ce65ae857477f68667843
---
_sources/user-guide/sql/scalar_functions.md.txt | 145 ---------
.../user-guide/sql/scalar_functions_new.md.txt | 144 +++++++++
searchindex.js | 2 +-
user-guide/sql/index.html | 2 +-
user-guide/sql/scalar_functions.html | 271 ----------------
user-guide/sql/scalar_functions_new.html | 345 +++++++++++++++++----
6 files changed, 434 insertions(+), 475 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 547ea10808..2034114287 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -199,151 +199,6 @@ Unwraps struct fields into columns.
+-----------------------+-----------------------+
```
-## Map Functions
-
-- [map](#map)
-- [make_map](#make_map)
-- [map_extract](#map_extract)
-- [map_keys](#map_keys)
-- [map_values](#map_values)
-
-### `map`
-
-Returns an Arrow map with the specified key-value pairs.
-
-```
-map(key, value)
-map(key: value)
-```
-
-#### Arguments
-
-- **key**: Expression to be used for key.
- Can be a constant, column, or function, any combination of arithmetic or
- string operators, or a named expression of previous listed.
-- **value**: Expression to be used for value.
- Can be a constant, column, or function, any combination of arithmetic or
- string operators, or a named expression of previous listed.
-
-#### Example
-
-```
-SELECT MAP(['POST', 'HEAD', 'PATCH'], [41, 33, null]);
-----
-{POST: 41, HEAD: 33, PATCH: }
-
-SELECT MAP([[1,2], [3,4]], ['a', 'b']);
-----
-{[1, 2]: a, [3, 4]: b}
-
-SELECT MAP { 'a': 1, 'b': 2 };
-----
-{a: 1, b: 2}
-```
-
-### `make_map`
-
-Returns an Arrow map with the specified key-value pairs.
-
-```
-make_map(key_1, value_1, ..., key_n, value_n)
-```
-
-#### Arguments
-
-- **key_n**: Expression to be used for key.
- Can be a constant, column, or function, any combination of arithmetic or
- string operators, or a named expression of previous listed.
-- **value_n**: Expression to be used for value.
- Can be a constant, column, or function, any combination of arithmetic or
- string operators, or a named expression of previous listed.
-
-#### Example
-
-```
-SELECT MAKE_MAP('POST', 41, 'HEAD', 33, 'PATCH', null);
-----
-{POST: 41, HEAD: 33, PATCH: }
-```
-
-### `map_extract`
-
-Return a list containing the value for a given key or an empty list if the key
is not contained in the map.
-
-```
-map_extract(map, key)
-```
-
-#### Arguments
-
-- `map`: Map expression.
- Can be a constant, column, or function, and any combination of map operators.
-- `key`: Key to extract from the map.
- Can be a constant, column, or function, any combination of arithmetic or
- string operators, or a named expression of previous listed.
-
-#### Example
-
-```
-SELECT map_extract(MAP {'a': 1, 'b': NULL, 'c': 3}, 'a');
-----
-[1]
-```
-
-#### Aliases
-
-- element_at
-
-### `map_keys`
-
-Return a list of all keys in the map.
-
-```
-map_keys(map)
-```
-
-#### Arguments
-
-- `map`: Map expression.
- Can be a constant, column, or function, and any combination of map operators.
-
-#### Example
-
-```
-SELECT map_keys(MAP {'a': 1, 'b': NULL, 'c': 3});
-----
-[a, b, c]
-
-select map_keys(map([100, 5], [42,43]));
-----
-[100, 5]
-```
-
-### `map_values`
-
-Return a list of all values in the map.
-
-```
-map_values(map)
-```
-
-#### Arguments
-
-- `map`: Map expression.
- Can be a constant, column, or function, and any combination of map operators.
-
-#### Example
-
-```
-SELECT map_values(MAP {'a': 1, 'b': NULL, 'c': 3});
-----
-[1, , 3]
-
-select map_values(map([100, 5], [42,43]));
-----
-[42, 43]
-```
-
## Other Functions
See the new documentation
[`here`](https://datafusion.apache.org/user-guide/sql/scalar_functions_new.html)
diff --git a/_sources/user-guide/sql/scalar_functions_new.md.txt
b/_sources/user-guide/sql/scalar_functions_new.md.txt
index 1f4ec1c278..7d0280dbc2 100644
--- a/_sources/user-guide/sql/scalar_functions_new.md.txt
+++ b/_sources/user-guide/sql/scalar_functions_new.md.txt
@@ -3898,6 +3898,150 @@ select struct(a as field_a, b) from t;
- row
+## Map Functions
+
+- [element_at](#element_at)
+- [map](#map)
+- [map_extract](#map_extract)
+- [map_keys](#map_keys)
+- [map_values](#map_values)
+
+### `element_at`
+
+_Alias of [map_extract](#map_extract)._
+
+### `map`
+
+Returns an Arrow map with the specified key-value pairs.
+
+The `make_map` function creates a map from two lists: one for keys and one for
values. Each key must be unique and non-null.
+
+```
+map(key, value)
+map(key: value)
+make_map(['key1', 'key2'], ['value1', 'value2'])
+```
+
+#### Arguments
+
+- **key**: For `map`: Expression to be used for key. Can be a constant,
column, function, or any combination of arithmetic or string operators.
+ For `make_map`: The list of keys to be used in the map. Each key must be
unique and non-null.
+- **value**: For `map`: Expression to be used for value. Can be a constant,
column, function, or any combination of arithmetic or string operators.
+ For `make_map`: The list of values to be mapped to the corresponding keys.
+
+#### Example
+
+````sql
+ -- Using map function
+ SELECT MAP('type', 'test');
+ ----
+ {type: test}
+
+ SELECT MAP(['POST', 'HEAD', 'PATCH'], [41, 33, null]);
+ ----
+ {POST: 41, HEAD: 33, PATCH: }
+
+ SELECT MAP([[1,2], [3,4]], ['a', 'b']);
+ ----
+ {[1, 2]: a, [3, 4]: b}
+
+ SELECT MAP { 'a': 1, 'b': 2 };
+ ----
+ {a: 1, b: 2}
+
+ -- Using make_map function
+ SELECT MAKE_MAP(['POST', 'HEAD'], [41, 33]);
+ ----
+ {POST: 41, HEAD: 33}
+
+ SELECT MAKE_MAP(['key1', 'key2'], ['value1', null]);
+ ----
+ {key1: value1, key2: }
+ ```
+
+
+### `map_extract`
+
+Returns a list containing the value for the given key or an empty list if the
key is not present in the map.
+
+````
+
+map_extract(map, key)
+
+````
+#### Arguments
+
+- **map**: Map expression. Can be a constant, column, or function, and any
combination of map operators.
+- **key**: Key to extract from the map. Can be a constant, column, or
function, any combination of arithmetic or string operators, or a named
expression of the previously listed.
+
+#### Example
+
+```sql
+SELECT map_extract(MAP {'a': 1, 'b': NULL, 'c': 3}, 'a');
+----
+[1]
+
+SELECT map_extract(MAP {1: 'one', 2: 'two'}, 2);
+----
+['two']
+
+SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, 'y');
+----
+[]
+````
+
+#### Aliases
+
+- element_at
+
+### `map_keys`
+
+Returns a list of all keys in the map.
+
+```
+map_keys(map)
+```
+
+#### Arguments
+
+- **map**: Map expression. Can be a constant, column, or function, and any
combination of map operators.
+
+#### Example
+
+```sql
+SELECT map_keys(MAP {'a': 1, 'b': NULL, 'c': 3});
+----
+[a, b, c]
+
+SELECT map_keys(map([100, 5], [42, 43]));
+----
+[100, 5]
+```
+
+### `map_values`
+
+Returns a list of all values in the map.
+
+```
+map_values(map)
+```
+
+#### Arguments
+
+- **map**: Map expression. Can be a constant, column, or function, and any
combination of map operators.
+
+#### Example
+
+```sql
+SELECT map_values(MAP {'a': 1, 'b': NULL, 'c': 3});
+----
+[1, , 3]
+
+SELECT map_values(map([100, 5], [42, 43]));
+----
+[42, 43]
+```
+
## Hashing Functions
- [digest](#digest)
diff --git a/searchindex.js b/searchindex.js
index 7e32472dd7..29a62469c7 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47,
"op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]],
"!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]],
"&": [[47, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47,
"op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]],
"!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]],
"&": [[47, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index 9122ccd46c..e6f1dbb711 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -618,7 +618,6 @@
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#time-and-date-functions">Time and Date
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#array-functions">Array Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#struct-functions">Struct Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#map-functions">Map Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#other-functions">Other Functions</a></li>
</ul>
</li>
@@ -631,6 +630,7 @@
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#time-and-date-functions">Time and Date
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#array-functions">Array Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#struct-functions">Struct Functions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#map-functions">Map Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#hashing-functions">Hashing Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#other-functions">Other Functions</a></li>
</ul>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 2479d12fbd..6680359031 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -627,123 +627,6 @@
</li>
</ul>
</li>
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#map-functions">
- Map Functions
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#map">
- <code class="docutils literal notranslate">
- <span class="pre">
- map
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id5">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#example">
- Example
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#make-map">
- <code class="docutils literal notranslate">
- <span class="pre">
- make_map
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id6">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id7">
- Example
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#map-extract">
- <code class="docutils literal notranslate">
- <span class="pre">
- map_extract
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id8">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id9">
- Example
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id10">
- Aliases
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#map-keys">
- <code class="docutils literal notranslate">
- <span class="pre">
- map_keys
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id11">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id12">
- Example
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#map-values">
- <code class="docutils literal notranslate">
- <span class="pre">
- map_values
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id13">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id14">
- Example
- </a>
- </li>
- </ul>
- </li>
- </ul>
- </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#other-functions">
Other Functions
@@ -972,160 +855,6 @@ Can be a constant, column, or function, and any
combination of object operators.
</section>
</section>
</section>
-<section id="map-functions">
-<h2>Map Functions<a class="headerlink" href="#map-functions" title="Link to
this heading">¶</a></h2>
-<ul class="simple">
-<li><p><a class="reference internal" href="#map">map</a></p></li>
-<li><p><a class="reference internal" href="#make-map">make_map</a></p></li>
-<li><p><a class="reference internal"
href="#map-extract">map_extract</a></p></li>
-<li><p><a class="reference internal" href="#map-keys">map_keys</a></p></li>
-<li><p><a class="reference internal" href="#map-values">map_values</a></p></li>
-</ul>
-<section id="map">
-<h3><code class="docutils literal notranslate"><span
class="pre">map</span></code><a class="headerlink" href="#map" title="Link to
this heading">¶</a></h3>
-<p>Returns an Arrow map with the specified key-value pairs.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">map</span><span
class="p">(</span><span class="n">key</span><span class="p">,</span> <span
class="n">value</span><span class="p">)</span>
-<span class="nb">map</span><span class="p">(</span><span
class="n">key</span><span class="p">:</span> <span class="n">value</span><span
class="p">)</span>
-</pre></div>
-</div>
-<section id="id5">
-<h4>Arguments<a class="headerlink" href="#id5" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>key</strong>: Expression to be used for key.
-Can be a constant, column, or function, any combination of arithmetic or
-string operators, or a named expression of previous listed.</p></li>
-<li><p><strong>value</strong>: Expression to be used for value.
-Can be a constant, column, or function, any combination of arithmetic or
-string operators, or a named expression of previous listed.</p></li>
-</ul>
-</section>
-<section id="example">
-<h4>Example<a class="headerlink" href="#example" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="n">MAP</span><span class="p">([</span><span
class="s1">'POST'</span><span class="p">,</span> <span
class="s1">'HEAD'</span><span class="p">,</span> <span
class="s1">'PATCH'</span><span class="p">],</span> <span
class="p">[</span><span class="mi">41</span><span class="p">,</span> <span
class="mi">33</span><span class="p">,</span> <span clas [...]
-<span class="o">----</span>
-<span class="p">{</span><span class="n">POST</span><span class="p">:</span>
<span class="mi">41</span><span class="p">,</span> <span
class="n">HEAD</span><span class="p">:</span> <span class="mi">33</span><span
class="p">,</span> <span class="n">PATCH</span><span class="p">:</span> <span
class="p">}</span>
-
-<span class="n">SELECT</span> <span class="n">MAP</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span><span
class="mi">2</span><span class="p">],</span> <span class="p">[</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]],</span> <span class="p">[</span><span
class="s1">'a'</span><span class="p">,</span> <span
class="s1">'b'</span><span class="p">]);</span>
-<span class="o">----</span>
-<span class="p">{[</span><span class="mi">1</span><span class="p">,</span>
<span class="mi">2</span><span class="p">]:</span> <span
class="n">a</span><span class="p">,</span> <span class="p">[</span><span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">]:</span> <span class="n">b</span><span class="p">}</span>
-
-<span class="n">SELECT</span> <span class="n">MAP</span> <span
class="p">{</span> <span class="s1">'a'</span><span class="p">:</span>
<span class="mi">1</span><span class="p">,</span> <span
class="s1">'b'</span><span class="p">:</span> <span class="mi">2</span>
<span class="p">};</span>
-<span class="o">----</span>
-<span class="p">{</span><span class="n">a</span><span class="p">:</span> <span
class="mi">1</span><span class="p">,</span> <span class="n">b</span><span
class="p">:</span> <span class="mi">2</span><span class="p">}</span>
-</pre></div>
-</div>
-</section>
-</section>
-<section id="make-map">
-<h3><code class="docutils literal notranslate"><span
class="pre">make_map</span></code><a class="headerlink" href="#make-map"
title="Link to this heading">¶</a></h3>
-<p>Returns an Arrow map with the specified key-value pairs.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">make_map</span><span
class="p">(</span><span class="n">key_1</span><span class="p">,</span> <span
class="n">value_1</span><span class="p">,</span> <span
class="o">...</span><span class="p">,</span> <span class="n">key_n</span><span
class="p">,</span> <span class="n">value_n</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id6">
-<h4>Arguments<a class="headerlink" href="#id6" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>key_n</strong>: Expression to be used for key.
-Can be a constant, column, or function, any combination of arithmetic or
-string operators, or a named expression of previous listed.</p></li>
-<li><p><strong>value_n</strong>: Expression to be used for value.
-Can be a constant, column, or function, any combination of arithmetic or
-string operators, or a named expression of previous listed.</p></li>
-</ul>
-</section>
-<section id="id7">
-<h4>Example<a class="headerlink" href="#id7" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="n">MAKE_MAP</span><span class="p">(</span><span
class="s1">'POST'</span><span class="p">,</span> <span
class="mi">41</span><span class="p">,</span> <span
class="s1">'HEAD'</span><span class="p">,</span> <span
class="mi">33</span><span class="p">,</span> <span
class="s1">'PATCH'</span><span class="p">,</span> <span
class="n">null</span><spa [...]
-<span class="o">----</span>
-<span class="p">{</span><span class="n">POST</span><span class="p">:</span>
<span class="mi">41</span><span class="p">,</span> <span
class="n">HEAD</span><span class="p">:</span> <span class="mi">33</span><span
class="p">,</span> <span class="n">PATCH</span><span class="p">:</span> <span
class="p">}</span>
-</pre></div>
-</div>
-</section>
-</section>
-<section id="map-extract">
-<h3><code class="docutils literal notranslate"><span
class="pre">map_extract</span></code><a class="headerlink" href="#map-extract"
title="Link to this heading">¶</a></h3>
-<p>Return a list containing the value for a given key or an empty list if the
key is not contained in the map.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">map_extract</span><span
class="p">(</span><span class="nb">map</span><span class="p">,</span> <span
class="n">key</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id8">
-<h4>Arguments<a class="headerlink" href="#id8" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><code class="docutils literal notranslate"><span
class="pre">map</span></code>: Map expression.
-Can be a constant, column, or function, and any combination of map
operators.</p></li>
-<li><p><code class="docutils literal notranslate"><span
class="pre">key</span></code>: Key to extract from the map.
-Can be a constant, column, or function, any combination of arithmetic or
-string operators, or a named expression of previous listed.</p></li>
-</ul>
-</section>
-<section id="id9">
-<h4>Example<a class="headerlink" href="#id9" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="n">map_extract</span><span class="p">(</span><span class="n">MAP</span>
<span class="p">{</span><span class="s1">'a'</span><span
class="p">:</span> <span class="mi">1</span><span class="p">,</span> <span
class="s1">'b'</span><span class="p">:</span> <span
class="n">NULL</span><span class="p">,</span> <span
class="s1">'c'</span><span class= [...]
-<span class="o">----</span>
-<span class="p">[</span><span class="mi">1</span><span class="p">]</span>
-</pre></div>
-</div>
-</section>
-<section id="id10">
-<h4>Aliases<a class="headerlink" href="#id10" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p>element_at</p></li>
-</ul>
-</section>
-</section>
-<section id="map-keys">
-<h3><code class="docutils literal notranslate"><span
class="pre">map_keys</span></code><a class="headerlink" href="#map-keys"
title="Link to this heading">¶</a></h3>
-<p>Return a list of all keys in the map.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">map_keys</span><span
class="p">(</span><span class="nb">map</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id11">
-<h4>Arguments<a class="headerlink" href="#id11" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><code class="docutils literal notranslate"><span
class="pre">map</span></code>: Map expression.
-Can be a constant, column, or function, and any combination of map
operators.</p></li>
-</ul>
-</section>
-<section id="id12">
-<h4>Example<a class="headerlink" href="#id12" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="n">map_keys</span><span class="p">(</span><span class="n">MAP</span>
<span class="p">{</span><span class="s1">'a'</span><span
class="p">:</span> <span class="mi">1</span><span class="p">,</span> <span
class="s1">'b'</span><span class="p">:</span> <span
class="n">NULL</span><span class="p">,</span> <span
class="s1">'c'</span><span class="p" [...]
-<span class="o">----</span>
-<span class="p">[</span><span class="n">a</span><span class="p">,</span> <span
class="n">b</span><span class="p">,</span> <span class="n">c</span><span
class="p">]</span>
-
-<span class="n">select</span> <span class="n">map_keys</span><span
class="p">(</span><span class="nb">map</span><span class="p">([</span><span
class="mi">100</span><span class="p">,</span> <span class="mi">5</span><span
class="p">],</span> <span class="p">[</span><span class="mi">42</span><span
class="p">,</span><span class="mi">43</span><span class="p">]));</span>
-<span class="o">----</span>
-<span class="p">[</span><span class="mi">100</span><span class="p">,</span>
<span class="mi">5</span><span class="p">]</span>
-</pre></div>
-</div>
-</section>
-</section>
-<section id="map-values">
-<h3><code class="docutils literal notranslate"><span
class="pre">map_values</span></code><a class="headerlink" href="#map-values"
title="Link to this heading">¶</a></h3>
-<p>Return a list of all values in the map.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">map_values</span><span
class="p">(</span><span class="nb">map</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id13">
-<h4>Arguments<a class="headerlink" href="#id13" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><code class="docutils literal notranslate"><span
class="pre">map</span></code>: Map expression.
-Can be a constant, column, or function, and any combination of map
operators.</p></li>
-</ul>
-</section>
-<section id="id14">
-<h4>Example<a class="headerlink" href="#id14" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="n">map_values</span><span class="p">(</span><span class="n">MAP</span>
<span class="p">{</span><span class="s1">'a'</span><span
class="p">:</span> <span class="mi">1</span><span class="p">,</span> <span
class="s1">'b'</span><span class="p">:</span> <span
class="n">NULL</span><span class="p">,</span> <span
class="s1">'c'</span><span class=" [...]
-<span class="o">----</span>
-<span class="p">[</span><span class="mi">1</span><span class="p">,</span>
<span class="p">,</span> <span class="mi">3</span><span class="p">]</span>
-
-<span class="n">select</span> <span class="n">map_values</span><span
class="p">(</span><span class="nb">map</span><span class="p">([</span><span
class="mi">100</span><span class="p">,</span> <span class="mi">5</span><span
class="p">],</span> <span class="p">[</span><span class="mi">42</span><span
class="p">,</span><span class="mi">43</span><span class="p">]));</span>
-<span class="o">----</span>
-<span class="p">[</span><span class="mi">42</span><span class="p">,</span>
<span class="mi">43</span><span class="p">]</span>
-</pre></div>
-</div>
-</section>
-</section>
-</section>
<section id="other-functions">
<h2>Other Functions<a class="headerlink" href="#other-functions" title="Link
to this heading">¶</a></h2>
<p>See the new documentation <a class="reference external"
href="https://datafusion.apache.org/user-guide/sql/scalar_functions_new.html";><code
class="docutils literal notranslate"><span
class="pre">here</span></code></a></p>
diff --git a/user-guide/sql/scalar_functions_new.html
b/user-guide/sql/scalar_functions_new.html
index 54106672be..d562814119 100644
--- a/user-guide/sql/scalar_functions_new.html
+++ b/user-guide/sql/scalar_functions_new.html
@@ -3995,6 +3995,90 @@
</li>
</ul>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#map-functions">
+ Map Functions
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#element-at">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ element_at
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#map">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ map
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id268">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id269">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id270">
+ Aliases
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#map-keys">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ map_keys
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id271">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id272">
+ Example
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#map-values">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ map_values
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id273">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id274">
+ Example
+ </a>
+ </li>
+ </ul>
+ </li>
+ </ul>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#hashing-functions">
Hashing Functions
@@ -4010,12 +4094,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id268">
+ <a class="reference internal nav-link" href="#id275">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id269">
+ <a class="reference internal nav-link" href="#id276">
Example
</a>
</li>
@@ -4031,12 +4115,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id270">
+ <a class="reference internal nav-link" href="#id277">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id271">
+ <a class="reference internal nav-link" href="#id278">
Example
</a>
</li>
@@ -4052,12 +4136,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id272">
+ <a class="reference internal nav-link" href="#id279">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id273">
+ <a class="reference internal nav-link" href="#id280">
Example
</a>
</li>
@@ -4073,12 +4157,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id274">
+ <a class="reference internal nav-link" href="#id281">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id275">
+ <a class="reference internal nav-link" href="#id282">
Example
</a>
</li>
@@ -4094,12 +4178,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id276">
+ <a class="reference internal nav-link" href="#id283">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id277">
+ <a class="reference internal nav-link" href="#id284">
Example
</a>
</li>
@@ -4115,12 +4199,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id278">
+ <a class="reference internal nav-link" href="#id285">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id279">
+ <a class="reference internal nav-link" href="#id286">
Example
</a>
</li>
@@ -4143,12 +4227,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id280">
+ <a class="reference internal nav-link" href="#id287">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id281">
+ <a class="reference internal nav-link" href="#id288">
Example
</a>
</li>
@@ -4164,12 +4248,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id282">
+ <a class="reference internal nav-link" href="#id289">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id283">
+ <a class="reference internal nav-link" href="#id290">
Example
</a>
</li>
@@ -4185,12 +4269,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id284">
+ <a class="reference internal nav-link" href="#id291">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id285">
+ <a class="reference internal nav-link" href="#id292">
Example
</a>
</li>
@@ -4206,7 +4290,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id286">
+ <a class="reference internal nav-link" href="#id293">
Example
</a>
</li>
@@ -8365,6 +8449,153 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
</section>
</section>
</section>
+<section id="map-functions">
+<h2>Map Functions<a class="headerlink" href="#map-functions" title="Link to
this heading">¶</a></h2>
+<ul class="simple">
+<li><p><a class="reference internal" href="#element-at">element_at</a></p></li>
+<li><p><a class="reference internal" href="#map">map</a></p></li>
+<li><p><a class="reference internal" href="#map_extract"><span class="xref
myst">map_extract</span></a></p></li>
+<li><p><a class="reference internal" href="#map-keys">map_keys</a></p></li>
+<li><p><a class="reference internal" href="#map-values">map_values</a></p></li>
+</ul>
+<section id="element-at">
+<h3><code class="docutils literal notranslate"><span
class="pre">element_at</span></code><a class="headerlink" href="#element-at"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" href="#map_extract"><span
class="xref myst">map_extract</span></a>.</em></p>
+</section>
+<section id="map">
+<h3><code class="docutils literal notranslate"><span
class="pre">map</span></code><a class="headerlink" href="#map" title="Link to
this heading">¶</a></h3>
+<p>Returns an Arrow map with the specified key-value pairs.</p>
+<p>The <code class="docutils literal notranslate"><span
class="pre">make_map</span></code> function creates a map from two lists: one
for keys and one for values. Each key must be unique and non-null.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">map</span><span
class="p">(</span><span class="n">key</span><span class="p">,</span> <span
class="n">value</span><span class="p">)</span>
+<span class="nb">map</span><span class="p">(</span><span
class="n">key</span><span class="p">:</span> <span class="n">value</span><span
class="p">)</span>
+<span class="n">make_map</span><span class="p">([</span><span
class="s1">'key1'</span><span class="p">,</span> <span
class="s1">'key2'</span><span class="p">],</span> <span
class="p">[</span><span class="s1">'value1'</span><span
class="p">,</span> <span class="s1">'value2'</span><span
class="p">])</span>
+</pre></div>
+</div>
+<section id="id268">
+<h4>Arguments<a class="headerlink" href="#id268" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>key</strong>: For <code class="docutils literal
notranslate"><span class="pre">map</span></code>: Expression to be used for
key. Can be a constant, column, function, or any combination of arithmetic or
string operators.
+For <code class="docutils literal notranslate"><span
class="pre">make_map</span></code>: The list of keys to be used in the map.
Each key must be unique and non-null.</p></li>
+<li><p><strong>value</strong>: For <code class="docutils literal
notranslate"><span class="pre">map</span></code>: Expression to be used for
value. Can be a constant, column, function, or any combination of arithmetic or
string operators.
+For <code class="docutils literal notranslate"><span
class="pre">make_map</span></code>: The list of values to be mapped to the
corresponding keys.</p></li>
+</ul>
+</section>
+<section id="id269">
+<h4>Example<a class="headerlink" href="#id269" title="Link to this
heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="w"> </span><span
class="c1">-- Using map function</span>
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="k">MAP</span><span class="p">(</span><span
class="s1">'type'</span><span class="p">,</span><span class="w">
</span><span class="s1">'test'</span><span class="p">);</span>
+<span class="w"> </span><span class="c1">----</span>
+<span class="w"> </span><span class="err">{</span><span
class="k">type</span><span class="p">:</span><span class="w"> </span><span
class="n">test</span><span class="err">}</span>
+
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="k">MAP</span><span class="p">([</span><span
class="s1">'POST'</span><span class="p">,</span><span class="w">
</span><span class="s1">'HEAD'</span><span class="p">,</span><span
class="w"> </span><span class="s1">'PATCH'</span><span
class="p">],</span><span class="w"> </span><span class="p">[</span><span
class="mi">41</span><span class="p">,</span><span class="w"> </span [...]
+<span class="w"> </span><span class="c1">----</span>
+<span class="w"> </span><span class="err">{</span><span
class="n">POST</span><span class="p">:</span><span class="w"> </span><span
class="mi">41</span><span class="p">,</span><span class="w"> </span><span
class="n">HEAD</span><span class="p">:</span><span class="w"> </span><span
class="mi">33</span><span class="p">,</span><span class="w"> </span><span
class="n">PATCH</span><span class="p">:</span><span class="w"> </span><span
class="err">}</span>
+
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="k">MAP</span><span class="p">([[</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">],</span><span class="w"> </span><span class="p">[</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]],</span><span class="w"> </span><span class="p">[</span><span
class="s1">'a'</span><span class="p">,</span><s [...]
+<span class="w"> </span><span class="c1">----</span>
+<span class="w"> </span><span class="err">{</span><span
class="p">[</span><span class="mi">1</span><span class="p">,</span><span
class="w"> </span><span class="mi">2</span><span class="p">]:</span><span
class="w"> </span><span class="n">a</span><span class="p">,</span><span
class="w"> </span><span class="p">[</span><span class="mi">3</span><span
class="p">,</span><span class="w"> </span><span class="mi">4</span><span
class="p">]:</span><span class="w"> </span><span class="n">b</sp [...]
+
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="k">MAP</span><span class="w"> </span><span
class="err">{</span><span class="w"> </span><span
class="s1">'a'</span><span class="p">:</span><span class="w">
</span><span class="mi">1</span><span class="p">,</span><span class="w">
</span><span class="s1">'b'</span><span class="p">:</span><span
class="w"> </span><span class="mi">2</span><span class="w"> </span><span
class="err">}< [...]
+<span class="w"> </span><span class="c1">----</span>
+<span class="w"> </span><span class="err">{</span><span
class="n">a</span><span class="p">:</span><span class="w"> </span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="n">b</span><span class="p">:</span><span class="w"> </span><span
class="mi">2</span><span class="err">}</span>
+
+<span class="w"> </span><span class="c1">-- Using make_map
function</span>
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="n">MAKE_MAP</span><span class="p">([</span><span
class="s1">'POST'</span><span class="p">,</span><span class="w">
</span><span class="s1">'HEAD'</span><span class="p">],</span><span
class="w"> </span><span class="p">[</span><span class="mi">41</span><span
class="p">,</span><span class="w"> </span><span class="mi">33</span><span
class="p">]);</span>
+<span class="w"> </span><span class="c1">----</span>
+<span class="w"> </span><span class="err">{</span><span
class="n">POST</span><span class="p">:</span><span class="w"> </span><span
class="mi">41</span><span class="p">,</span><span class="w"> </span><span
class="n">HEAD</span><span class="p">:</span><span class="w"> </span><span
class="mi">33</span><span class="err">}</span>
+
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="n">MAKE_MAP</span><span class="p">([</span><span
class="s1">'key1'</span><span class="p">,</span><span class="w">
</span><span class="s1">'key2'</span><span class="p">],</span><span
class="w"> </span><span class="p">[</span><span
class="s1">'value1'</span><span class="p">,</span><span class="w">
</span><span class="k">null</span><span class="p">]);</span>
+<span class="w"> </span><span class="c1">----</span>
+<span class="w"> </span><span class="err">{</span><span
class="n">key1</span><span class="p">:</span><span class="w"> </span><span
class="n">value1</span><span class="p">,</span><span class="w"> </span><span
class="n">key2</span><span class="p">:</span><span class="w"> </span><span
class="err">}</span>
+<span class="w"> </span><span class="o">```</span>
+
+
+<span class="o">###</span><span class="w"> </span><span
class="o">`</span><span class="n">map_extract</span><span class="o">`</span>
+
+<span class="k">Returns</span><span class="w"> </span><span
class="n">a</span><span class="w"> </span><span class="n">list</span><span
class="w"> </span><span class="n">containing</span><span class="w">
</span><span class="n">the</span><span class="w"> </span><span
class="n">value</span><span class="w"> </span><span class="k">for</span><span
class="w"> </span><span class="n">the</span><span class="w"> </span><span
class="n">given</span><span class="w"> </span><span class="k">key</span><s [...]
+</pre></div>
+</div>
+<p>map_extract(map, key)</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>#### Arguments
+
+- **map**: Map expression. Can be a constant, column, or function, and any
combination of map operators.
+- **key**: Key to extract from the map. Can be a constant, column, or
function, any combination of arithmetic or string operators, or a named
expression of the previously listed.
+
+#### Example
+
+```sql
+SELECT map_extract(MAP {'a': 1, 'b': NULL, 'c': 3},
'a');
+----
+[1]
+
+SELECT map_extract(MAP {1: 'one', 2: 'two'}, 2);
+----
+['two']
+
+SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30},
'y');
+----
+[]
+</pre></div>
+</div>
+</section>
+<section id="id270">
+<h4>Aliases<a class="headerlink" href="#id270" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>element_at</p></li>
+</ul>
+</section>
+</section>
+<section id="map-keys">
+<h3><code class="docutils literal notranslate"><span
class="pre">map_keys</span></code><a class="headerlink" href="#map-keys"
title="Link to this heading">¶</a></h3>
+<p>Returns a list of all keys in the map.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">map_keys</span><span
class="p">(</span><span class="nb">map</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id271">
+<h4>Arguments<a class="headerlink" href="#id271" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>map</strong>: Map expression. Can be a constant, column, or
function, and any combination of map operators.</p></li>
+</ul>
+</section>
+<section id="id272">
+<h4>Example<a class="headerlink" href="#id272" title="Link to this
heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">map_keys</span><span class="p">(</span><span
class="k">MAP</span><span class="w"> </span><span class="err">{</span><span
class="s1">'a'</span><span class="p">:</span><span class="w">
</span><span class="mi">1</span><span class="p">,</span><span class="w">
</span><span class="s1">'b'</span><span class="p">:</span><span class="
[...]
+<span class="c1">----</span>
+<span class="p">[</span><span class="n">a</span><span class="p">,</span><span
class="w"> </span><span class="n">b</span><span class="p">,</span><span
class="w"> </span><span class="k">c</span><span class="p">]</span>
+
+<span class="k">SELECT</span><span class="w"> </span><span
class="n">map_keys</span><span class="p">(</span><span
class="k">map</span><span class="p">([</span><span class="mi">100</span><span
class="p">,</span><span class="w"> </span><span class="mi">5</span><span
class="p">],</span><span class="w"> </span><span class="p">[</span><span
class="mi">42</span><span class="p">,</span><span class="w"> </span><span
class="mi">43</span><span class="p">]));</span>
+<span class="c1">----</span>
+<span class="p">[</span><span class="mi">100</span><span
class="p">,</span><span class="w"> </span><span class="mi">5</span><span
class="p">]</span>
+</pre></div>
+</div>
+</section>
+</section>
+<section id="map-values">
+<h3><code class="docutils literal notranslate"><span
class="pre">map_values</span></code><a class="headerlink" href="#map-values"
title="Link to this heading">¶</a></h3>
+<p>Returns a list of all values in the map.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">map_values</span><span
class="p">(</span><span class="nb">map</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id273">
+<h4>Arguments<a class="headerlink" href="#id273" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>map</strong>: Map expression. Can be a constant, column, or
function, and any combination of map operators.</p></li>
+</ul>
+</section>
+<section id="id274">
+<h4>Example<a class="headerlink" href="#id274" title="Link to this
heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">map_values</span><span
class="p">(</span><span class="k">MAP</span><span class="w"> </span><span
class="err">{</span><span class="s1">'a'</span><span
class="p">:</span><span class="w"> </span><span class="mi">1</span><span
class="p">,</span><span class="w"> </span><span
class="s1">'b'</span><span class="p">:</span><span class [...]
+<span class="c1">----</span>
+<span class="p">[</span><span class="mi">1</span><span class="p">,</span><span
class="w"> </span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]</span>
+
+<span class="k">SELECT</span><span class="w"> </span><span
class="n">map_values</span><span class="p">(</span><span
class="k">map</span><span class="p">([</span><span class="mi">100</span><span
class="p">,</span><span class="w"> </span><span class="mi">5</span><span
class="p">],</span><span class="w"> </span><span class="p">[</span><span
class="mi">42</span><span class="p">,</span><span class="w"> </span><span
class="mi">43</span><span class="p">]));</span>
+<span class="c1">----</span>
+<span class="p">[</span><span class="mi">42</span><span
class="p">,</span><span class="w"> </span><span class="mi">43</span><span
class="p">]</span>
+</pre></div>
+</div>
+</section>
+</section>
+</section>
<section id="hashing-functions">
<h2>Hashing Functions<a class="headerlink" href="#hashing-functions"
title="Link to this heading">¶</a></h2>
<ul class="simple">
@@ -8381,8 +8612,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">digest</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">algorithm</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id268">
-<h4>Arguments<a class="headerlink" href="#id268" title="Link to this
heading">¶</a></h4>
+<section id="id275">
+<h4>Arguments<a class="headerlink" href="#id275" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>algorithm</strong>: String expression specifying algorithm to
use. Must be one of:</p></li>
@@ -8396,8 +8627,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<li><p>blake3</p></li>
</ul>
</section>
-<section id="id269">
-<h4>Example<a class="headerlink" href="#id269" title="Link to this
heading">¶</a></h4>
+<section id="id276">
+<h4>Example<a class="headerlink" href="#id276" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">digest</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">,</span><span class="w">
</span><span class="s1">'sha256'</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">digest</span><span class="p">(</span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"foo"</span><span
class="p">),</span><span class="w"> </span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"sha256"</span><span
class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8414,14 +8645,14 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">md5</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id270">
-<h4>Arguments<a class="headerlink" href="#id270" title="Link to this
heading">¶</a></h4>
+<section id="id277">
+<h4>Arguments<a class="headerlink" href="#id277" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id271">
-<h4>Example<a class="headerlink" href="#id271" title="Link to this
heading">¶</a></h4>
+<section id="id278">
+<h4>Example<a class="headerlink" href="#id278" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">md5</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">-------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">md5</span><span class="p">(</span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"foo"</span><span
class="p">))</span><span class="w"> </span><span
class="o">|</span>
@@ -8438,14 +8669,14 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha224</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id272">
-<h4>Arguments<a class="headerlink" href="#id272" title="Link to this
heading">¶</a></h4>
+<section id="id279">
+<h4>Arguments<a class="headerlink" href="#id279" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id273">
-<h4>Example<a class="headerlink" href="#id273" title="Link to this
heading">¶</a></h4>
+<section id="id280">
+<h4>Example<a class="headerlink" href="#id280" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">sha224</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">sha224</span><span class="p">(</span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"foo"</span><span
class="p">))</span><span class="w"> </span><span
class="o">|</span>
@@ -8462,14 +8693,14 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha256</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id274">
-<h4>Arguments<a class="headerlink" href="#id274" title="Link to this
heading">¶</a></h4>
+<section id="id281">
+<h4>Arguments<a class="headerlink" href="#id281" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id275">
-<h4>Example<a class="headerlink" href="#id275" title="Link to this
heading">¶</a></h4>
+<section id="id282">
+<h4>Example<a class="headerlink" href="#id282" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">sha256</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">sha256</span><span class="p">(</span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"foo"</span><span
class="p">))</span><span class="w"> </span><span
class="o">|</span>
@@ -8486,14 +8717,14 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha384</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id276">
-<h4>Arguments<a class="headerlink" href="#id276" title="Link to this
heading">¶</a></h4>
+<section id="id283">
+<h4>Arguments<a class="headerlink" href="#id283" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id277">
-<h4>Example<a class="headerlink" href="#id277" title="Link to this
heading">¶</a></h4>
+<section id="id284">
+<h4>Example<a class="headerlink" href="#id284" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">sha384</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">sha384</span><span class="p">(</span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"foo"</span><span
class="p">))</span><span class="w"> </span><span
class="o">|</span>
@@ -8510,14 +8741,14 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha512</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id278">
-<h4>Arguments<a class="headerlink" href="#id278" title="Link to this
heading">¶</a></h4>
+<section id="id285">
+<h4>Arguments<a class="headerlink" href="#id285" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String</p></li>
</ul>
</section>
-<section id="id279">
-<h4>Example<a class="headerlink" href="#id279" title="Link to this
heading">¶</a></h4>
+<section id="id286">
+<h4>Example<a class="headerlink" href="#id286" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">sha512</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">-------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">sha512</span><span class="p">(</span><span class="n">Utf8</span><span
class="p">(</span><span class="ss">"foo"</span><span
class="p">))</span><span class="w"> </span><span
class="o">|</span>
@@ -8543,15 +8774,15 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id280">
-<h4>Arguments<a class="headerlink" href="#id280" title="Link to this
heading">¶</a></h4>
+<section id="id287">
+<h4>Arguments<a class="headerlink" href="#id287" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast. The expression can be
a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>datatype</strong>: <a class="reference external"
href="https://docs.rs/arrow/latest/arrow/datatypes/enum.DataType.html";>Arrow
data type</a> name to cast to, as a string. The format is the same as that
returned by [<code class="docutils literal notranslate"><span
class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id281">
-<h4>Example<a class="headerlink" href="#id281" title="Link to this
heading">¶</a></h4>
+<section id="id288">
+<h4>Example<a class="headerlink" href="#id288" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">arrow_cast</span><span class="p">(</span><span
class="o">-</span><span class="mi">5</span><span class="p">,</span><span
class="w"> </span><span class="s1">'Int8'</span><span
class="p">)</span><span class="w"> </span><span class="k">as</span><span
class="w"> </span><span class="n">a</ [...]
<span class="w"> </span><span class="n">arrow_cast</span><span
class="p">(</span><span class="s1">'foo'</span><span
class="p">,</span><span class="w"> </span><span
class="s1">'Dictionary(Int32, Utf8)'</span><span
class="p">)</span><span class="w"> </span><span class="k">as</span><span
class="w"> </span><span class="n">b</span><span class="p">,</span>
<span class="w"> </span><span class="n">arrow_cast</span><span
class="p">(</span><span class="s1">'bar'</span><span
class="p">,</span><span class="w"> </span><span
class="s1">'LargeUtf8'</span><span class="p">)</span><span class="w">
</span><span class="k">as</span><span class="w"> </span><span
class="k">c</span><span class="p">,</span>
@@ -8572,14 +8803,14 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id282">
-<h4>Arguments<a class="headerlink" href="#id282" title="Link to this
heading">¶</a></h4>
+<section id="id289">
+<h4>Arguments<a class="headerlink" href="#id289" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate. The expression can
be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id283">
-<h4>Example<a class="headerlink" href="#id283" title="Link to this
heading">¶</a></h4>
+<section id="id290">
+<h4>Example<a class="headerlink" href="#id290" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">arrow_typeof</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">),</span><span class="w">
</span><span class="n">arrow_typeof</span><span class="p">(</span><span
class="mi">1</span><span class="p">);</span>
<span class="o">+</span><span
class="c1">---------------------------+------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">arrow_typeof</span><span class="p">(</span><span
class="n">Utf8</span><span class="p">(</span><span
class="ss">"foo"</span><span class="p">))</span><span class="w">
</span><span class="o">|</span><span class="w"> </span><span
class="n">arrow_typeof</span><span class="p">(</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">))</span><span class="w"> </span><span class=" [...]
@@ -8599,15 +8830,15 @@ syntax such as <code class="docutils literal
notranslate"><span class="pre">my_s
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">get_field</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id284">
-<h4>Arguments<a class="headerlink" href="#id284" title="Link to this
heading">¶</a></h4>
+<section id="id291">
+<h4>Arguments<a class="headerlink" href="#id291" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: The map or struct to retrieve a field
for.</p></li>
<li><p><strong>expression2</strong>: The field name in the map or struct to
retrieve data for. Must evaluate to a string.</p></li>
</ul>
</section>
-<section id="id285">
-<h4>Example<a class="headerlink" href="#id285" title="Link to this
heading">¶</a></h4>
+<section id="id292">
+<h4>Example<a class="headerlink" href="#id292" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">create</span><span class="w"> </span><span
class="k">table</span><span class="w"> </span><span class="n">t</span><span
class="w"> </span><span class="p">(</span><span class="n">idx</span><span
class="w"> </span><span class="nb">varchar</span><span class="p">,</span><span
class="w"> </span><span class="n">v</span><span class="w"> </span><span c [...]
<span class="o">></span><span class="w"> </span><span
class="k">select</span><span class="w"> </span><span
class="n">struct</span><span class="p">(</span><span class="n">idx</span><span
class="p">,</span><span class="w"> </span><span class="n">v</span><span
class="p">)</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">t</span><span class="w"> </span><span
class="k">as</span><span class="w"> </span><span class="k">c</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
@@ -8640,8 +8871,8 @@ syntax such as <code class="docutils literal
notranslate"><span class="pre">my_s
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">version</span><span
class="p">()</span>
</pre></div>
</div>
-<section id="id286">
-<h4>Example<a class="headerlink" href="#id286" title="Link to this
heading">¶</a></h4>
+<section id="id293">
+<h4>Example<a class="headerlink" href="#id293" title="Link to this
heading">¶</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="k">version</span><span class="p">();</span>
<span class="o">+</span><span
class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">version</span><span class="p">()</span><span class="w">
</span><span class="o">|</span>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
