You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Ian (JIRA)" <ji...@apache.org> on 2016/03/07 23:06:40 UTC
[jira] [Created] (SPARK-13731) expression evaluation for NaN in
select statement
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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org