[
https://issues.apache.org/jira/browse/SPARK-51757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-51757:
-----------------------------------
Labels: pull-request-available (was: )
> `LEAD` causes NullPointerException in window function
> -----------------------------------------------------
>
> Key: SPARK-51757
> URL: https://issues.apache.org/jira/browse/SPARK-51757
> Project: Spark
> Issue Type: Task
> Components: SQL
> Affects Versions: 4.0.0, 4.1.0
> Reporter: Linhong Liu
> Priority: Major
> Labels: pull-request-available
>
> Issue:
> ```
> select lead(id, 3, id) over (partition by div(id, 2) order by id) from
> range(0, 10, 1, 1)
> ```
> throws
> ```
> [info] org.apache.spark.SparkException: Job aborted due to stage failure:
> Task 0 in stage 0.0 failed 1 times, most recent failure: Lost task 0.0 in
> stage 0.0 (TID 0): java.lang.
> NullPointerException: Cannot invoke
> "org.apache.spark.sql.catalyst.expressions.SpecializedGetters.isNullAt(int)"
> because "<local2>" is null
> [info] at
> org.apache.spark.sql.catalyst.expressions.GeneratedClass$SpecificMutableProjection.apply(Unknown
> Source)
> [info] at
> org.apache.spark.sql.execution.window.OffsetWindowFunctionFrameBase.prepare(WindowFunctionFrame.scala:186)
> [info] at
> org.apache.spark.sql.execution.window.WindowEvaluatorFactory$WindowPartitionEvaluator$$anon$1.fetchNextPartition(WindowEvaluatorFactory.scala:108)
> [info] at
> ...
> ```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
