You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Zhu, Lipeng (JIRA)" <ji...@apache.org> on 2019/06/05 04:49:01 UTC

[jira] [Created] (SPARK-27952) Built-in function: lag

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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org