spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oleg Bonar (Jira)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-28315) Decimal can not accept NaN as input
Date Thu, 19 Dec 2019 08:55:00 GMT

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

Oleg Bonar commented on SPARK-28315:
------------------------------------

Seems like it's not possible or unreasonably difficult since neither Java's BigDecimal nor
Sparks's Decimal can hold NaN values.

> Decimal can not accept NaN as input
> -----------------------------------
>
>                 Key: SPARK-28315
>                 URL: https://issues.apache.org/jira/browse/SPARK-28315
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> PostgreSQL
> {code:sql}
> postgres=# SELECT 'NaN', 'Nan', 'nan'::numeric;
>  ?column? | ?column? | numeric
> ----------+----------+---------
>  NaN      | Nan      |     NaN
> (1 row)
> {code}
> Spark SQL
> {code:sql}
> spark-sql>  SELECT decimal('NaN'), decimal('Nan'), decimal('nan');
> NULL	NULL	NULL
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message