| <div class="codehilite"><pre><span></span><code><span class="c1">-- any</span> |
| <span class="k">SELECT</span> <span class="k">any</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">)</span> <span class="k">AS</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="k">any</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</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="k">any</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">)</span> <span class="k">AS</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="k">any</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</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="k">any</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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="k">any</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="k">false</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- approx_count_distinct</span> |
| <span class="k">SELECT</span> <span class="n">approx_count_distinct</span><span class="p">(</span><span class="n">col1</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</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="n">tab</span><span class="p">(</span><span class="n">col1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------------------+</span> |
| <span class="o">|</span><span class="n">approx_count_distinct</span><span class="p">(</span><span class="n">col1</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="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------+</span> |
| |
| <span class="c1">-- approx_percentile</span> |
| <span class="k">SELECT</span> <span class="n">approx_percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="nb">array</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">4</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">),</span> <span class="mi">100</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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">approx_percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="nb">array</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">4</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">),</span> <span class="mi">100</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------------------------+</span> |
| <span class="o">|</span> <span class="p">[</span><span class="mi">1</span><span class="p">,</span> <span class="mi">1</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="k">SELECT</span> <span class="n">approx_percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">100</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">6</span><span class="p">),</span> <span class="p">(</span><span class="mi">7</span><span class="p">),</span> <span class="p">(</span><span class="mi">9</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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">approx_percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">CAST</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">),</span> <span class="mi">100</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------+</span> |
| <span class="o">|</span> <span class="mi">7</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------+</span> |
| |
| <span class="c1">-- avg</span> |
| <span class="k">SELECT</span> <span class="k">avg</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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="k">avg</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="mi">2</span><span class="p">.</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="k">avg</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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="k">avg</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- bit_and</span> |
| <span class="k">SELECT</span> <span class="n">bit_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">)</span> <span class="k">AS</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">bit_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</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">-- bit_or</span> |
| <span class="k">SELECT</span> <span class="n">bit_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">)</span> <span class="k">AS</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">bit_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span> <span class="mi">7</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- bit_xor</span> |
| <span class="k">SELECT</span> <span class="n">bit_xor</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">)</span> <span class="k">AS</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">bit_xor</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span> <span class="mi">6</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- bool_and</span> |
| <span class="k">SELECT</span> <span class="n">bool_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">)</span> <span class="k">AS</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">bool_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</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="n">bool_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">)</span> <span class="k">AS</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">bool_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</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="n">bool_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">)</span> <span class="k">AS</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">bool_and</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span> <span class="k">false</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="c1">-- bool_or</span> |
| <span class="k">SELECT</span> <span class="n">bool_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">)</span> <span class="k">AS</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">bool_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</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="n">bool_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">)</span> <span class="k">AS</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">bool_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</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="n">bool_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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">bool_or</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span> <span class="k">false</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- collect_list</span> |
| <span class="k">SELECT</span> <span class="n">collect_list</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">)</span> <span class="k">AS</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">collect_list</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</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="mi">1</span><span class="p">]</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| |
| <span class="c1">-- collect_set</span> |
| <span class="k">SELECT</span> <span class="n">collect_set</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">)</span> <span class="k">AS</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">collect_set</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</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="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="c1">-- corr</span> |
| <span class="k">SELECT</span> <span class="n">corr</span><span class="p">(</span><span class="n">c1</span><span class="p">,</span> <span class="n">c2</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">3</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">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">6</span><span class="p">,</span> <span class="mi">4</span><span class="p">)</span> <span class="k">as</span> <span class="n">tab</span><span class="p">(</span><span class="n">c1</span><span class="p">,</span> <span class="n">c2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------+</span> |
| <span class="o">|</span><span class="n">corr</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">c1</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">),</span> <span class="k">CAST</span><span class="p">(</span><span class="n">c2</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------+</span> |
| <span class="o">|</span> <span class="mi">0</span><span class="p">.</span><span class="mi">8660254037844387</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------+</span> |
| |
| <span class="c1">-- count</span> |
| <span class="k">SELECT</span> <span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">count</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="mi">4</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">count</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">count</span><span class="p">(</span><span class="n">col</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="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">count</span><span class="p">(</span><span class="k">DISTINCT</span> <span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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="k">count</span><span class="p">(</span><span class="k">DISTINCT</span> <span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| <span class="o">|</span> <span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| |
| <span class="c1">-- count_if</span> |
| <span class="k">SELECT</span> <span class="n">count_if</span><span class="p">(</span><span class="n">col</span> <span class="o">%</span> <span class="mi">2</span> <span class="o">=</span> <span class="mi">0</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">count_if</span><span class="p">(((</span><span class="n">col</span> <span class="o">%</span> <span class="mi">2</span><span class="p">)</span> <span class="o">=</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="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">count_if</span><span class="p">(</span><span class="n">col</span> <span class="k">IS</span> <span class="k">NULL</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">count_if</span><span class="p">((</span><span class="n">col</span> <span class="k">IS</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="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------+</span> |
| |
| <span class="c1">-- count_min_sketch</span> |
| <span class="k">SELECT</span> <span class="n">hex</span><span class="p">(</span><span class="n">count_min_sketch</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="n">d</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="n">d</span><span class="p">,</span> <span class="mi">1</span><span class="p">))</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">)</span> <span class="k">AS</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">hex</span><span class="p">(</span><span class="n">count_min_sketch</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</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="mi">00000001000000000</span><span class="p">...</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------+</span> |
| |
| <span class="c1">-- covar_pop</span> |
| <span class="k">SELECT</span> <span class="n">covar_pop</span><span class="p">(</span><span class="n">c1</span><span class="p">,</span> <span class="n">c2</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</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">3</span><span class="p">)</span> <span class="k">AS</span> <span class="n">tab</span><span class="p">(</span><span class="n">c1</span><span class="p">,</span> <span class="n">c2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">covar_pop</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">c1</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">),</span> <span class="k">CAST</span><span class="p">(</span><span class="n">c2</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------------------------+</span> |
| <span class="o">|</span> <span class="mi">0</span><span class="p">.</span><span class="mi">6666666666666666</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------------------------+</span> |
| |
| <span class="c1">-- covar_samp</span> |
| <span class="k">SELECT</span> <span class="n">covar_samp</span><span class="p">(</span><span class="n">c1</span><span class="p">,</span> <span class="n">c2</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</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">3</span><span class="p">)</span> <span class="k">AS</span> <span class="n">tab</span><span class="p">(</span><span class="n">c1</span><span class="p">,</span> <span class="n">c2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">covar_samp</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">c1</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">),</span> <span class="k">CAST</span><span class="p">(</span><span class="n">c2</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| |
| <span class="c1">-- every</span> |
| <span class="k">SELECT</span> <span class="k">every</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">)</span> <span class="k">AS</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="k">every</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</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="k">every</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">)</span> <span class="k">AS</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="k">every</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</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="k">every</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">)</span> <span class="k">AS</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="k">every</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span> <span class="k">false</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="c1">-- first</span> |
| <span class="k">SELECT</span> <span class="k">first</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">first</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span> <span class="mi">10</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">first</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">first</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">first</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">true</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">first</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span> <span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="c1">-- first_value</span> |
| <span class="k">SELECT</span> <span class="n">first_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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">first_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span> <span class="mi">10</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">first_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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">first_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">first_value</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">true</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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">first_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span> <span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="c1">-- kurtosis</span> |
| <span class="k">SELECT</span> <span class="n">kurtosis</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="o">-</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="o">-</span><span class="mi">20</span><span class="p">),</span> <span class="p">(</span><span class="mi">100</span><span class="p">),</span> <span class="p">(</span><span class="mi">1000</span><span class="p">)</span> <span class="k">AS</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">kurtosis</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span> <span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">7014368047529618</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">kurtosis</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">100</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">)</span> <span class="k">as</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">kurtosis</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span> <span class="mi">0</span><span class="p">.</span><span class="mi">19432323191698986</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="c1">-- last</span> |
| <span class="k">SELECT</span> <span class="k">last</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">last</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span> <span class="mi">20</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">last</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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="k">last</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">last</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">true</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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="k">last</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span> <span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="c1">-- last_value</span> |
| <span class="k">SELECT</span> <span class="n">last_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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">last_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| <span class="o">|</span> <span class="mi">20</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">last_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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">last_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| <span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">last_value</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">true</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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">last_value</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| <span class="o">|</span> <span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| |
| <span class="c1">-- max</span> |
| <span class="k">SELECT</span> <span class="k">max</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">50</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">max</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="mi">50</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- max_by</span> |
| <span class="k">SELECT</span> <span class="n">max_by</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">((</span><span class="s1">'a'</span><span class="p">,</span> <span class="mi">10</span><span class="p">)),</span> <span class="p">((</span><span class="s1">'b'</span><span class="p">,</span> <span class="mi">50</span><span class="p">)),</span> <span class="p">((</span><span class="s1">'c'</span><span class="p">,</span> <span class="mi">20</span><span class="p">))</span> <span class="k">AS</span> <span class="n">tab</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="n">max_by</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span> <span class="n">b</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- mean</span> |
| <span class="k">SELECT</span> <span class="n">mean</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">mean</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span> <span class="mi">2</span><span class="p">.</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="n">mean</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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">mean</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="c1">-- min</span> |
| <span class="k">SELECT</span> <span class="k">min</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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="k">min</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</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">-- min_by</span> |
| <span class="k">SELECT</span> <span class="n">min_by</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">((</span><span class="s1">'a'</span><span class="p">,</span> <span class="mi">10</span><span class="p">)),</span> <span class="p">((</span><span class="s1">'b'</span><span class="p">,</span> <span class="mi">50</span><span class="p">)),</span> <span class="p">((</span><span class="s1">'c'</span><span class="p">,</span> <span class="mi">20</span><span class="p">))</span> <span class="k">AS</span> <span class="n">tab</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="n">min_by</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span> <span class="n">a</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- percentile</span> |
| <span class="k">SELECT</span> <span class="n">percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">3</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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">percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">CAST</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">3</span> <span class="k">AS</span> <span class="n">DOUBLE</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="mi">3</span><span class="p">.</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="n">percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="nb">array</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">25</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">75</span><span class="p">))</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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">percentile</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="nb">array</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">25</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">75</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="p">[</span><span class="mi">2</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">7</span><span class="p">.</span><span class="mi">5</span><span class="p">]</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------------+</span> |
| |
| <span class="c1">-- percentile_approx</span> |
| <span class="k">SELECT</span> <span class="n">percentile_approx</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="nb">array</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">4</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">),</span> <span class="mi">100</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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">percentile_approx</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="nb">array</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">4</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">),</span> <span class="mi">100</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------------------------+</span> |
| <span class="o">|</span> <span class="p">[</span><span class="mi">1</span><span class="p">,</span> <span class="mi">1</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="k">SELECT</span> <span class="n">percentile_approx</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">100</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">6</span><span class="p">),</span> <span class="p">(</span><span class="mi">7</span><span class="p">),</span> <span class="p">(</span><span class="mi">9</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">)</span> <span class="k">AS</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">percentile_approx</span><span class="p">(</span><span class="n">col</span><span class="p">,</span> <span class="k">CAST</span><span class="p">(</span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">),</span> <span class="mi">100</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------+</span> |
| <span class="o">|</span> <span class="mi">7</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------+</span> |
| |
| <span class="c1">-- skewness</span> |
| <span class="k">SELECT</span> <span class="n">skewness</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="o">-</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="o">-</span><span class="mi">20</span><span class="p">),</span> <span class="p">(</span><span class="mi">100</span><span class="p">),</span> <span class="p">(</span><span class="mi">1000</span><span class="p">)</span> <span class="k">AS</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">skewness</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">1135657469022013</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="k">SELECT</span> <span class="n">skewness</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="o">-</span><span class="mi">1000</span><span class="p">),</span> <span class="p">(</span><span class="o">-</span><span class="mi">100</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">20</span><span class="p">)</span> <span class="k">AS</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">skewness</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span> <span class="o">-</span><span class="mi">1</span><span class="p">.</span><span class="mi">1135657469022011</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="c1">-- some</span> |
| <span class="k">SELECT</span> <span class="k">some</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">)</span> <span class="k">AS</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="k">some</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</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="k">some</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="k">true</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">)</span> <span class="k">AS</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="k">some</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</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="k">some</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">false</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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="k">some</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span> <span class="k">false</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="c1">-- std</span> |
| <span class="k">SELECT</span> <span class="n">std</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">std</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------+</span> |
| |
| <span class="c1">-- stddev</span> |
| <span class="k">SELECT</span> <span class="n">stddev</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">stddev</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------+</span> |
| |
| <span class="c1">-- stddev_pop</span> |
| <span class="k">SELECT</span> <span class="n">stddev_pop</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">stddev_pop</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| <span class="o">|</span> <span class="mi">0</span><span class="p">.</span><span class="mi">816496580927726</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| |
| <span class="c1">-- stddev_samp</span> |
| <span class="k">SELECT</span> <span class="n">stddev_samp</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">stddev_samp</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------+</span> |
| |
| <span class="c1">-- sum</span> |
| <span class="k">SELECT</span> <span class="k">sum</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">5</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">15</span><span class="p">)</span> <span class="k">AS</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="k">sum</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="mi">30</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">sum</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">),</span> <span class="p">(</span><span class="mi">15</span><span class="p">)</span> <span class="k">AS</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="k">sum</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="mi">25</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span> <span class="k">sum</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="k">NULL</span><span class="p">),</span> <span class="p">(</span><span class="k">NULL</span><span class="p">)</span> <span class="k">AS</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="k">sum</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span> <span class="k">null</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- var_pop</span> |
| <span class="k">SELECT</span> <span class="n">var_pop</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">var_pop</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| <span class="o">|</span> <span class="mi">0</span><span class="p">.</span><span class="mi">6666666666666666</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| |
| <span class="c1">-- var_samp</span> |
| <span class="k">SELECT</span> <span class="n">var_samp</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">var_samp</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="c1">-- variance</span> |
| <span class="k">SELECT</span> <span class="n">variance</span><span class="p">(</span><span class="n">col</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">),</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="k">AS</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">variance</span><span class="p">(</span><span class="k">CAST</span><span class="p">(</span><span class="n">col</span> <span class="k">AS</span> <span class="n">DOUBLE</span><span class="p">))</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span> <span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| </code></pre></div> |
