Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-28315

Decimal can not accept NaN as input

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.1.0
    • None
    • SQL
    • None

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            yumwang Yuming Wang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: