hive on spark 的nvl函数类型一致

报错：[42000][3] Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.spark.SparkTask. Spark job failed during runtime. Please check stacktrace for the root cause.

错误原因：nvl函数(字段，默认值)，要求字段类型与默认值类型必须一致，特别是字段为浮点数时，很容易将默认值写成int类型，必须是 0.0这样的浮点数。