You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@age.apache.org by gi...@apache.org on 2021/10/21 20:00:24 UTC
[incubator-age-website] branch asf-site updated: deploy:
50d3f47ca10ce169d4e1bc17c7811da6ab31dce3
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/incubator-age-website.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 76fe408 deploy: 50d3f47ca10ce169d4e1bc17c7811da6ab31dce3
76fe408 is described below
commit 76fe4084617a74a5626c7cbf7a39184a346d0fdc
Author: JoshInnis <Jo...@users.noreply.github.com>
AuthorDate: Thu Oct 21 20:00:20 2021 +0000
deploy: 50d3f47ca10ce169d4e1bc17c7811da6ab31dce3
---
docs/master/.buildinfo | 2 +-
docs/master/.doctrees/advanced/advanced.doctree | Bin 17332 -> 17332 bytes
.../.doctrees/advanced/advanced_overview.doctree | Bin 3665 -> 3665 bytes
docs/master/.doctrees/advanced/plpgsql.doctree | Bin 4203 -> 4203 bytes
.../.doctrees/advanced/prepared_statements.doctree | Bin 8572 -> 8572 bytes
.../.doctrees/advanced/sql_in_cypher.doctree | Bin 5905 -> 5905 bytes
docs/master/.doctrees/clauses/create.doctree | Bin 20453 -> 20453 bytes
docs/master/.doctrees/clauses/delete.doctree | Bin 11208 -> 11208 bytes
docs/master/.doctrees/clauses/limit.doctree | Bin 7427 -> 7427 bytes
docs/master/.doctrees/clauses/match.doctree | Bin 25090 -> 25090 bytes
docs/master/.doctrees/clauses/order_by.doctree | Bin 15347 -> 15347 bytes
docs/master/.doctrees/clauses/remove.doctree | Bin 6630 -> 6630 bytes
docs/master/.doctrees/clauses/return.doctree | Bin 21591 -> 21591 bytes
docs/master/.doctrees/clauses/set.doctree | Bin 11952 -> 11952 bytes
docs/master/.doctrees/clauses/skip.doctree | Bin 9537 -> 9537 bytes
docs/master/.doctrees/clauses/with.doctree | Bin 11085 -> 11085 bytes
docs/master/.doctrees/environment.pickle | Bin 122564 -> 123026 bytes
.../functions/aggregate_functions.doctree | Bin 51852 -> 55315 bytes
.../.doctrees/functions/list_functions.doctree | Bin 2677 -> 2677 bytes
.../functions/logarithmic_functions.doctree | Bin 16358 -> 16358 bytes
.../.doctrees/functions/numeric_functions.doctree | Bin 22664 -> 22664 bytes
.../functions/predicate_functions.doctree | Bin 6445 -> 6445 bytes
.../.doctrees/functions/scalar_functions.doctree | Bin 56524 -> 56524 bytes
.../.doctrees/functions/string_functions.doctree | Bin 47951 -> 47951 bytes
.../functions/trigonometric_functions.doctree | Bin 34627 -> 34627 bytes
.../.doctrees/functions/user_functions.doctree | Bin 4976 -> 4976 bytes
docs/master/.doctrees/index.doctree | Bin 4123 -> 4123 bytes
docs/master/.doctrees/intro/aggregation.doctree | Bin 6801 -> 6801 bytes
docs/master/.doctrees/intro/comparability.doctree | Bin 32235 -> 32235 bytes
docs/master/.doctrees/intro/cypher.doctree | Bin 10246 -> 10246 bytes
docs/master/.doctrees/intro/graphs.doctree | Bin 11554 -> 11554 bytes
docs/master/.doctrees/intro/overview.doctree | Bin 4006 -> 4006 bytes
docs/master/.doctrees/intro/precedence.doctree | Bin 6872 -> 6872 bytes
docs/master/.doctrees/intro/setup.doctree | Bin 11024 -> 11024 bytes
docs/master/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
.../_sources/functions/aggregate_functions.md.txt | 51 ++++++++++++++++-----
docs/master/functions/aggregate_functions.html | 40 +++++++++++++++-
docs/master/searchindex.js | 2 +-
38 files changed, 81 insertions(+), 14 deletions(-)
diff --git a/docs/master/.buildinfo b/docs/master/.buildinfo
index 86a7ebc..6449714 100644
--- a/docs/master/.buildinfo
+++ b/docs/master/.buildinfo
@@ -1,4 +1,4 @@
# Sphinx build info version 1
# This file hashes the configuration used when building these files. When it is not found, a full rebuild will be done.
-config: f71e51e00e5f909d7572b07340e3f418
+config: 365c49ad2f0d728c558915062d734ca7
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/master/.doctrees/advanced/advanced.doctree b/docs/master/.doctrees/advanced/advanced.doctree
index 940970c..2d043a9 100644
Binary files a/docs/master/.doctrees/advanced/advanced.doctree and b/docs/master/.doctrees/advanced/advanced.doctree differ
diff --git a/docs/master/.doctrees/advanced/advanced_overview.doctree b/docs/master/.doctrees/advanced/advanced_overview.doctree
index 9a6fbf7..93da6ad 100644
Binary files a/docs/master/.doctrees/advanced/advanced_overview.doctree and b/docs/master/.doctrees/advanced/advanced_overview.doctree differ
diff --git a/docs/master/.doctrees/advanced/plpgsql.doctree b/docs/master/.doctrees/advanced/plpgsql.doctree
index 615cda6..93905bb 100644
Binary files a/docs/master/.doctrees/advanced/plpgsql.doctree and b/docs/master/.doctrees/advanced/plpgsql.doctree differ
diff --git a/docs/master/.doctrees/advanced/prepared_statements.doctree b/docs/master/.doctrees/advanced/prepared_statements.doctree
index f8d7c71..a9bdb6d 100644
Binary files a/docs/master/.doctrees/advanced/prepared_statements.doctree and b/docs/master/.doctrees/advanced/prepared_statements.doctree differ
diff --git a/docs/master/.doctrees/advanced/sql_in_cypher.doctree b/docs/master/.doctrees/advanced/sql_in_cypher.doctree
index 69d5c14..20729cd 100644
Binary files a/docs/master/.doctrees/advanced/sql_in_cypher.doctree and b/docs/master/.doctrees/advanced/sql_in_cypher.doctree differ
diff --git a/docs/master/.doctrees/clauses/create.doctree b/docs/master/.doctrees/clauses/create.doctree
index c21d167..4b447da 100644
Binary files a/docs/master/.doctrees/clauses/create.doctree and b/docs/master/.doctrees/clauses/create.doctree differ
diff --git a/docs/master/.doctrees/clauses/delete.doctree b/docs/master/.doctrees/clauses/delete.doctree
index 1295b1e..1fca8fe 100644
Binary files a/docs/master/.doctrees/clauses/delete.doctree and b/docs/master/.doctrees/clauses/delete.doctree differ
diff --git a/docs/master/.doctrees/clauses/limit.doctree b/docs/master/.doctrees/clauses/limit.doctree
index b3c5700..b301c5a 100644
Binary files a/docs/master/.doctrees/clauses/limit.doctree and b/docs/master/.doctrees/clauses/limit.doctree differ
diff --git a/docs/master/.doctrees/clauses/match.doctree b/docs/master/.doctrees/clauses/match.doctree
index 6365902..78e51e1 100644
Binary files a/docs/master/.doctrees/clauses/match.doctree and b/docs/master/.doctrees/clauses/match.doctree differ
diff --git a/docs/master/.doctrees/clauses/order_by.doctree b/docs/master/.doctrees/clauses/order_by.doctree
index 2e87c8f..c19c8bd 100644
Binary files a/docs/master/.doctrees/clauses/order_by.doctree and b/docs/master/.doctrees/clauses/order_by.doctree differ
diff --git a/docs/master/.doctrees/clauses/remove.doctree b/docs/master/.doctrees/clauses/remove.doctree
index 9999433..1efa854 100644
Binary files a/docs/master/.doctrees/clauses/remove.doctree and b/docs/master/.doctrees/clauses/remove.doctree differ
diff --git a/docs/master/.doctrees/clauses/return.doctree b/docs/master/.doctrees/clauses/return.doctree
index 026ca7f..2ec376f 100644
Binary files a/docs/master/.doctrees/clauses/return.doctree and b/docs/master/.doctrees/clauses/return.doctree differ
diff --git a/docs/master/.doctrees/clauses/set.doctree b/docs/master/.doctrees/clauses/set.doctree
index 9234775..0e2e2b3 100644
Binary files a/docs/master/.doctrees/clauses/set.doctree and b/docs/master/.doctrees/clauses/set.doctree differ
diff --git a/docs/master/.doctrees/clauses/skip.doctree b/docs/master/.doctrees/clauses/skip.doctree
index c009288..3b04301 100644
Binary files a/docs/master/.doctrees/clauses/skip.doctree and b/docs/master/.doctrees/clauses/skip.doctree differ
diff --git a/docs/master/.doctrees/clauses/with.doctree b/docs/master/.doctrees/clauses/with.doctree
index a813ef3..b4ae602 100644
Binary files a/docs/master/.doctrees/clauses/with.doctree and b/docs/master/.doctrees/clauses/with.doctree differ
diff --git a/docs/master/.doctrees/environment.pickle b/docs/master/.doctrees/environment.pickle
index 5f9e618..c93e8de 100644
Binary files a/docs/master/.doctrees/environment.pickle and b/docs/master/.doctrees/environment.pickle differ
diff --git a/docs/master/.doctrees/functions/aggregate_functions.doctree b/docs/master/.doctrees/functions/aggregate_functions.doctree
index 3fb76fe..d384755 100644
Binary files a/docs/master/.doctrees/functions/aggregate_functions.doctree and b/docs/master/.doctrees/functions/aggregate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/list_functions.doctree b/docs/master/.doctrees/functions/list_functions.doctree
index 5ba778c..aa81b25 100644
Binary files a/docs/master/.doctrees/functions/list_functions.doctree and b/docs/master/.doctrees/functions/list_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/logarithmic_functions.doctree b/docs/master/.doctrees/functions/logarithmic_functions.doctree
index e6fd078..ac29332 100644
Binary files a/docs/master/.doctrees/functions/logarithmic_functions.doctree and b/docs/master/.doctrees/functions/logarithmic_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/numeric_functions.doctree b/docs/master/.doctrees/functions/numeric_functions.doctree
index ca494a8..253fcf5 100644
Binary files a/docs/master/.doctrees/functions/numeric_functions.doctree and b/docs/master/.doctrees/functions/numeric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/predicate_functions.doctree b/docs/master/.doctrees/functions/predicate_functions.doctree
index ea6a4eb..d19ee5d 100644
Binary files a/docs/master/.doctrees/functions/predicate_functions.doctree and b/docs/master/.doctrees/functions/predicate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/scalar_functions.doctree b/docs/master/.doctrees/functions/scalar_functions.doctree
index 5464222..8433b48 100644
Binary files a/docs/master/.doctrees/functions/scalar_functions.doctree and b/docs/master/.doctrees/functions/scalar_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/string_functions.doctree b/docs/master/.doctrees/functions/string_functions.doctree
index 751b289..cdc47ba 100644
Binary files a/docs/master/.doctrees/functions/string_functions.doctree and b/docs/master/.doctrees/functions/string_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/trigonometric_functions.doctree b/docs/master/.doctrees/functions/trigonometric_functions.doctree
index 8319e06..997cea5 100644
Binary files a/docs/master/.doctrees/functions/trigonometric_functions.doctree and b/docs/master/.doctrees/functions/trigonometric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/user_functions.doctree b/docs/master/.doctrees/functions/user_functions.doctree
index 13490ec..e1593c2 100644
Binary files a/docs/master/.doctrees/functions/user_functions.doctree and b/docs/master/.doctrees/functions/user_functions.doctree differ
diff --git a/docs/master/.doctrees/index.doctree b/docs/master/.doctrees/index.doctree
index 5b092fe..9585a7f 100644
Binary files a/docs/master/.doctrees/index.doctree and b/docs/master/.doctrees/index.doctree differ
diff --git a/docs/master/.doctrees/intro/aggregation.doctree b/docs/master/.doctrees/intro/aggregation.doctree
index 243d025..004a597 100644
Binary files a/docs/master/.doctrees/intro/aggregation.doctree and b/docs/master/.doctrees/intro/aggregation.doctree differ
diff --git a/docs/master/.doctrees/intro/comparability.doctree b/docs/master/.doctrees/intro/comparability.doctree
index c3fabc7..e0a8c3d 100644
Binary files a/docs/master/.doctrees/intro/comparability.doctree and b/docs/master/.doctrees/intro/comparability.doctree differ
diff --git a/docs/master/.doctrees/intro/cypher.doctree b/docs/master/.doctrees/intro/cypher.doctree
index 0993bbd..7f73ec5 100644
Binary files a/docs/master/.doctrees/intro/cypher.doctree and b/docs/master/.doctrees/intro/cypher.doctree differ
diff --git a/docs/master/.doctrees/intro/graphs.doctree b/docs/master/.doctrees/intro/graphs.doctree
index ecda36f..f904520 100644
Binary files a/docs/master/.doctrees/intro/graphs.doctree and b/docs/master/.doctrees/intro/graphs.doctree differ
diff --git a/docs/master/.doctrees/intro/overview.doctree b/docs/master/.doctrees/intro/overview.doctree
index e16d055..18f450b 100644
Binary files a/docs/master/.doctrees/intro/overview.doctree and b/docs/master/.doctrees/intro/overview.doctree differ
diff --git a/docs/master/.doctrees/intro/precedence.doctree b/docs/master/.doctrees/intro/precedence.doctree
index 2f59879..f056f73 100644
Binary files a/docs/master/.doctrees/intro/precedence.doctree and b/docs/master/.doctrees/intro/precedence.doctree differ
diff --git a/docs/master/.doctrees/intro/setup.doctree b/docs/master/.doctrees/intro/setup.doctree
index d090aea..efc455e 100644
Binary files a/docs/master/.doctrees/intro/setup.doctree and b/docs/master/.doctrees/intro/setup.doctree differ
diff --git a/docs/master/.doctrees/intro/types.doctree b/docs/master/.doctrees/intro/types.doctree
index 15eaf9d..9675036 100644
Binary files a/docs/master/.doctrees/intro/types.doctree and b/docs/master/.doctrees/intro/types.doctree differ
diff --git a/docs/master/_sources/functions/aggregate_functions.md.txt b/docs/master/_sources/functions/aggregate_functions.md.txt
index ec5de12..4d62053 100644
--- a/docs/master/_sources/functions/aggregate_functions.md.txt
+++ b/docs/master/_sources/functions/aggregate_functions.md.txt
@@ -3,7 +3,7 @@
## min()
-min() returns the minimum value in a set of values. \
+min() returns the minimum value in a set of values.
Syntax: `min(expression)`
@@ -555,18 +555,14 @@ Arguments:
Considerations:
-
-
-
* count(*) includes records returning null.
* count(expr) ignores null values.
* count(null) returns 0.
* Using count(*) to return the number of nodes
* count(*) can be used to return the number of nodes; for example, the number of nodes connected to some node n.
-Query
-
+Query
```
SELECT *
FROM cypher('graph_name', $$
@@ -575,12 +571,9 @@ FROM cypher('graph_name', $$
$$ as (age agtype, number_of_people agtype);
```
-
The labels and age property of the start node n and the number of nodes related to n are returned.
Result:
-
-
<table>
<tr>
<td>age
@@ -604,8 +597,6 @@ Result:
Using count(*) to group and count relationship typescount(*) can be used to group relationship types and return the number.
Query
-
-
```
SELECT *
FROM cypher('graph_name', $$
@@ -716,6 +707,44 @@ Result:
</table>
+### Counting with and without duplicates
+
+In this example we are trying to find all our friends of friends, and count them:
+* The first aggregate function, count(DISTINCT friend_of_friend), will only count a friend_of_friend once, as DISTINCT removes the duplicates.
+* The second aggregate function, count(friend_of_friend), will consider the same friend_of_friend multiple times.
+
+Query
+```
+SELECT *
+FROM cypher('graph_name', $$
+ MATCH (me:Person)-[]->(friend:Person)-[]->(friend_of_friend:Person)
+ WHERE me.name = 'A'
+ RETURN count(DISTINCT friend_of_friend), count(friend_of_friend)
+$$) as (friend_of_friends_distinct agtype, friend_of_friends agtype);
+```
+
+Both B and C know D and thus D will get counted twice when not using DISTINCT
+
+Result:
+<table>
+ <tr>
+ <td>friend_of_friends_distinct
+ </td>
+ <td>friend_of_friends
+ </td>
+ </tr>
+ <tr>
+ <td>1
+ </td>
+ <td>2
+ </td>
+ </tr>
+ <tr>
+ <td>1 row
+ </td>
+ </tr>
+</table>
+
## avg()
diff --git a/docs/master/functions/aggregate_functions.html b/docs/master/functions/aggregate_functions.html
index b44e38c..cc26f60 100644
--- a/docs/master/functions/aggregate_functions.html
+++ b/docs/master/functions/aggregate_functions.html
@@ -139,6 +139,7 @@
<li class="toctree-l2"><a class="reference internal" href="#count">count()</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#using-count-expression-to-return-the-number-of-values">Using count(expression) to return the number of values</a></li>
<li class="toctree-l3"><a class="reference internal" href="#counting-non-null-values">Counting non-null values</a></li>
+<li class="toctree-l3"><a class="reference internal" href="#counting-with-and-without-duplicates">Counting with and without duplicates</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="#avg">avg()</a></li>
@@ -229,7 +230,7 @@
<h1>Aggregation Functions<a class="headerlink" href="#aggregation-functions" title="Permalink to this headline">¶</a></h1>
<div class="section" id="min">
<h2>min()<a class="headerlink" href="#min" title="Permalink to this headline">¶</a></h2>
-<p>min() returns the minimum value in a set of values. \</p>
+<p>min() returns the minimum value in a set of values.</p>
<p>Syntax: <code class="docutils literal notranslate"><span class="pre">min(expression)</span></code></p>
<p>Returns:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">A</span> <span class="nb">property</span> <span class="nb">type</span><span class="p">,</span> <span class="ow">or</span> <span class="n">a</span> <span class="nb">list</span><span class="p">,</span> <span class="n">depending</span> <span class="n">on</span> <span class="n">the</span> <span class="n">values</span> <span class="n">returned</span> <span class="n">by</span> <span class="n">ex [...]
@@ -750,6 +751,43 @@ $$) as (count agtype);
</tr>
</table>
</div>
+<div class="section" id="counting-with-and-without-duplicates">
+<h3>Counting with and without duplicates<a class="headerlink" href="#counting-with-and-without-duplicates" title="Permalink to this headline">¶</a></h3>
+<p>In this example we are trying to find all our friends of friends, and count them:</p>
+<ul class="simple">
+<li><p>The first aggregate function, count(DISTINCT friend_of_friend), will only count a friend_of_friend once, as DISTINCT removes the duplicates.</p></li>
+<li><p>The second aggregate function, count(friend_of_friend), will consider the same friend_of_friend multiple times.</p></li>
+</ul>
+<p>Query</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>SELECT *
+FROM cypher('graph_name', $$
+ MATCH (me:Person)-[]->(friend:Person)-[]->(friend_of_friend:Person)
+ WHERE me.name = 'A'
+ RETURN count(DISTINCT friend_of_friend), count(friend_of_friend)
+$$) as (friend_of_friends_distinct agtype, friend_of_friends agtype);
+</pre></div>
+</div>
+<p>Both B and C know D and thus D will get counted twice when not using DISTINCT</p>
+<p>Result:</p>
+<table>
+ <tr>
+ <td>friend_of_friends_distinct
+ </td>
+ <td>friend_of_friends
+ </td>
+ </tr>
+ <tr>
+ <td>1
+ </td>
+ <td>2
+ </td>
+ </tr>
+ <tr>
+ <td>1 row
+ </td>
+ </tr>
+</table>
+</div>
</div>
<div class="section" id="avg">
<h2>avg()<a class="headerlink" href="#avg" title="Permalink to this headline">¶</a></h2>
diff --git a/docs/master/searchindex.js b/docs/master/searchindex.js
index ad16b37..44af98f 100644
--- a/docs/master/searchindex.js
+++ b/docs/master/searchindex.js
@@ -1 +1 @@
-Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct [...]
\ No newline at end of file
+Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct [...]
\ No newline at end of file