You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2024/09/01 08:40:45 UTC

(datafusion) branch asf-site updated: Publish built docs triggered by 8746e073b7a7ffcf86fac19d5ea1984ee6970d20

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 4ad31bd557 Publish built docs triggered by 8746e073b7a7ffcf86fac19d5ea1984ee6970d20
4ad31bd557 is described below

commit 4ad31bd557840f70ff20f09b085ad4f37125e4f5
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Sun Sep 1 08:40:41 2024 +0000

    Publish built docs triggered by 8746e073b7a7ffcf86fac19d5ea1984ee6970d20
---
 _sources/user-guide/sql/scalar_functions.md.txt |  52 ++++++++
 searchindex.js                                  |   2 +-
 user-guide/sql/scalar_functions.html            | 156 +++++++++++++++++++-----
 3 files changed, 179 insertions(+), 31 deletions(-)

diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index 47e35d2e72..80b61f8242 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3677,6 +3677,8 @@ Unwraps struct fields into columns.
 - [map](#map)
 - [make_map](#make_map)
 - [map_extract](#map_extract)
+- [map_keys](#map_keys)
+- [map_values](#map_values)
 
 ### `map`
 
@@ -3765,6 +3767,56 @@ SELECT map_extract(MAP {'a': 1, 'b': NULL, 'c': 3}, 'a');
 
 - 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]
+```
+
 ## Hashing Functions
 
 - [digest](#digest)
diff --git a/searchindex.js b/searchindex.js
index 0e435090fc..f7e6734018 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[45, "op-neq"]], "!~": [[45, "op-re-not-match"]], "!~*": [[45, "op-re-not-match-i"]], "!~~": [[45, "id18"]], "!~~*": [[45, "id19"]], "#": [[45, "op-bit-xor"]], "%": [[45, "op-modulo"]], "&": [[45, "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"]], "*": [[45, "op-multiply"]], "+": [[45, "op-plus"]], "-": [[45, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[45, "op-neq"]], "!~": [[45, "op-re-not-match"]], "!~*": [[45, "op-re-not-match-i"]], "!~~": [[45, "id18"]], "!~~*": [[45, "id19"]], "#": [[45, "op-bit-xor"]], "%": [[45, "op-modulo"]], "&": [[45, "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"]], "*": [[45, "op-multiply"]], "+": [[45, "op-plus"]], "-": [[45, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 093049dbc9..a8d184aec9 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -3815,6 +3815,48 @@
      </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="#id230">
+       Arguments
+      </a>
+     </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id231">
+       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="#id232">
+       Arguments
+      </a>
+     </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id233">
+       Example
+      </a>
+     </li>
+    </ul>
+   </li>
   </ul>
  </li>
  <li class="toc-h2 nav-item toc-entry">
@@ -3832,7 +3874,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id230">
+      <a class="reference internal nav-link" href="#id234">
        Arguments
       </a>
      </li>
@@ -3848,7 +3890,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id231">
+      <a class="reference internal nav-link" href="#id235">
        Arguments
       </a>
      </li>
@@ -3864,7 +3906,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id232">
+      <a class="reference internal nav-link" href="#id236">
        Arguments
       </a>
      </li>
@@ -3880,7 +3922,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id233">
+      <a class="reference internal nav-link" href="#id237">
        Arguments
       </a>
      </li>
@@ -3896,7 +3938,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id234">
+      <a class="reference internal nav-link" href="#id238">
        Arguments
       </a>
      </li>
@@ -3912,7 +3954,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id235">
+      <a class="reference internal nav-link" href="#id239">
        Arguments
       </a>
      </li>
@@ -3935,12 +3977,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id236">
+      <a class="reference internal nav-link" href="#id240">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id237">
+      <a class="reference internal nav-link" href="#id241">
        Example
       </a>
      </li>
@@ -3956,12 +3998,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id238">
+      <a class="reference internal nav-link" href="#id242">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id239">
+      <a class="reference internal nav-link" href="#id243">
        Example
       </a>
      </li>
@@ -7848,6 +7890,8 @@ Can be a constant, column, or function, and any combination of object operators.
 <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>
@@ -7941,6 +7985,58 @@ string operators, or a named expression of previous listed.</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="id230">
+<h4>Arguments<a class="headerlink" href="#id230" 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="id231">
+<h4>Example<a class="headerlink" href="#id231" 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">&#39;a&#39;</span><span class="p">:</span> <span class="mi">1</span><span class="p">,</span> <span class="s1">&#39;b&#39;</span><span class="p">:</span> <span class="n">NULL</span><span class="p">,</span> <span class="s1">&#39;c&#39;</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="id232">
+<h4>Arguments<a class="headerlink" href="#id232" 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="id233">
+<h4>Example<a class="headerlink" href="#id233" 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">&#39;a&#39;</span><span class="p">:</span> <span class="mi">1</span><span class="p">,</span> <span class="s1">&#39;b&#39;</span><span class="p">:</span> <span class="n">NULL</span><span class="p">,</span> <span class="s1">&#39;c&#39;</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="hashing-functions">
 <h2>Hashing Functions<a class="headerlink" href="#hashing-functions" title="Link to this heading">¶</a></h2>
@@ -7958,8 +8054,8 @@ string operators, or a named expression of previous listed.</p></li>
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">digest</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="n">algorithm</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id230">
-<h4>Arguments<a class="headerlink" href="#id230" title="Link to this heading">¶</a></h4>
+<section id="id234">
+<h4>Arguments<a class="headerlink" href="#id234" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -7985,8 +8081,8 @@ Must be one of:</p>
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">md5</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id231">
-<h4>Arguments<a class="headerlink" href="#id231" title="Link to this heading">¶</a></h4>
+<section id="id235">
+<h4>Arguments<a class="headerlink" href="#id235" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -7999,8 +8095,8 @@ Can be a constant, column, or function, and any combination of string operators.
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha224</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id232">
-<h4>Arguments<a class="headerlink" href="#id232" title="Link to this heading">¶</a></h4>
+<section id="id236">
+<h4>Arguments<a class="headerlink" href="#id236" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -8013,8 +8109,8 @@ Can be a constant, column, or function, and any combination of string operators.
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha256</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id233">
-<h4>Arguments<a class="headerlink" href="#id233" title="Link to this heading">¶</a></h4>
+<section id="id237">
+<h4>Arguments<a class="headerlink" href="#id237" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -8027,8 +8123,8 @@ Can be a constant, column, or function, and any combination of string operators.
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha384</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id234">
-<h4>Arguments<a class="headerlink" href="#id234" title="Link to this heading">¶</a></h4>
+<section id="id238">
+<h4>Arguments<a class="headerlink" href="#id238" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -8041,8 +8137,8 @@ Can be a constant, column, or function, and any combination of string operators.
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha512</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id235">
-<h4>Arguments<a class="headerlink" href="#id235" title="Link to this heading">¶</a></h4>
+<section id="id239">
+<h4>Arguments<a class="headerlink" href="#id239" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -8062,8 +8158,8 @@ Can be a constant, column, or function, and any combination of string operators.
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_cast</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="n">datatype</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id236">
-<h4>Arguments<a class="headerlink" href="#id236" title="Link to this heading">¶</a></h4>
+<section id="id240">
+<h4>Arguments<a class="headerlink" href="#id240" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to cast.
 Can be a constant, column, or function, and any combination of arithmetic or
@@ -8072,8 +8168,8 @@ string operators.</p></li>
 to cast to, as a string. The format is the same as that returned by [<code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code>]</p></li>
 </ul>
 </section>
-<section id="id237">
-<h4>Example<a class="headerlink" href="#id237" title="Link to this heading">¶</a></h4>
+<section id="id241">
+<h4>Example<a class="headerlink" href="#id241" title="Link to this heading">¶</a></h4>
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="o">&gt;</span> <span class="n">select</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="s1">&#39;Int8&#39;</span><span class="p">)</span> <span class="k">as</span> <span class="n">a</span><span class="p">,</span>
   <span class="n">arrow_cast</span><span class="p">(</span><span class="s1">&#39;foo&#39;</span><span class="p">,</span> <span class="s1">&#39;Dictionary(Int32, Utf8)&#39;</span><span class="p">)</span> <span class="k">as</span> <span class="n">b</span><span class="p">,</span>
   <span class="n">arrow_cast</span><span class="p">(</span><span class="s1">&#39;bar&#39;</span><span class="p">,</span> <span class="s1">&#39;LargeUtf8&#39;</span><span class="p">)</span> <span class="k">as</span> <span class="n">c</span><span class="p">,</span>
@@ -8095,16 +8191,16 @@ to cast to, as a string. The format is the same as that returned by [<code class
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id238">
-<h4>Arguments<a class="headerlink" href="#id238" title="Link to this heading">¶</a></h4>
+<section id="id242">
+<h4>Arguments<a class="headerlink" href="#id242" title="Link to this heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to evaluate.
 Can be a constant, column, or function, and any combination of arithmetic or
 string operators.</p></li>
 </ul>
 </section>
-<section id="id239">
-<h4>Example<a class="headerlink" href="#id239" title="Link to this heading">¶</a></h4>
+<section id="id243">
+<h4>Example<a class="headerlink" href="#id243" title="Link to this heading">¶</a></h4>
 <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="o">&gt;</span> <span class="n">select</span> <span class="n">arrow_typeof</span><span class="p">(</span><span class="s1">&#39;foo&#39;</span><span class="p">),</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="o">|</span> <span class="n">arrow_typeof</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="s2">&quot;foo&quot;</span><span class="p">))</span> <span class="o">|</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="o">|</span>


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org