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

["Apache Spark (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-38655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Apache Spark reassigned SPARK-38655:
------------------------------------

    Assignee:     (was: Apache Spark)

> 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
>            Priority: Major
>
> 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