Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-22469

Accuracy problem in comparison with string and numeric

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.2.0
    • 2.2.1, 2.3.0
    • SQL
    • None

    Description

      select '1.5' > 0.5; // Result is NULL in Spark but is true in Hive.

      IIUC, we can cast string as double like Hive.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. SPARK-21646 Add new type coercion rules to compatible with Hive

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

          Bug - A problem which impairs or prevents the functions of the product. SPARK-29274 Should not coerce decimal type to double type when it's join column

          • Major - Major loss of function.
          • In Progress
          links to

          Pull request #19692 [Github] Pull Request #19692 (liutang123)

          Activity

            People

              liutang123 Lijia Liu
              liutang123 Lijia Liu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: