[
https://issues.apache.org/jira/browse/SPARK-32640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17180598#comment-17180598
]
Wenchen Fan commented on SPARK-32640:
-------------------------------------
master branch works too
{code:java}
Welcome to
____ __
/ __/__ ___ _____/ /__
_\ \/ _ \/ _ `/ __/ '_/
/___/ .__/\_,_/_/ /_/\_\ version 3.1.0-SNAPSHOT
/_/Using Scala version 2.12.10 (Java HotSpot(TM) 64-Bit Server VM, Java
1.8.0_161)
Type in expressions to have them evaluated.
Type :help for more information.
scala> sql("select log1p(double('nan'))").show
+--------------------------+
|LOG1P(CAST(nan AS DOUBLE))|
+--------------------------+
| NaN|
+--------------------------+
{code}
Maybe there is a special NaN value that cause the null result?
> Spark 3.1 log(NaN) returns null instead of NaN
> ----------------------------------------------
>
> Key: SPARK-32640
> URL: https://issues.apache.org/jira/browse/SPARK-32640
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.1.0
> Reporter: Thomas Graves
> Priority: Major
>
> I was testing Spark 3.1.0 and I noticed that if you take the log(NaN) it now
> returns a null whereas in Spark 3.0 it returned a NaN. I'm not an expert in
> this but I thought NaN was correct.
> Spark 3.1.0 Example:
> >>> df.selectExpr(["value", "log1p(value)"]).show()
> +--------------+-----------------+
> | value| LOG1P(value)|
> +--------------+-----------------+
> |-3.4028235E38| null|
> |3.4028235E38|88.72283906194683|
> | 0.0| 0.0|
> | -0.0| -0.0|
> | 1.0|0.6931471805599453|
> | -1.0| null|
> | NaN| null|
> +--------------+-----------------+
>
> Spark 3.0.0 example:
>
> +-------------+------------------+
> | value| LOG1P(value)|
> +-------------+------------------+
> |-3.4028235E38| null|
> | 3.4028235E38| 88.72283906194683|
> | 0.0| 0.0|
> | -0.0| -0.0|
> | 1.0|0.6931471805599453|
> | -1.0| null|
> | NaN| NaN|
> +-------------+------------------+
>
> Note it also does the same for log1p, log2, log10
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
