[TAJO-381] Implement find_in_set function

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Function/UDF
• Assignee: Jae Young Lee
• Reporter: Jae Young Lee
• Created: 05/Dec/13 07:16
• Updated: 28/Dec/13 21:45
• Resolved: 28/Dec/13 16:14

Description

find_in_set(str,str_array) - Returns the first occurrence of str in str_array where str_array is a comma-delimited string.
Returns null if either argument is null. Returns 0 if the first argument has any commas.

Example:
"select find_in_set('cr','crt,c,cr,c,def') as col1 "
-> result: 3