You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by il...@apache.org on 2022/02/22 12:52:26 UTC
[ignite] branch master updated: IGNITE-16617 Delete the sections related to FIRSTVALUE & LASTVALUE - Fixes #9845.
This is an automated email from the ASF dual-hosted git repository.
ilyak pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ignite.git
The following commit(s) were added to refs/heads/master by this push:
new 3cc87ae IGNITE-16617 Delete the sections related to FIRSTVALUE & LASTVALUE - Fixes #9845.
3cc87ae is described below
commit 3cc87ae9be049f1b982e7dbbbaf8c4d5f2dd1c06
Author: liyujue <18...@163.com>
AuthorDate: Tue Feb 22 15:50:28 2022 +0300
IGNITE-16617 Delete the sections related to FIRSTVALUE & LASTVALUE - Fixes #9845.
Signed-off-by: Ilya Kaznacheev <il...@chronicle.software>
---
docs/_docs/sql-reference/aggregate-functions.adoc | 49 -----------------------
1 file changed, 49 deletions(-)
diff --git a/docs/_docs/sql-reference/aggregate-functions.adoc b/docs/_docs/sql-reference/aggregate-functions.adoc
index 7a724ea..da7ad3b 100644
--- a/docs/_docs/sql-reference/aggregate-functions.adoc
+++ b/docs/_docs/sql-reference/aggregate-functions.adoc
@@ -119,30 +119,6 @@ Calculate the number of players in every city:
SELECT city_id, COUNT(*) FROM Players GROUP BY city_id;
----
-== FIRSTVALUE
-
-[source, sql]
-----
-FIRSTVALUE ([DISTINCT] <expression1>, <expression2>)
-----
-
-Returns the value of `expression1` associated with the smallest value of `expression2` for each group defined by the `group by` expression in the query.
-This function can only be used with colocated data and you have to use the `collocated` flag when executing the query.
-
-The colocated hint can be set as follows:
-
-* `SqlFieldsQuery.collocated = true` if you use the link:SQL/sql-api[SQL API] to execute queries.
-* link:SQL/JDBC/jdbc-driver#parameters[JDBC connection string parameter]
-* link:SQL/ODBC/connection-string-dsn#supported-arguments[ODBC connection string argument]
-
-
-=== Example
-The example returns
-[source, sql]
-----
-select company_id, firstvalue(name, age) as youngest from person group by company_id;
-----
-
== GROUP_CONCAT
[source,sql]
@@ -175,31 +151,6 @@ SELECT GROUP_CONCAT(name ORDER BY id SEPARATOR ', ') FROM Players;
----
-== LASTVALUE
-
-[source, sql]
-----
-LASTVALUE ([DISTINCT] <expression1>, <expression2>)
-----
-
-Returns the value of `expression1` associated with the largest value of `expression2` for each group defined by the `group by` expression.
-This function can only be used with colocated data and you have to use the `collocated` flag when executing the query.
-
-The colocated hint can be set as follows:
-
-* `SqlFieldsQuery.collocated = true` if you use the link:SQL/sql-api[SQL API] to execute queries.
-* link:SQL/JDBC/jdbc-driver#parameters[JDBC connection string parameter]
-* link:SQL/ODBC/connection-string-dsn#supported-arguments[ODBC connection string argument]
-
-=== Example
-
-[source, sql]
-----
-select company_id, lastvalue(name, age) as oldest from person group by company_id;
-----
-
-
-
== MAX
[source,sql]