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

Wenchen Fan updated SPARK-38655:
--------------------------------
    Fix Version/s: 3.2.2

> OffsetWindowFunctionFrameBase 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
>            Assignee: jiaan.geng
>            Priority: Major
>             Fix For: 3.3.0, 3.2.2
>
>
> 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to