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

Ruifeng Zheng edited comment on SPARK-41814 at 1/3/23 3:06 AM:
---------------------------------------------------------------

this issue is due to that `createDataFrame` can't handle NaN/None properly:
1, the conversion from rows to pd.DataFrame, which automatically convert null 
to NaN
2, then the conversion from pd.DataFrame to pa.Table, which convert NaN to null


was (Author: podongfeng):
this issue is due to:
1, the conversion from rows to pd.DataFrame, which automatically convert null 
to NaN
2, then the conversion from pd.DataFrame to pa.Table, which convert NaN to null

> Column.eqNullSafe fails on NaN comparison
> -----------------------------------------
>
>                 Key: SPARK-41814
>                 URL: https://issues.apache.org/jira/browse/SPARK-41814
>             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 115, in 
> pyspark.sql.connect.column.Column.eqNullSafe
> Failed example:
>     df2.select(
>         df2['value'].eqNullSafe(None),
>         df2['value'].eqNullSafe(float('NaN')),
>         df2['value'].eqNullSafe(42.0)
>     ).show()
> Expected:
>     +----------------+---------------+----------------+
>     |(value <=> NULL)|(value <=> NaN)|(value <=> 42.0)|
>     +----------------+---------------+----------------+
>     |           false|           true|           false|
>     |           false|          false|            true|
>     |            true|          false|           false|
>     +----------------+---------------+----------------+
> Got:
>     +----------------+---------------+----------------+
>     |(value <=> NULL)|(value <=> NaN)|(value <=> 42.0)|
>     +----------------+---------------+----------------+
>     |            true|          false|           false|
>     |           false|          false|            true|
>     |            true|          false|           false|
>     +----------------+---------------+----------------+
> {code}



--
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

Reply via email to