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

Null types should be implicitly casted to Decimal types

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

      A query below fails in master/branch-3.0 and passed in v2.4.5;

      scala> Seq(BigDecimal(10)).toDF("v1").selectExpr("v1 = NULL").explain(true)
      org.apache.spark.sql.AnalysisException: cannot resolve '(`v1` = NULL)' due to data type mismatch: differing types in '(`v1` = NULL)' (decimal(38,18) and null).; line 1 pos 0;
      'Project [(v1#5 = null) AS (v1 = NULL)#7]
      +- Project [value#2 AS v1#5]
         +- LocalRelation [value#2]
      ...
      

      Attachments

        Issue Links

          Activity

            People

              maropu Takeshi Yamamuro
              maropu Takeshi Yamamuro
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: