Google Git
Sign in
apache / spark-website / asf-site / . / site / docs / 4.1.0-preview1 / generated-hash-funcs-examples.html
blob: 652fb27e3b807a885ff84ddec5f1b08f5e20e1ed [file] [log] [blame]
<div class="codehilite"><pre><span></span><code><span class="c1">-- crc32</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">crc32</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------+</span>
<span class="o">|</span><span class="n">crc32</span><span class="p">(</span><span class="n">Spark</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">1557323817</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------+</span>
<span class="c1">-- hash</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">hash</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="nb">array</span><span class="p">(</span><span class="mi">123</span><span class="p">),</span><span class="w"> </span><span class="mi">2</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------+</span>
<span class="o">|</span><span class="n">hash</span><span class="p">(</span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="nb">array</span><span class="p">(</span><span class="mi">123</span><span class="p">),</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="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1321691492</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------+</span>
<span class="c1">-- md5</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">md5</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</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">Spark</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="mi">8</span><span class="n">cde774d6f7333752</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="c1">-- sha</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">sha</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha</span><span class="p">(</span><span class="n">Spark</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="mi">85</span><span class="n">f5955f4b27a9a4c</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="c1">-- sha1</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">sha1</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha1</span><span class="p">(</span><span class="n">Spark</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="mi">85</span><span class="n">f5955f4b27a9a4c</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="c1">-- sha2</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">sha2</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="mi">256</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha2</span><span class="p">(</span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="mi">256</span><span class="p">)</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="o">|</span><span class="mi">529</span><span class="n">bc3b07127ecb7e</span><span class="p">...</span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------+</span>
<span class="c1">-- xxhash64</span>
<span class="k">SELECT</span><span class="w"> </span><span class="n">xxhash64</span><span class="p">(</span><span class="s1">&#39;Spark&#39;</span><span class="p">,</span><span class="w"> </span><span class="nb">array</span><span class="p">(</span><span class="mi">123</span><span class="p">),</span><span class="w"> </span><span class="mi">2</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------+</span>
<span class="o">|</span><span class="n">xxhash64</span><span class="p">(</span><span class="n">Spark</span><span class="p">,</span><span class="w"> </span><span class="nb">array</span><span class="p">(</span><span class="mi">123</span><span class="p">),</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="o">|</span><span class="w"> </span><span class="mi">5602566077635097486</span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------+</span>
</code></pre></div>