[SPARK-28315] Decimal can not accept NaN as input

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 09/Jul/19 09:12
• Updated: 29/Mar/20 02:24

Description

PostgreSQL

postgres=# SELECT 'NaN', 'Nan', 'nan'::numeric;
 ?column? | ?column? | numeric
----------+----------+---------
 NaN      | Nan      |     NaN
(1 row)

Spark SQL

spark-sql>  SELECT decimal('NaN'), decimal('Nan'), decimal('nan');
NULL	NULL	NULL