hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brock Noland (JIRA)" <>
Subject [jira] [Commented] (HIVE-6107) Introduce nvl2 UDF similar to Oracle
Date Fri, 27 Dec 2013 22:00:51 GMT


Brock Noland commented on HIVE-6107:


Sorry, I should have been more clear. The comment I left was meant for other Hive committers.
Long story short there is a lot of context regarding teradata + the other UDF that is not

Therefore when implementing UDFs based on a commercial system like Oracle, we should do some
work to ensure the udf name and functionality are not Oracle IP before committing this change.

> Introduce nvl2 UDF similar to Oracle
> ------------------------------------
>                 Key: HIVE-6107
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>            Reporter: Kostiantyn Kudriavtsev
>            Priority: Minor
>         Attachments: hive-6107.patch
> Introduce new UDF:
> nvl2 : extends the functionality found in the NVL function. It lets you substitutes a
value when a null value is encountered as well as when a non-null value is encountered.
> NVL2( string1, value_if_NOT_null, value_if_null )

This message was sent by Atlassian JIRA

View raw message