[IMPALA-5030] add NVL2()

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 2.9.0
• Component/s: Backend, Frontend
• Labels: built-in-function compatibility ramp-up sql-language
• Assignee: Vincent Tran
• Reporter: Greg Rahn
• Created: 05/Mar/17 23:55
• Updated: 06/Jul/17 21:36
• Resolved: 03/Jun/17 02:26

Description

nvl2(x,y,z)
Returns the second argument if the first argument is not null, otherwise it returns the third argument.
nvl2 is short hand for the case expression “case when x is not null then y else z end.”

References:
http://docs.oracle.com/database/122/SQLRF/NVL2.htm#SQLRF00685