[jira] [Comment Edited] (SPARK-41815) Column.isNull returns nan instead of None

["Martin Grund (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-41815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17653643#comment-17653643 ] 

Martin Grund edited comment on SPARK-41815 at 1/2/23 3:56 PM:
--------------------------------------------------------------

The reason seems to be that when Spark Connect serializes the data to Arrow it's serialized as `null` and when converted to pandas it will convert this to the `np.nan` instead of `None`. It seems that we should manually convert `nan` to `None` for the `Row` type.


was (Author: JIRAUSER290467):
The reason seems to be that when Spark Connect serializes the data to Arrow it's serialized as `null` and when converted to pandas it will convert this to the `np.nan` instead of `None`. It seems that we should manually convert `nan` to `None` for the `Row` type.

> Column.isNull returns nan instead of None
> -----------------------------------------
>
>                 Key: SPARK-41815
>                 URL: https://issues.apache.org/jira/browse/SPARK-41815
>             Project: Spark
>          Issue Type: Sub-task
>          Components: Connect
>    Affects Versions: 3.4.0
>            Reporter: Hyukjin Kwon
>            Priority: Major
>
> {code}
> File "/.../spark/python/pyspark/sql/connect/column.py", line 99, in pyspark.sql.connect.column.Column.isNull
> Failed example:
>     df.filter(df.height.isNull()).collect()
> Expected:
>     [Row(name='Alice', height=None)]
> Got:
>     [Row(name='Alice', height=nan)]
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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