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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: SQL
• Assignee: Dongjoon Hyun
• Reporter: marymwu
• Created: 18/Jul/16 11:39
• Updated: 19/Jul/16 17:27
• Resolved: 19/Jul/16 17:27

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)

Issue Links

• links to: [Github] Pull Request #14251 (dongjoon-hyun)