[SPARK-8205] conditional function: nvl

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: SQL
• Target Version/s: 1.5.0
• Sprint: Spark 1.5 release
• Assignee: Reynold Xin
• Reporter: Reynold Xin
• Created: 09/Jun/15 06:33
• Updated: 12/Jun/15 00:07
• Resolved: 12/Jun/15 00:07

Description

nvl(T value, T default_value): T

Returns default value if value is null else returns value (as of HIve 0.11).

We already have this (called Coalesce). Just need to register an alias for it in FunctionRegistry.