diff options
| author | Michael Armbrust <michael@databricks.com> | 2014-11-14 14:56:57 -0800 |
|---|---|---|
| committer | Michael Armbrust <michael@databricks.com> | 2014-11-14 14:56:57 -0800 |
| commit | a0300ea32a9d92bd51c72930bc3979087b0082b2 (patch) | |
| tree | dc36ed60c3b9bfbdc3c5a14a4bacf6b761f7fa91 /sql/hive | |
| parent | 5930f64bf0d2516304b21bd49eac361a54caabdd (diff) | |
| download | spark-a0300ea32a9d92bd51c72930bc3979087b0082b2.tar.gz spark-a0300ea32a9d92bd51c72930bc3979087b0082b2.tar.bz2 spark-a0300ea32a9d92bd51c72930bc3979087b0082b2.zip | |
[SPARK-4390][SQL] Handle NaN cast to decimal correctly
Author: Michael Armbrust <michael@databricks.com>
Closes #3256 from marmbrus/NanDecimal and squashes the following commits:
4c3ba46 [Michael Armbrust] fix style
d360f83 [Michael Armbrust] Handle NaN cast to decimal
Diffstat (limited to 'sql/hive')
| -rw-r--r-- | sql/hive/src/test/resources/golden/NaN to Decimal-0-6ca781bc343025635d72321ef0a9d425 | 1 | ||||
| -rw-r--r-- | sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/HiveQuerySuite.scala | 3 |
2 files changed, 4 insertions, 0 deletions
diff --git a/sql/hive/src/test/resources/golden/NaN to Decimal-0-6ca781bc343025635d72321ef0a9d425 b/sql/hive/src/test/resources/golden/NaN to Decimal-0-6ca781bc343025635d72321ef0a9d425 new file mode 100644 index 0000000000..7951defec1 --- /dev/null +++ b/sql/hive/src/test/resources/golden/NaN to Decimal-0-6ca781bc343025635d72321ef0a9d425 @@ -0,0 +1 @@ +NULL diff --git a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/HiveQuerySuite.scala b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/HiveQuerySuite.scala index 684d22807c..0dd766f253 100644 --- a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/HiveQuerySuite.scala +++ b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/HiveQuerySuite.scala @@ -56,6 +56,9 @@ class HiveQuerySuite extends HiveComparisonTest with BeforeAndAfter { Locale.setDefault(originalLocale) } + createQueryTest("NaN to Decimal", + "SELECT CAST(CAST('NaN' AS DOUBLE) AS DECIMAL(1,1)) FROM src LIMIT 1") + createQueryTest("constant null testing", """SELECT |IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL1, |