[HIVE-512] [GenericUDF] new string function ELT(N,str1,str2,str3,...)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.4.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Min Zhou
• Reporter: Min Zhou
• Created: 24/May/09 13:05
• Updated: 17/Dec/11 00:07
• Resolved: 20/Jul/09 17:04

Description

ELT(N,str1,str2,str3,...)

Returns str1 if N = 1, str2 if N = 2, and so on. Returns NULL if N is less than 1 or greater than the number of arguments. ELT() is the complement of FIELD().

mysql> SELECT ELT(1, 'ej', 'Heja', 'hej', 'foo');
        -> 'ej'
mysql> SELECT ELT(4, 'ej', 'Heja', 'hej', 'foo');
        -> 'foo'

Issue Links

• is part of: HIVE-615 new user functions needed for HIVE