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 53e64fe81c Publish built docs triggered by
1b3a7af673e5b590da94cea74892ee2c0c097848
53e64fe81c is described below
commit 53e64fe81c5c9e20c7247afc351b91a7576fd442
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sat Jul 6 11:09:29 2024 +0000
Publish built docs triggered by 1b3a7af673e5b590da94cea74892ee2c0c097848
---
_sources/user-guide/sql/aggregate_functions.md.txt | 6 ++----
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 6 ++----
3 files changed, 5 insertions(+), 9 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index 427a7bf130..edb0e1d0c9 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -123,11 +123,9 @@ bool_or(expression)
### `count`
-Returns the number of rows in the specified column.
+Returns the number of non-null values in the specified column.
-Count includes _null_ values in the total count.
-To exclude _null_ values from the total count, include `<column> IS NOT NULL`
-in the `WHERE` clause.
+To include _null_ values in the total count, use `count(*)`.
```
count(expression)
diff --git a/searchindex.js b/searchindex.js
index 42fcd1f6ac..d689b787b2 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[43, "op-neq"]], "!~": [[43,
"op-re-not-match"]], "!~*": [[43, "op-re-not-match-i"]], "!~~": [[43, "id18"]],
"!~~*": [[43, "id19"]], "#": [[43, "op-bit-xor"]], "%": [[43, "op-modulo"]],
"&": [[43, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[10,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[43, "op-multiply"]], "+": [[43, "op-plus"]], "-": [[43, "op-minus"]], "/": [[
[...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[43, "op-neq"]], "!~": [[43,
"op-re-not-match"]], "!~*": [[43, "op-re-not-match-i"]], "!~~": [[43, "id18"]],
"!~~*": [[43, "id19"]], "#": [[43, "op-bit-xor"]], "%": [[43, "op-modulo"]],
"&": [[43, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[10,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[43, "op-multiply"]], "+": [[43, "op-plus"]], "-": [[43, "op-minus"]], "/": [[
[...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index eda01553dd..71d1afdd6a 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -1255,10 +1255,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</section>
<section id="count">
<h3><code class="docutils literal notranslate"><span
class="pre">count</span></code><a class="headerlink" href="#count" title="Link
to this heading">ΒΆ</a></h3>
-<p>Returns the number of rows in the specified column.</p>
-<p>Count includes <em>null</em> values in the total count.
-To exclude <em>null</em> values from the total count, include <code
class="docutils literal notranslate"><span class="pre"><column></span>
<span class="pre">IS</span> <span class="pre">NOT</span> <span
class="pre">NULL</span></code>
-in the <code class="docutils literal notranslate"><span
class="pre">WHERE</span></code> clause.</p>
+<p>Returns the number of non-null values in the specified column.</p>
+<p>To include <em>null</em> values in the total count, use <code
class="docutils literal notranslate"><span
class="pre">count(*)</span></code>.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">count</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
