You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@flink.apache.org by fh...@apache.org on 2024/11/05 08:35:20 UTC

(flink) branch fhueske-hotfix-add-lead_lag-table-api-agg-functions-to-docs created (now cb22534b7d4)

This is an automated email from the ASF dual-hosted git repository.

fhueske pushed a change to branch fhueske-hotfix-add-lead_lag-table-api-agg-functions-to-docs
in repository https://gitbox.apache.org/repos/asf/flink.git


      at cb22534b7d4 [hotfix] [docs] Add lead()/lag() Table API agg functions to docs

This branch includes the following new commits:

     new cb22534b7d4 [hotfix] [docs] Add lead()/lag() Table API agg functions to docs

The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.



(flink) 01/01: [hotfix] [docs] Add lead()/lag() Table API agg functions to docs

Posted by fh...@apache.org.
This is an automated email from the ASF dual-hosted git repository.

fhueske pushed a commit to branch fhueske-hotfix-add-lead_lag-table-api-agg-functions-to-docs
in repository https://gitbox.apache.org/repos/asf/flink.git

commit cb22534b7d438da4d707b9bfc465e0ce34c99934
Author: Fabian Hueske <fh...@confluent.io>
AuthorDate: Tue Nov 5 09:32:43 2024 +0100

    [hotfix] [docs] Add lead()/lag() Table API agg functions to docs
---
 docs/data/sql_functions.yml    | 2 ++
 docs/data/sql_functions_zh.yml | 2 ++
 2 files changed, 4 insertions(+)

diff --git a/docs/data/sql_functions.yml b/docs/data/sql_functions.yml
index dad1dfac25f..eda6d3de753 100644
--- a/docs/data/sql_functions.yml
+++ b/docs/data/sql_functions.yml
@@ -1220,8 +1220,10 @@ aggregate:
   - sql: ROW_NUMBER()
     description: Assigns a unique, sequential number to each row, starting with one, according to the ordering of rows within the window partition. ROW_NUMBER and RANK are similar. ROW_NUMBER numbers all rows sequentially (for example 1, 2, 3, 4, 5). RANK provides the same numeric value for ties (for example 1, 2, 2, 4, 5).
   - sql: LEAD(expression [, offset] [, default])
+    table: lead(expression [, offset] [, default])
     description: Returns the value of expression at the offsetth row after the current row in the window. The default value of offset is 1 and the default value of default is NULL.
   - sql: LAG(expression [, offset] [, default])
+    table: lag(expression [, offset] [, default])
     description: Returns the value of expression at the offsetth row before the current row in the window. The default value of offset is 1 and the default value of default is NULL.
   - sql: FIRST_VALUE(expression)
     table: FIELD.firstValue
diff --git a/docs/data/sql_functions_zh.yml b/docs/data/sql_functions_zh.yml
index d057df792aa..d0250acc6f6 100644
--- a/docs/data/sql_functions_zh.yml
+++ b/docs/data/sql_functions_zh.yml
@@ -1334,8 +1334,10 @@ aggregate:
       在窗口分区内根据 rows 的排序为每一行分配一个唯一的序列号,从 1 开始。ROW_NUMBER 和 RANK 相似。ROW_NUMBER 按
       顺序对所有行进行编号(例如 1,2,3,4,5)。RANK 为等值 row 提供相同的序列值(例如 1,2,2,4,5)。
   - sql: LEAD(expression [, offset] [, default])
+    table: lead(expression [, offset] [, default])
     description: 返回窗口中当前行之后第 offset 行处的表达式值。offset 的默认值为 1,default 的默认值为 `NULL`。
   - sql: LAG(expression [, offset] [, default])
+    table: lag(expression [, offset] [, default])
     description: 返回窗口中当前行之前第 offset 行处的表达式值。offset 的默认值为 1,default 的默认值为 `NULL`。
   - sql: FIRST_VALUE(expression)
     table: FIELD.firstValue