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 <18624049...@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 <ilya.kaznacheev@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]