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:21 UTC

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

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