This is an automated email from the ASF dual-hosted git repository.
git-site-role pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new e681a2023 Automatic Site Publish by Buildbot
e681a2023 is described below
commit e681a20232a968253233091e68407e539caf85a0
Author: buildbot <[email protected]>
AuthorDate: Mon Dec 26 16:03:58 2022 +0000
Automatic Site Publish by Buildbot
---
.../aggregate-and-aggregate-statistical/index.html | 58 ++++++++++++++++++++++
output/feed.xml | 4 +-
.../aggregate-and-aggregate-statistical/index.html | 58 ++++++++++++++++++++++
output/zh/feed.xml | 4 +-
4 files changed, 120 insertions(+), 4 deletions(-)
diff --git a/output/docs/aggregate-and-aggregate-statistical/index.html
b/output/docs/aggregate-and-aggregate-statistical/index.html
index 44e92f280..ff0bb1b39 100644
--- a/output/docs/aggregate-and-aggregate-statistical/index.html
+++ b/output/docs/aggregate-and-aggregate-statistical/index.html
@@ -1498,6 +1498,21 @@ queries.</p>
<td>INT, BIGINT</td>
<td>Same as argument type</td>
</tr>
+ <tr>
+ <td>CORR(x,y)</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
+ <tr>
+ <td>COVAR_POP(x,y)</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
+ <tr>
+ <td>COVAR_SAMP(x,y)</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
<tr>
<td>COUNT(*)</td>
<td>-</td>
@@ -1513,11 +1528,21 @@ queries.</p>
<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
<td>Same as argument type</td>
</tr>
+ <tr>
+ <td>STDDEV, STDDEV_POP, STDDEV_SAMP</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
<tr>
<td>SUM(expression)</td>
<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
<td>DECIMAL for DECIMAL argument, BIGINT for any integer-type
argument (including BIGINT), DOUBLE for floating-point arguments</td>
</tr>
+ <tr>
+ <td>VARIANCE, VAR_POP, VAR_SAMP</td>
+ <td>Numeric</td>
+ <td>Numeric</td>
+ </tr>
</tbody>
</table>
@@ -1732,6 +1757,39 @@ SELECT BIT_XOR(position_id) FROM cp.`employee.json`;
|--------|
</code></pre></div></div>
+<h2 id="corr">CORR</h2>
+<p>Returns the <a
href="https://en.wikipedia.org/wiki/Pearson_correlation_coefficient";>Pearson
Correlation Coefficient</a> for a given x, y.</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>SELECT CORR (department_id, salary) as correlation FROM
cp.`employee.json`;
++---------------------+
+| correlation |
++---------------------+
+| -0.6699481585713246 |
++---------------------+
+</code></pre></div></div>
+
+<h2 id="covar_pop">COVAR_POP</h2>
+<p>Returns the population covariance for a data set.</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>SELECT covar_pop (department_id, salary) AS covariance
FROM cp.`employee.json`;
++--------------------+
+| covariance |
++--------------------+
+| -9988.315451359776 |
++--------------------+
+</code></pre></div></div>
+
+<h2 id="covar_samp">COVAR_SAMP</h2>
+<p>Returns the sample covariance for a data set.</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>select covar_samp (department_id, salary) as covariance
from cp.`employee.json`;
++--------------------+
+| covariance |
++--------------------+
+| -9996.970837366154 |
++--------------------+
+</code></pre></div></div>
+
<h2 id="count">COUNT</h2>
<p>Returns the number of rows that match the given criteria.</p>
diff --git a/output/feed.xml b/output/feed.xml
index 643a93b5f..16d4c960c 100644
--- a/output/feed.xml
+++ b/output/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Tue, 15 Nov 2022 10:31:42 +0000</pubDate>
- <lastBuildDate>Tue, 15 Nov 2022 10:31:42 +0000</lastBuildDate>
+ <pubDate>Mon, 26 Dec 2022 16:01:52 +0000</pubDate>
+ <lastBuildDate>Mon, 26 Dec 2022 16:01:52 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
diff --git a/output/zh/docs/aggregate-and-aggregate-statistical/index.html
b/output/zh/docs/aggregate-and-aggregate-statistical/index.html
index 385fdf349..ac4be2afa 100644
--- a/output/zh/docs/aggregate-and-aggregate-statistical/index.html
+++ b/output/zh/docs/aggregate-and-aggregate-statistical/index.html
@@ -1498,6 +1498,21 @@ queries.</p>
<td>INT, BIGINT</td>
<td>Same as argument type</td>
</tr>
+ <tr>
+ <td>CORR(x,y)</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
+ <tr>
+ <td>COVAR_POP(x,y)</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
+ <tr>
+ <td>COVAR_SAMP(x,y)</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
<tr>
<td>COUNT(*)</td>
<td>-</td>
@@ -1513,11 +1528,21 @@ queries.</p>
<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
<td>Same as argument type</td>
</tr>
+ <tr>
+ <td>STDDEV, STDDEV_POP, STDDEV_SAMP</td>
+ <td>Numeric</td>
+ <td>Double</td>
+ </tr>
<tr>
<td>SUM(expression)</td>
<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
<td>DECIMAL for DECIMAL argument, BIGINT for any integer-type
argument (including BIGINT), DOUBLE for floating-point arguments</td>
</tr>
+ <tr>
+ <td>VARIANCE, VAR_POP, VAR_SAMP</td>
+ <td>Numeric</td>
+ <td>Numeric</td>
+ </tr>
</tbody>
</table>
@@ -1732,6 +1757,39 @@ SELECT BIT_XOR(position_id) FROM cp.`employee.json`;
|--------|
</code></pre></div></div>
+<h2 id="corr">CORR</h2>
+<p>Returns the <a
href="https://en.wikipedia.org/wiki/Pearson_correlation_coefficient";>Pearson
Correlation Coefficient</a> for a given x, y.</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>SELECT CORR (department_id, salary) as correlation FROM
cp.`employee.json`;
++---------------------+
+| correlation |
++---------------------+
+| -0.6699481585713246 |
++---------------------+
+</code></pre></div></div>
+
+<h2 id="covar_pop">COVAR_POP</h2>
+<p>Returns the population covariance for a data set.</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>SELECT covar_pop (department_id, salary) AS covariance
FROM cp.`employee.json`;
++--------------------+
+| covariance |
++--------------------+
+| -9988.315451359776 |
++--------------------+
+</code></pre></div></div>
+
+<h2 id="covar_samp">COVAR_SAMP</h2>
+<p>Returns the sample covariance for a data set.</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>select covar_samp (department_id, salary) as covariance
from cp.`employee.json`;
++--------------------+
+| covariance |
++--------------------+
+| -9996.970837366154 |
++--------------------+
+</code></pre></div></div>
+
<h2 id="count">COUNT</h2>
<p>Returns the number of rows that match the given criteria.</p>
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index 6985ebff1..146981b3c 100644
--- a/output/zh/feed.xml
+++ b/output/zh/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/zh/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Tue, 15 Nov 2022 10:31:42 +0000</pubDate>
- <lastBuildDate>Tue, 15 Nov 2022 10:31:42 +0000</lastBuildDate>
+ <pubDate>Mon, 26 Dec 2022 16:01:52 +0000</pubDate>
+ <lastBuildDate>Mon, 26 Dec 2022 16:01:52 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
