Google Git
Sign in
apache / spark-website / asf-site / . / site / docs / 3.5.0 / generated-misc-funcs-examples.html
blob: 7414275ee1bea7c1cb8ec43724f22960ec35a38a [file] [log] [blame]
<div class="codehilite"><pre><span></span><code><span class="c1">-- aes_decrypt</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="s1">&#39;83F16B2AA704794132802D248E6BFD4E380078182D1544813898AC97E709B28A94&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;0000111122223333&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="mi">83</span><span class="n">F16B2AA704794132802D248E6BFD4E380078182D1544813898AC97E709B28A94</span><span class="p">),</span><span class="w"> </span><span class="mi">0000111122223333</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">53</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">72</span><span class="w"> </span><span class="mi">6</span><span class="n">B</span><span class="p">]</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="s1">&#39;6E7CA17BBB468D3084B5744BCA729FB7B2B7BCB8E4472847D02670489D95FA97DBBA7D3210&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;0000111122223333&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;GCM&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="mi">6</span><span class="n">E7CA17BBB468D3084B5744BCA729FB7B2B7BCB8E4472847D02670489D95FA97DBBA7D3210</span><span class="p">),</span><span class="w"> </span><span class="mi">0000111122223333</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">53</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">72</span><span class="w"> </span><span class="mi">6</span><span class="n">B</span><span class="w"> </span><span class="mi">2</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="s1">&#39;3lmwu+Mw0H3fi5NDvcu9lg==&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;1234567890abcdef&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;ECB&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;PKCS&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="mi">3</span><span class="n">lmwu</span><span class="o">+</span><span class="n">Mw0H3fi5NDvcu9lg</span><span class="o">==</span><span class="p">),</span><span class="w"> </span><span class="mi">1234567890</span><span class="n">abcdef</span><span class="p">,</span><span class="w"> </span><span class="n">ECB</span><span class="p">,</span><span class="w"> </span><span class="n">PKCS</span><span class="p">,</span><span class="w"> </span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">53</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">72</span><span class="w"> </span><span class="mi">6</span><span class="n">B</span><span class="w"> </span><span class="mi">2</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="s1">&#39;2NYmDCjgXTbbxGA3/SnJEfFC/JQ7olk2VQWReIAAFKo=&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;1234567890abcdef&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;CBC&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="mi">2</span><span class="n">NYmDCjgXTbbxGA3</span><span class="o">/</span><span class="n">SnJEfFC</span><span class="o">/</span><span class="n">JQ7olk2VQWReIAAFKo</span><span class="o">=</span><span class="p">),</span><span class="w"> </span><span class="mi">1234567890</span><span class="n">abcdef</span><span class="p">,</span><span class="w"> </span><span class="n">CBC</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">41</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">63</span><span class="w"> </span><span class="mi">68</span><span class="w"> </span><span class="mi">6</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="s1">&#39;AAAAAAAAAAAAAAAAAAAAAPSd4mWyMZ5mhvjiAPQJnfg=&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;abcdefghijklmnop12345678ABCDEFGH&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;CBC&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;DEFAULT&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="n">AAAAAAAAAAAAAAAAAAAAAPSd4mWyMZ5mhvjiAPQJnfg</span><span class="o">=</span><span class="p">),</span><span class="w"> </span><span class="n">abcdefghijklmnop12345678ABCDEFGH</span><span class="p">,</span><span class="w"> </span><span class="n">CBC</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">53</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">72</span><span class="w"> </span><span class="mi">6</span><span class="n">B</span><span class="p">]</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="s1">&#39;AAAAAAAAAAAAAAAAQiYi+sTLm7KD9UcZ2nlRdYDe/PX4&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;abcdefghijklmnop12345678ABCDEFGH&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;GCM&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;DEFAULT&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;This is an AAD mixed into the input&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">aes_decrypt</span><span class="p">(</span><span class="n">unbase64</span><span class="p">(</span><span class="n">AAAAAAAAAAAAAAAAQiYi</span><span class="o">+</span><span class="n">sTLm7KD9UcZ2nlRdYDe</span><span class="o">/</span><span class="n">PX4</span><span class="p">),</span><span class="w"> </span><span class="n">abcdefghijklmnop12345678ABCDEFGH</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="n">This</span><span class="w"> </span><span class="k">is</span><span class="w"> </span><span class="n">an</span><span class="w"> </span><span class="n">AAD</span><span class="w"> </span><span class="n">mixed</span><span class="w"> </span><span class="k">into</span><span class="w"> </span><span class="n">the</span><span class="w"> </span><span class="k">input</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">53</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">72</span><span class="w"> </span><span class="mi">6</span><span class="n">B</span><span class="p">]</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="c1">-- aes_encrypt</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">hex</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;0000111122223333&#39;</span><span class="p">));</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
<span class="o">|</span><span class="n">hex</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="mi">0000111122223333</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">,</span><span class="w"> </span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">8</span><span class="n">E146F1E0B7767BC0</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">hex</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="s1">&#39;Spark SQL&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;0000111122223333&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;GCM&#39;</span><span class="p">));</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">hex</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="n">Spark</span><span class="w"> </span><span class="k">SQL</span><span class="p">,</span><span class="w"> </span><span class="mi">0000111122223333</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">,</span><span class="w"> </span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">412</span><span class="n">BE05B0BF4DD0F5</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="s1">&#39;Spark SQL&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;1234567890abcdef&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;ECB&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;PKCS&#39;</span><span class="p">));</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="n">Spark</span><span class="w"> </span><span class="k">SQL</span><span class="p">,</span><span class="w"> </span><span class="mi">1234567890</span><span class="n">abcdef</span><span class="p">,</span><span class="w"> </span><span class="n">ECB</span><span class="p">,</span><span class="w"> </span><span class="n">PKCS</span><span class="p">,</span><span class="w"> </span><span class="p">,</span><span class="w"> </span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="n">lmwu</span><span class="o">+</span><span class="n">Mw0H3fi5NDv</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="s1">&#39;Apache Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;1234567890abcdef&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;CBC&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;DEFAULT&#39;</span><span class="p">));</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="n">Apache</span><span class="w"> </span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="mi">1234567890</span><span class="n">abcdef</span><span class="p">,</span><span class="w"> </span><span class="n">CBC</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">,</span><span class="w"> </span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">Q0sAUoZlAZ8Hn7lti</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;abcdefghijklmnop12345678ABCDEFGH&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;CBC&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;DEFAULT&#39;</span><span class="p">,</span><span class="w"> </span><span class="n">unhex</span><span class="p">(</span><span class="s1">&#39;00000000000000000000000000000000&#39;</span><span class="p">)));</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="n">abcdefghijklmnop12345678ABCDEFGH</span><span class="p">,</span><span class="w"> </span><span class="n">CBC</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="n">unhex</span><span class="p">(</span><span class="mi">00000000000000000000000000000000</span><span class="p">),</span><span class="w"> </span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">AAAAAAAAAAAAAAAAA</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;abcdefghijklmnop12345678ABCDEFGH&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;GCM&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;DEFAULT&#39;</span><span class="p">,</span><span class="w"> </span><span class="n">unhex</span><span class="p">(</span><span class="s1">&#39;000000000000000000000000&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;This is an AAD mixed into the input&#39;</span><span class="p">));</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">base64</span><span class="p">(</span><span class="n">aes_encrypt</span><span class="p">(</span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="n">abcdefghijklmnop12345678ABCDEFGH</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="n">unhex</span><span class="p">(</span><span class="mi">000000000000000000000000</span><span class="p">),</span><span class="w"> </span><span class="n">This</span><span class="w"> </span><span class="k">is</span><span class="w"> </span><span class="n">an</span><span class="w"> </span><span class="n">AAD</span><span class="w"> </span><span class="n">mixed</span><span class="w"> </span><span class="k">into</span><span class="w"> </span><span class="n">the</span><span class="w"> </span><span class="k">input</span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">AAAAAAAAAAAAAAAAQ</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="c1">-- assert_true</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">assert_true</span><span class="p">(</span><span class="mi">0</span><span class="w"> </span><span class="o">&lt;</span><span class="w"> </span><span class="mi">1</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="n">assert_true</span><span class="p">((</span><span class="mi">0</span><span class="w"> </span><span class="o">&lt;</span><span class="w"> </span><span class="mi">1</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;(0 &lt; 1)&#39;</span><span class="w"> </span><span class="k">is</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">true</span><span class="o">!</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="c1">-- bitmap_bit_position</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_bit_position</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="n">bitmap_bit_position</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_bit_position</span><span class="p">(</span><span class="mi">123</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------+</span>
<span class="o">|</span><span class="n">bitmap_bit_position</span><span class="p">(</span><span class="mi">123</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">122</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------+</span>
<span class="c1">-- bitmap_bucket_number</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_bucket_number</span><span class="p">(</span><span class="mi">123</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="o">|</span><span class="n">bitmap_bucket_number</span><span class="p">(</span><span class="mi">123</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_bucket_number</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------+</span>
<span class="o">|</span><span class="n">bitmap_bucket_number</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------+</span>
<span class="c1">-- bitmap_count</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_count</span><span class="p">(</span><span class="n">X</span><span class="w"> </span><span class="s1">&#39;1010&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="n">bitmap_count</span><span class="p">(</span><span class="n">X</span><span class="s1">&#39;1010&#39;</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_count</span><span class="p">(</span><span class="n">X</span><span class="w"> </span><span class="s1">&#39;FFFF&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="n">bitmap_count</span><span class="p">(</span><span class="n">X</span><span class="s1">&#39;FFFF&#39;</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">16</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">bitmap_count</span><span class="p">(</span><span class="n">X</span><span class="w"> </span><span class="s1">&#39;0&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------+</span>
<span class="o">|</span><span class="n">bitmap_count</span><span class="p">(</span><span class="n">X</span><span class="s1">&#39;00&#39;</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------+</span>
<span class="c1">-- current_catalog</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">current_catalog</span><span class="p">();</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="o">|</span><span class="n">current_catalog</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">spark_catalog</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="c1">-- current_database</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">current_database</span><span class="p">();</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="o">|</span><span class="n">current_database</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">default</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="c1">-- current_schema</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">current_schema</span><span class="p">();</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="o">|</span><span class="n">current_database</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">default</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="c1">-- current_user</span>
<span class="k">SELECT</span><span class="w"> </span><span class="k">current_user</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------+</span>
<span class="o">|</span><span class="k">current_user</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">spark</span><span class="o">-</span><span class="n">rm</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------+</span>
<span class="c1">-- equal_null</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">equal_null</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------+</span>
<span class="o">|</span><span class="n">equal_null</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">true</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">equal_null</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;11&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="o">|</span><span class="n">equal_null</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">11</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">false</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">equal_null</span><span class="p">(</span><span class="k">true</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="n">equal_null</span><span class="p">(</span><span class="k">true</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">false</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">equal_null</span><span class="p">(</span><span class="k">NULL</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;abc&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="n">equal_null</span><span class="p">(</span><span class="k">NULL</span><span class="p">,</span><span class="w"> </span><span class="n">abc</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">false</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">equal_null</span><span class="p">(</span><span class="k">NULL</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="n">equal_null</span><span class="p">(</span><span class="k">NULL</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">true</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="c1">-- hll_sketch_estimate</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">hll_sketch_estimate</span><span class="p">(</span><span class="n">hll_sketch_agg</span><span class="p">(</span><span class="n">col</span><span class="p">))</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">VALUES</span><span class="w"> </span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="w"> </span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="w"> </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">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="w"> </span><span class="n">tab</span><span class="p">(</span><span class="n">col</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="n">hll_sketch_estimate</span><span class="p">(</span><span class="n">hll_sketch_agg</span><span class="p">(</span><span class="n">col</span><span class="p">,</span><span class="w"> </span><span class="mi">12</span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="c1">-- hll_union</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">hll_sketch_estimate</span><span class="p">(</span><span class="n">hll_union</span><span class="p">(</span><span class="n">hll_sketch_agg</span><span class="p">(</span><span class="n">col1</span><span class="p">),</span><span class="w"> </span><span class="n">hll_sketch_agg</span><span class="p">(</span><span class="n">col2</span><span class="p">)))</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">VALUES</span><span class="w"> </span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">),</span><span class="w"> </span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">),</span><span class="w"> </span><span class="p">(</span><span class="mi">2</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">2</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">3</span><span class="p">,</span><span class="w"> </span><span class="mi">6</span><span class="p">)</span><span class="w"> </span><span class="n">tab</span><span class="p">(</span><span class="n">col1</span><span class="p">,</span><span class="w"> </span><span class="n">col2</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">hll_sketch_estimate</span><span class="p">(</span><span class="n">hll_union</span><span class="p">(</span><span class="n">hll_sketch_agg</span><span class="p">(</span><span class="n">col1</span><span class="p">,</span><span class="w"> </span><span class="mi">12</span><span class="p">),</span><span class="w"> </span><span class="n">hll_sketch_agg</span><span class="p">(</span><span class="n">col2</span><span class="p">,</span><span class="w"> </span><span class="mi">12</span><span class="p">),</span><span class="w"> </span><span class="k">false</span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">6</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------------------+</span>
<span class="c1">-- input_file_block_length</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">input_file_block_length</span><span class="p">();</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="o">|</span><span class="n">input_file_block_length</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="c1">-- input_file_block_start</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">input_file_block_start</span><span class="p">();</span>
<span class="o">+</span><span class="c1">------------------------+</span>
<span class="o">|</span><span class="n">input_file_block_start</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------+</span>
<span class="c1">-- input_file_name</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">input_file_name</span><span class="p">();</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="o">|</span><span class="n">input_file_name</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="o">|</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------+</span>
<span class="c1">-- java_method</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">java_method</span><span class="p">(</span><span class="s1">&#39;java.util.UUID&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;randomUUID&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------------+</span>
<span class="o">|</span><span class="n">java_method</span><span class="p">(</span><span class="n">java</span><span class="p">.</span><span class="n">util</span><span class="p">.</span><span class="n">UUID</span><span class="p">,</span><span class="w"> </span><span class="n">randomUUID</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">57</span><span class="n">c14e57</span><span class="o">-</span><span class="mi">31</span><span class="n">d4</span><span class="o">-</span><span class="mi">408</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">java_method</span><span class="p">(</span><span class="s1">&#39;java.util.UUID&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;fromString&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;a5cf6c42-0c85-418f-af6c-3e4e5b1328f2&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">java_method</span><span class="p">(</span><span class="n">java</span><span class="p">.</span><span class="n">util</span><span class="p">.</span><span class="n">UUID</span><span class="p">,</span><span class="w"> </span><span class="n">fromString</span><span class="p">,</span><span class="w"> </span><span class="n">a5cf6c42</span><span class="o">-</span><span class="mi">0</span><span class="n">c85</span><span class="o">-</span><span class="mi">418</span><span class="n">f</span><span class="o">-</span><span class="n">af6c</span><span class="o">-</span><span class="mi">3</span><span class="n">e4e5b1328f2</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">a5cf6c42</span><span class="o">-</span><span class="mi">0</span><span class="n">c85</span><span class="o">-</span><span class="mi">418</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------------+</span>
<span class="c1">-- monotonically_increasing_id</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">monotonically_increasing_id</span><span class="p">();</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="n">monotonically_increasing_id</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="c1">-- reflect</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">reflect</span><span class="p">(</span><span class="s1">&#39;java.util.UUID&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;randomUUID&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="n">reflect</span><span class="p">(</span><span class="n">java</span><span class="p">.</span><span class="n">util</span><span class="p">.</span><span class="n">UUID</span><span class="p">,</span><span class="w"> </span><span class="n">randomUUID</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">da3655c7</span><span class="o">-</span><span class="mi">4</span><span class="n">c22</span><span class="o">-</span><span class="mi">43</span><span class="n">e</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">reflect</span><span class="p">(</span><span class="s1">&#39;java.util.UUID&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;fromString&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;a5cf6c42-0c85-418f-af6c-3e4e5b1328f2&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">reflect</span><span class="p">(</span><span class="n">java</span><span class="p">.</span><span class="n">util</span><span class="p">.</span><span class="n">UUID</span><span class="p">,</span><span class="w"> </span><span class="n">fromString</span><span class="p">,</span><span class="w"> </span><span class="n">a5cf6c42</span><span class="o">-</span><span class="mi">0</span><span class="n">c85</span><span class="o">-</span><span class="mi">418</span><span class="n">f</span><span class="o">-</span><span class="n">af6c</span><span class="o">-</span><span class="mi">3</span><span class="n">e4e5b1328f2</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">a5cf6c42</span><span class="o">-</span><span class="mi">0</span><span class="n">c85</span><span class="o">-</span><span class="mi">418</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------------------------------------------------------+</span>
<span class="c1">-- spark_partition_id</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">spark_partition_id</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="n">SPARK_PARTITION_ID</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="c1">-- try_aes_decrypt</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">try_aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="s1">&#39;6E7CA17BBB468D3084B5744BCA729FB7B2B7BCB8E4472847D02670489D95FA97DBBA7D3210&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;0000111122223333&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;GCM&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">try_aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="mi">6</span><span class="n">E7CA17BBB468D3084B5744BCA729FB7B2B7BCB8E4472847D02670489D95FA97DBBA7D3210</span><span class="p">),</span><span class="w"> </span><span class="mi">0000111122223333</span><span class="p">,</span><span class="w"> </span><span class="n">GCM</span><span class="p">,</span><span class="w"> </span><span class="k">DEFAULT</span><span class="p">,</span><span class="w"> </span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="p">[</span><span class="mi">53</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="mi">61</span><span class="w"> </span><span class="mi">72</span><span class="w"> </span><span class="mi">6</span><span class="n">B</span><span class="w"> </span><span class="mi">2</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">try_aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="s1">&#39;----------468D3084B5744BCA729FB7B2B7BCB8E4472847D02670489D95FA97DBBA7D3210&#39;</span><span class="p">),</span><span class="w"> </span><span class="s1">&#39;0000111122223333&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;GCM&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="n">try_aes_decrypt</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="c1">----------468D3084B5744BCA729FB7B2B7BCB8E4472847D02670489D95FA97DBBA7D3210), 0000111122223333, GCM, DEFAULT, )|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="c1">-- typeof</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">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="n">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="c1">---------+</span>
<span class="o">|</span><span class="w"> </span><span class="nb">int</span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------+</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">typeof</span><span class="p">(</span><span class="nb">array</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="n">typeof</span><span class="p">(</span><span class="nb">array</span><span class="p">(</span><span class="mi">1</span><span class="p">))</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------+</span>
<span class="o">|</span><span class="w"> </span><span class="nb">array</span><span class="o">&lt;</span><span class="nb">int</span><span class="o">&gt;|</span>
<span class="o">+</span><span class="c1">----------------+</span>
<span class="c1">-- user</span>
<span class="k">SELECT</span><span class="w"> </span><span class="k">user</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------+</span>
<span class="o">|</span><span class="k">current_user</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">spark</span><span class="o">-</span><span class="n">rm</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------+</span>
<span class="c1">-- uuid</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">uuid</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">uuid</span><span class="p">()</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="n">fb6b1fc0</span><span class="o">-</span><span class="n">c0a1</span><span class="o">-</span><span class="mi">416</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="c1">-- version</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="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="mi">3</span><span class="p">.</span><span class="mi">5</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="n">ce5ddad9903</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
</code></pre></div>