Ian created SPARK-13731:
---------------------------
Summary: expression evaluation for NaN in select statement
Key: SPARK-13731
URL: https://issues.apache.org/jira/browse/SPARK-13731
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.6.0
Reporter: Ian
We are expecting arithmetic expression a/b should be:
1. returning NaN if a=0 and b=0
2. returning Infinity if a=1 and b=0
Is the expectation reasonable?
The following is a simple test case snippet that read from storage and evaluate
arithmetic in select.
It si assuming org.apache.spark.sql.hive.execution.SQLQuerySuite:
{code}
test("Expression should be evaluated to Nan/Infinity in Select") {
withTable("testNan") {
withTempTable("src") {
Seq((1d, 0d), (0d, 0d)).toDF().registerTempTable("src")
sql("CREATE TABLE testNan(a double, b double) STORED AS PARQUET AS
SELECT * FROM src")
}
checkAnswer(sql(
"""
|SELECT a/b FROM testNan
""".stripMargin),
Seq(
Row(Double.PositiveInfinity),
Row(Double.NaN)
)
)
}
}
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
