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

Division operator support integral division

    XMLWordPrintableJSON

Details

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

    Description

      PostgreSQL, Teradata, SQL Server, DB2 and Presto perform integral division with the / operator.
      But Oracle, Vertica, Hive, MySQL and MariaDB perform fractional division with the / operator.

      We need add a flag(spark.sql.function.preferIntegralDivision) to control whether to use integral division with the / operator.

       

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. SPARK-2659 HiveQL: Division operator should always perform fractional division

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. SPARK-16323 Avoid unnecessary cast when doing integral divide

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link GitHub Pull Request #25158

          Web Link GitHub Pull Request #25376

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: