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

Posted to issues@spark.apache.org by "jiaan.geng (Jira)" <ji...@apache.org> on 2022/03/25 09:10:00 UTC

[jira] [Created] (SPARK-38655) UnboundedPrecedingOffsetWindowFunctionFrame cannot find the offset row whose input is not null

jiaan.geng created SPARK-38655:
----------------------------------

             Summary: UnboundedPrecedingOffsetWindowFunctionFrame cannot find the offset row whose input is not null
                 Key: SPARK-38655
                 URL: https://issues.apache.org/jira/browse/SPARK-38655
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.3.0
            Reporter: jiaan.geng


select x, nth_value(x, 5) IGNORE NULLS over (order by x rows between unbounded preceding and current row)
from (select explode(sequence(1, 3)) x)

returns
null
null
3

But it should returns
null
null
null



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org