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

Spark2.0-error occurs when execute the sql statement which includes "nvl" function while spark1.6 supports

    XMLWordPrintableJSON

Details

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

    Description

      Spark2.0-error occurs when execute the sql statement which includes "nvl" function while spark1.6 supports

      Error: org.apache.spark.sql.AnalysisException: cannot resolve 'nvl(b.`new_user`, 0)' due to data type mismatch: input to function coalesce should all be the same type, but it's [string, int]; line 2 pos 73 (state=,code=0)

      Attachments

        Activity

          People

            dongjoon Dongjoon Hyun
            marymwu marymwu
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: