Zhu, Lipeng created SPARK-27952: ----------------------------------- Summary: Built-in function: lag Key: SPARK-27952 URL: https://issues.apache.org/jira/browse/SPARK-27952 Project: Spark Issue Type: Sub-task Components: SQL Affects Versions: 3.0.0 Reporter: Zhu, Lipeng
[https://www.postgresql.org/docs/8.4/functions-window.html] |{{lag({{value}} {{any}} [, {{offset}}{{integer}} [, {{default}} {{any}} ]])}}|{{same type as }}{{value}}|returns {{value}} evaluated at the row that is {{offset}} rows before the current row within the partition; if there is no such row, instead return {{default}}. Both {{offset}}and {{default}} are evaluated with respect to the current row. If omitted, {{offset}} defaults to 1 and {{default}} to null| -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org