You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2025/07/31 20:45:54 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by 2a90ff606d697ca77c67da2ce72e40f2e67119e3
This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 4ee5a437de Publish built docs triggered by 2a90ff606d697ca77c67da2ce72e40f2e67119e3
4ee5a437de is described below
commit 4ee5a437de74d1ccaaa37d7c0d71a5c59de32dc1
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Thu Jul 31 20:45:49 2025 +0000
Publish built docs triggered by 2a90ff606d697ca77c67da2ce72e40f2e67119e3
---
_sources/user-guide/sql/aggregate_functions.md.txt | 205 +++++++++++
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 376 +++++++++++++++++----
3 files changed, 519 insertions(+), 64 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt b/_sources/user-guide/sql/aggregate_functions.md.txt
index 774a4fae6b..88241770a4 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -618,6 +618,29 @@ regr_avgx(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table daily_sales(day int, total_sales int) as values (1,100), (2,150), (3,200), (4,NULL), (5,250);
+select * from daily_sales;
++-----+-------------+
+| day | total_sales |
+| --- | ----------- |
+| 1 | 100 |
+| 2 | 150 |
+| 3 | 200 |
+| 4 | NULL |
+| 5 | 250 |
++-----+-------------+
+
+SELECT regr_avgx(total_sales, day) AS avg_day FROM daily_sales;
++----------+
+| avg_day |
++----------+
+| 2.75 |
++----------+
+```
+
### `regr_avgy`
Computes the average of the dependent variable (output) expression_y for the non-null paired data points.
@@ -631,6 +654,30 @@ regr_avgy(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table daily_temperature(day int, temperature int) as values (1,30), (2,32), (3, NULL), (4,35), (5,36);
+select * from daily_temperature;
++-----+-------------+
+| day | temperature |
+| --- | ----------- |
+| 1 | 30 |
+| 2 | 32 |
+| 3 | NULL |
+| 4 | 35 |
+| 5 | 36 |
++-----+-------------+
+
+-- temperature as Dependent Variable(Y), day as Independent Variable(X)
+SELECT regr_avgy(temperature, day) AS avg_temperature FROM daily_temperature;
++-----------------+
+| avg_temperature |
++-----------------+
+| 33.25 |
++-----------------+
+```
+
### `regr_count`
Counts the number of non-null paired data points.
@@ -644,6 +691,29 @@ regr_count(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table daily_metrics(day int, user_signups int) as values (1,100), (2,120), (3, NULL), (4,110), (5,NULL);
+select * from daily_metrics;
++-----+---------------+
+| day | user_signups |
+| --- | ------------- |
+| 1 | 100 |
+| 2 | 120 |
+| 3 | NULL |
+| 4 | 110 |
+| 5 | NULL |
++-----+---------------+
+
+SELECT regr_count(user_signups, day) AS valid_pairs FROM daily_metrics;
++-------------+
+| valid_pairs |
++-------------+
+| 3 |
++-------------+
+```
+
### `regr_intercept`
Computes the y-intercept of the linear regression line. For the equation (y = kx + b), this function returns b.
@@ -657,6 +727,30 @@ regr_intercept(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table weekly_performance(week int, productivity_score int) as values (1,60), (2,65), (3, 70), (4,75), (5,80);
+select * from weekly_performance;
++------+---------------------+
+| week | productivity_score |
+| ---- | ------------------- |
+| 1 | 60 |
+| 2 | 65 |
+| 3 | 70 |
+| 4 | 75 |
+| 5 | 80 |
++------+---------------------+
+
+SELECT regr_intercept(productivity_score, week) AS intercept FROM weekly_performance;
++----------+
+|intercept|
+|intercept |
++----------+
+| 55 |
++----------+
+```
+
### `regr_r2`
Computes the square of the correlation coefficient between the independent and dependent variables.
@@ -670,6 +764,29 @@ regr_r2(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table weekly_performance(day int ,user_signups int) as values (1,60), (2,65), (3, 70), (4,75), (5,80);
+select * from weekly_performance;
++-----+--------------+
+| day | user_signups |
++-----+--------------+
+| 1 | 60 |
+| 2 | 65 |
+| 3 | 70 |
+| 4 | 75 |
+| 5 | 80 |
++-----+--------------+
+
+SELECT regr_r2(user_signups, day) AS r_squared FROM weekly_performance;
++---------+
+|r_squared|
++---------+
+| 1.0 |
++---------+
+```
+
### `regr_slope`
Returns the slope of the linear regression line for non-null pairs in aggregate columns. Given input column Y and X: regr_slope(Y, X) returns the slope (k in Y = k\*X + b) using minimal RSS fitting.
@@ -683,6 +800,29 @@ regr_slope(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table weekly_performance(day int, user_signups int) as values (1,60), (2,65), (3, 70), (4,75), (5,80);
+select * from weekly_performance;
++-----+--------------+
+| day | user_signups |
++-----+--------------+
+| 1 | 60 |
+| 2 | 65 |
+| 3 | 70 |
+| 4 | 75 |
+| 5 | 80 |
++-----+--------------+
+
+SELECT regr_slope(user_signups, day) AS slope FROM weekly_performance;
++--------+
+| slope |
++--------+
+| 5.0 |
++--------+
+```
+
### `regr_sxx`
Computes the sum of squares of the independent variable.
@@ -696,6 +836,29 @@ regr_sxx(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table study_hours(student_id int, hours int, test_score int) as values (1,2,55), (2,4,65), (3,6,75), (4,8,85), (5,10,95);
+select * from study_hours;
++------------+-------+------------+
+| student_id | hours | test_score |
++------------+-------+------------+
+| 1 | 2 | 55 |
+| 2 | 4 | 65 |
+| 3 | 6 | 75 |
+| 4 | 8 | 85 |
+| 5 | 10 | 95 |
++------------+-------+------------+
+
+SELECT regr_sxx(test_score, hours) AS sxx FROM study_hours;
++------+
+| sxx |
++------+
+| 40.0 |
++------+
+```
+
### `regr_sxy`
Computes the sum of products of paired data points.
@@ -709,6 +872,27 @@ regr_sxy(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table employee_productivity(week int, productivity_score int) as values(1,60), (2,65), (3,70);
+select * from employee_productivity;
++------+--------------------+
+| week | productivity_score |
++------+--------------------+
+| 1 | 60 |
+| 2 | 65 |
+| 3 | 70 |
++------+--------------------+
+
+SELECT regr_sxy(productivity_score, week) AS sum_product_deviations FROM employee_productivity;
++------------------------+
+| sum_product_deviations |
++------------------------+
+| 10.0 |
++------------------------+
+```
+
### `regr_syy`
Computes the sum of squares of the dependent variable.
@@ -722,6 +906,27 @@ regr_syy(expression_y, expression_x)
- **expression_y**: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **expression_x**: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.
+#### Example
+
+```sql
+create table employee_productivity(week int, productivity_score int) as values (1,60), (2,65), (3,70);
+select * from employee_productivity;
++------+--------------------+
+| week | productivity_score |
++------+--------------------+
+| 1 | 60 |
+| 2 | 65 |
+| 3 | 70 |
++------+--------------------+
+
+SELECT regr_syy(productivity_score, week) AS sum_squares_y FROM employee_productivity;
++---------------+
+| sum_squares_y |
++---------------+
+| 50.0 |
++---------------+
+```
+
### `stddev`
Returns the standard deviation of a set of numbers.
diff --git a/searchindex.js b/searchindex.js
index 01dbec08a1..3c28f61af5 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[56,"op-neq"]],"!~":[[56,"op-re-not-match"]],"!~*":[[56,"op-re-not-match-i"]],"!~~":[[56,"id19"]],"!~~*":[[56,"id20"]],"#":[[56,"op-bit-xor"]],"%":[[56,"op-modulo"]],"&":[[56,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[56,"op-multiply"]],"+":[[56,"op-plus"]],"-":[[56,"op-minus"]],"/":[[56,"op-divide"]],"<":[[56,"op-lt"]],"< [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[56,"op-neq"]],"!~":[[56,"op-re-not-match"]],"!~*":[[56,"op-re-not-match-i"]],"!~~":[[56,"id19"]],"!~~*":[[56,"id20"]],"#":[[56,"op-bit-xor"]],"%":[[56,"op-modulo"]],"&":[[56,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[56,"op-multiply"]],"+":[[56,"op-plus"]],"-":[[56,"op-minus"]],"/":[[56,"op-divide"]],"<":[[56,"op-lt"]],"< [...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html b/user-guide/sql/aggregate_functions.html
index 282427bcff..aff2b83430 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -1072,6 +1072,11 @@
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id42">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1084,10 +1089,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id42">
+ <a class="reference internal nav-link" href="#id43">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id44">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1100,10 +1110,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id43">
+ <a class="reference internal nav-link" href="#id45">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id46">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1116,10 +1131,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id44">
+ <a class="reference internal nav-link" href="#id47">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id48">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1132,10 +1152,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id45">
+ <a class="reference internal nav-link" href="#id49">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id50">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1148,10 +1173,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id46">
+ <a class="reference internal nav-link" href="#id51">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id52">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1164,10 +1194,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id47">
+ <a class="reference internal nav-link" href="#id53">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id54">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1180,10 +1215,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id48">
+ <a class="reference internal nav-link" href="#id55">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id56">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1196,10 +1236,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id49">
+ <a class="reference internal nav-link" href="#id57">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id58">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1212,17 +1257,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id50">
+ <a class="reference internal nav-link" href="#id59">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id51">
+ <a class="reference internal nav-link" href="#id60">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id52">
+ <a class="reference internal nav-link" href="#id61">
Aliases
</a>
</li>
@@ -1238,12 +1283,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id53">
+ <a class="reference internal nav-link" href="#id62">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id54">
+ <a class="reference internal nav-link" href="#id63">
Example
</a>
</li>
@@ -1275,12 +1320,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id55">
+ <a class="reference internal nav-link" href="#id64">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id56">
+ <a class="reference internal nav-link" href="#id65">
Example
</a>
</li>
@@ -1296,12 +1341,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id57">
+ <a class="reference internal nav-link" href="#id66">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id58">
+ <a class="reference internal nav-link" href="#id67">
Example
</a>
</li>
@@ -1317,12 +1362,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id59">
+ <a class="reference internal nav-link" href="#id68">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id60">
+ <a class="reference internal nav-link" href="#id69">
Example
</a>
</li>
@@ -1338,12 +1383,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id61">
+ <a class="reference internal nav-link" href="#id70">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id62">
+ <a class="reference internal nav-link" href="#id71">
Example
</a>
</li>
@@ -2029,6 +2074,29 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id42">
+<h4>Example<a class="headerlink" href="#id42" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">daily_sales</span><span class="p">(</span><span class="k">day</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">total_sales</span><span class="w"> </span><span class="nb">int</span><span class="p">)</span><span class="w" [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">daily_sales</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-----+-------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="k">day</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">total_sales</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="c1">--- | ----------- |</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">100</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">150</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">200</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">250</span><span class="w"> </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">regr_avgx</span><span class="p">(</span><span class="n">total_sales</span><span class="p">,</span><span class="w"> </span><span class="k">day</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">avg_day</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">daily_sales</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">avg_day</span><span class="w"> </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="p">.</span><span class="mi">75</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-avgy">
<h3><code class="docutils literal notranslate"><span class="pre">regr_avgy</span></code><a class="headerlink" href="#regr-avgy" title="Link to this heading">¶</a></h3>
@@ -2036,13 +2104,37 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_avgy</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id42">
-<h4>Arguments<a class="headerlink" href="#id42" title="Link to this heading">¶</a></h4>
+<section id="id43">
+<h4>Arguments<a class="headerlink" href="#id43" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id44">
+<h4>Example<a class="headerlink" href="#id44" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">daily_temperature</span><span class="p">(</span><span class="k">day</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">temperature</span><span class="w"> </span><span class="nb">int</span><span class="p">)</span><span cla [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">daily_temperature</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-----+-------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="k">day</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">temperature</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="c1">--- | ----------- |</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">30</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">32</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">35</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">36</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-----+-------------+</span>
+
+<span class="c1">-- temperature as Dependent Variable(Y), day as Independent Variable(X)</span>
+<span class="k">SELECT</span><span class="w"> </span><span class="n">regr_avgy</span><span class="p">(</span><span class="n">temperature</span><span class="p">,</span><span class="w"> </span><span class="k">day</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">avg_temperature</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">daily_temperature</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-----------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">avg_temperature</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-----------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">33</span><span class="p">.</span><span class="mi">25</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-----------------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-count">
<h3><code class="docutils literal notranslate"><span class="pre">regr_count</span></code><a class="headerlink" href="#regr-count" title="Link to this heading">¶</a></h3>
@@ -2050,13 +2142,36 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_count</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id43">
-<h4>Arguments<a class="headerlink" href="#id43" title="Link to this heading">¶</a></h4>
+<section id="id45">
+<h4>Arguments<a class="headerlink" href="#id45" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id46">
+<h4>Example<a class="headerlink" href="#id46" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">daily_metrics</span><span class="p">(</span><span class="k">day</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">user_signups</span><span class="w"> </span><span class="nb">int</span><span class="p">)</span><span class= [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">daily_metrics</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-----+---------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="k">day</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">user_signups</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="c1">--- | ------------- |</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">100</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">120</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">110</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="w"> </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">regr_count</span><span class="p">(</span><span class="n">user_signups</span><span class="p">,</span><span class="w"> </span><span class="k">day</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">valid_pairs</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">daily_metrics</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">valid_pairs</span><span class="w"> </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="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-------------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-intercept">
<h3><code class="docutils literal notranslate"><span class="pre">regr_intercept</span></code><a class="headerlink" href="#regr-intercept" title="Link to this heading">¶</a></h3>
@@ -2064,13 +2179,37 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_intercept</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id44">
-<h4>Arguments<a class="headerlink" href="#id44" title="Link to this heading">¶</a></h4>
+<section id="id47">
+<h4>Arguments<a class="headerlink" href="#id47" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id48">
+<h4>Example<a class="headerlink" href="#id48" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">(</span><span class="n">week</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">productivity_score</span><span class="w"> </span><span class="nb">int</span><span class="p">)</span> [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">------+---------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">week</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">productivity_score</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="c1">---- | ------------------- |</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">60</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">65</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">75</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">80</span><span class="w"> </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">regr_intercept</span><span class="p">(</span><span class="n">productivity_score</span><span class="p">,</span><span class="w"> </span><span class="n">week</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">intercept</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="n">intercept</span><span class="o">|</span>
+<span class="o">|</span><span class="n">intercept</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">55</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-r2">
<h3><code class="docutils literal notranslate"><span class="pre">regr_r2</span></code><a class="headerlink" href="#regr-r2" title="Link to this heading">¶</a></h3>
@@ -2078,13 +2217,36 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_r2</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id45">
-<h4>Arguments<a class="headerlink" href="#id45" title="Link to this heading">¶</a></h4>
+<section id="id49">
+<h4>Arguments<a class="headerlink" href="#id49" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id50">
+<h4>Example<a class="headerlink" href="#id50" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">(</span><span class="k">day</span><span class="w"> </span><span class="nb">int</span><span class="w"> </span><span class="p">,</span><span class="n">user_signups</span><span class="w"> </span><span class="nb">int</span><span class="p">)</span><span c [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-----+--------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="k">day</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">user_signups</span><span class="w"> </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="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">60</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">65</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">75</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">80</span><span class="w"> </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">regr_r2</span><span class="p">(</span><span class="n">user_signups</span><span class="p">,</span><span class="w"> </span><span class="k">day</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">r_squared</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">---------+</span>
+<span class="o">|</span><span class="n">r_squared</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="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">---------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-slope">
<h3><code class="docutils literal notranslate"><span class="pre">regr_slope</span></code><a class="headerlink" href="#regr-slope" title="Link to this heading">¶</a></h3>
@@ -2092,13 +2254,36 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_slope</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id46">
-<h4>Arguments<a class="headerlink" href="#id46" title="Link to this heading">¶</a></h4>
+<section id="id51">
+<h4>Arguments<a class="headerlink" href="#id51" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id52">
+<h4>Example<a class="headerlink" href="#id52" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">(</span><span class="k">day</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">user_signups</span><span class="w"> </span><span class="nb">int</span><span class="p">)</span><span c [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">-----+--------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="k">day</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">user_signups</span><span class="w"> </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="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">60</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">65</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">70</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">75</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">80</span><span class="w"> </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">regr_slope</span><span class="p">(</span><span class="n">user_signups</span><span class="p">,</span><span class="w"> </span><span class="k">day</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">slope</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">weekly_performance</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">--------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">slope</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">--------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">--------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-sxx">
<h3><code class="docutils literal notranslate"><span class="pre">regr_sxx</span></code><a class="headerlink" href="#regr-sxx" title="Link to this heading">¶</a></h3>
@@ -2106,13 +2291,36 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_sxx</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id47">
-<h4>Arguments<a class="headerlink" href="#id47" title="Link to this heading">¶</a></h4>
+<section id="id53">
+<h4>Arguments<a class="headerlink" href="#id53" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id54">
+<h4>Example<a class="headerlink" href="#id54" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">study_hours</span><span class="p">(</span><span class="n">student_id</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">hours</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">study_hours</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">------------+-------+------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">student_id</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">hours</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">test_score</span><span class="w"> </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="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">55</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">65</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">6</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">75</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">8</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">85</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">10</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">95</span><span class="w"> </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">regr_sxx</span><span class="p">(</span><span class="n">test_score</span><span class="p">,</span><span class="w"> </span><span class="n">hours</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">sxx</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">study_hours</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">sxx</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">40</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-sxy">
<h3><code class="docutils literal notranslate"><span class="pre">regr_sxy</span></code><a class="headerlink" href="#regr-sxy" title="Link to this heading">¶</a></h3>
@@ -2120,13 +2328,34 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_sxy</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id48">
-<h4>Arguments<a class="headerlink" href="#id48" title="Link to this heading">¶</a></h4>
+<section id="id55">
+<h4>Arguments<a class="headerlink" href="#id55" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id56">
+<h4>Example<a class="headerlink" href="#id56" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">employee_productivity</span><span class="p">(</span><span class="n">week</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">productivity_score</span><span class="w"> </span><span class="nb">int</span><span class="p">)</sp [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">employee_productivity</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">------+--------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">week</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">productivity_score</span><span class="w"> </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="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">60</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">65</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">70</span><span class="w"> </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">regr_sxy</span><span class="p">(</span><span class="n">productivity_score</span><span class="p">,</span><span class="w"> </span><span class="n">week</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">sum_product_deviations</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">employee_productivity</span><span c [...]
+<span class="o">+</span><span class="c1">------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">sum_product_deviations</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">10</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">------------------------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="regr-syy">
<h3><code class="docutils literal notranslate"><span class="pre">regr_syy</span></code><a class="headerlink" href="#regr-syy" title="Link to this heading">¶</a></h3>
@@ -2134,13 +2363,34 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">regr_syy</span><span class="p">(</span><span class="n">expression_y</span><span class="p">,</span><span class="w"> </span><span class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id49">
-<h4>Arguments<a class="headerlink" href="#id49" title="Link to this heading">¶</a></h4>
+<section id="id57">
+<h4>Arguments<a class="headerlink" href="#id57" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
+<section id="id58">
+<h4>Example<a class="headerlink" href="#id58" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">employee_productivity</span><span class="p">(</span><span class="n">week</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="n">productivity_score</span><span class="w"> </span><span class="nb">int</span><span class="p">)</sp [...]
+<span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">employee_productivity</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">------+--------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">week</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">productivity_score</span><span class="w"> </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="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">60</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">65</span><span class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">70</span><span class="w"> </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">regr_syy</span><span class="p">(</span><span class="n">productivity_score</span><span class="p">,</span><span class="w"> </span><span class="n">week</span><span class="p">)</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">sum_squares_y</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">employee_productivity</span><span class="p"> [...]
+<span class="o">+</span><span class="c1">---------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">sum_squares_y</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">---------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">50</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">---------------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="stddev">
<h3><code class="docutils literal notranslate"><span class="pre">stddev</span></code><a class="headerlink" href="#stddev" title="Link to this heading">¶</a></h3>
@@ -2148,14 +2398,14 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">stddev</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id50">
-<h4>Arguments<a class="headerlink" href="#id50" title="Link to this heading">¶</a></h4>
+<section id="id59">
+<h4>Arguments<a class="headerlink" href="#id59" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id51">
-<h4>Example<a class="headerlink" href="#id51" title="Link to this heading">¶</a></h4>
+<section id="id60">
+<h4>Example<a class="headerlink" href="#id60" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">stddev</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">stddev</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -2165,8 +2415,8 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
</pre></div>
</div>
</section>
-<section id="id52">
-<h4>Aliases<a class="headerlink" href="#id52" title="Link to this heading">¶</a></h4>
+<section id="id61">
+<h4>Aliases<a class="headerlink" href="#id61" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>stddev_samp</p></li>
</ul>
@@ -2178,14 +2428,14 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">stddev_pop</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id53">
-<h4>Arguments<a class="headerlink" href="#id53" title="Link to this heading">¶</a></h4>
+<section id="id62">
+<h4>Arguments<a class="headerlink" href="#id62" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id54">
-<h4>Example<a class="headerlink" href="#id54" title="Link to this heading">¶</a></h4>
+<section id="id63">
+<h4>Example<a class="headerlink" href="#id63" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">stddev_pop</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">--------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">stddev_pop</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -2215,14 +2465,14 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">approx_distinct</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id55">
-<h4>Arguments<a class="headerlink" href="#id55" title="Link to this heading">¶</a></h4>
+<section id="id64">
+<h4>Arguments<a class="headerlink" href="#id64" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id56">
-<h4>Example<a class="headerlink" href="#id56" title="Link to this heading">¶</a></h4>
+<section id="id65">
+<h4>Example<a class="headerlink" href="#id65" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">approx_distinct</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">approx_distinct</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -2239,14 +2489,14 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">approx_median</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id57">
-<h4>Arguments<a class="headerlink" href="#id57" title="Link to this heading">¶</a></h4>
+<section id="id66">
+<h4>Arguments<a class="headerlink" href="#id66" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id58">
-<h4>Example<a class="headerlink" href="#id58" title="Link to this heading">¶</a></h4>
+<section id="id67">
+<h4>Example<a class="headerlink" href="#id67" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">approx_median</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">approx_median</span><span class="p">(</span><span class="k">column_name</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -2263,16 +2513,16 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">approx_percentile_cont</span><span class="p">(</span><span class="n">percentile</span><span class="p">,</span><span class="w"> </span><span class="n">centroids</span><span class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span class="k">ORDER</span><span class="w"> </span>< [...]
</pre></div>
</div>
-<section id="id59">
-<h4>Arguments<a class="headerlink" href="#id59" title="Link to this heading">¶</a></h4>
+<section id="id68">
+<h4>Arguments<a class="headerlink" href="#id68" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>percentile</strong>: Percentile to compute. Must be a float value between 0 and 1 (inclusive).</p></li>
<li><p><strong>centroids</strong>: Number of centroids to use in the t-digest algorithm. <em>Default is 100</em>. A higher number results in more accurate approximation but requires more memory.</p></li>
</ul>
</section>
-<section id="id60">
-<h4>Example<a class="headerlink" href="#id60" title="Link to this heading">¶</a></h4>
+<section id="id69">
+<h4>Example<a class="headerlink" href="#id69" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">approx_percentile_cont</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="w"> </span><span class="mi">100</span><span class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span class= [...]
<span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">approx_percentile_cont</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="w"> </span><span class="mi">100</span><span class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span class="k">ORDER</span><span class="w"> </s [...]
@@ -2289,16 +2539,16 @@ This aggregation function can only mix DISTINCT and ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">approx_percentile_cont_with_weight</span><span class="p">(</span><span class="n">weight</span><span class="p">,</span><span class="w"> </span><span class="n">percentile</span><span class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span class="k">ORDER</span><span class="w"> [...]
</pre></div>
</div>
-<section id="id61">
-<h4>Arguments<a class="headerlink" href="#id61" title="Link to this heading">¶</a></h4>
+<section id="id70">
+<h4>Arguments<a class="headerlink" href="#id70" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>weight</strong>: Expression to use as weight. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>percentile</strong>: Percentile to compute. Must be a float value between 0 and 1 (inclusive).</p></li>
</ul>
</section>
-<section id="id62">
-<h4>Example<a class="headerlink" href="#id62" title="Link to this heading">¶</a></h4>
+<section id="id71">
+<h4>Example<a class="headerlink" href="#id71" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">approx_percentile_cont_with_weight</span><span class="p">(</span><span class="n">weight_column</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">90</span><span class="p">)</span><span class="w"> </span><span class="n">WITH [...]
<span class="o">+</span><span class="c1">---------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">approx_percentile_cont_with_weight</span><span class="p">(</span><span class="n">weight_column</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">90</span><span class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span class="k">ORDER</span [...]
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org