Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30375 Feature Parity between PostgreSQL and Spark (implementation-dependent behaviours)
  3. SPARK-28137

Data Type Formatting Functions: `to_number`

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.3.0
    • SQL
    • None

    Description

      Function Return Type Description Example
      to_number(text, text) numeric convert string to numeric to_number('12,454.8-', '99G999D9S')

      https://www.postgresql.org/docs/12/functions-formatting.html

      Attachments

        Issue Links

          is a child of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. SPARK-38783 New functions in Spark SQL 3.3

          • Major - Major loss of function.
          • Open
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. SPARK-29214 Oracle sql's to_number equivalent in spark sql

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Resolved
          relates to

          Sub-task - The sub-task of the issue SPARK-28516 Data Type Formatting Functions: `to_char`

          • Major - Major loss of function.
          • Resolved
          links to

          Pull request #31448 [Github] Pull Request #31448 (beliefer)

          Pull request #35060 [Github] Pull Request #35060 (beliefer)

          Web Link GitHub Pull Request #25963

          Activity

            People

              beliefer Jiaan Geng
              yumwang Yuming Wang
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: