[HIVE-26889] Implement array_join udf to concatenate the elements of an array with a specified delimiter

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-beta-1
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 24/Dec/22 14:52
• Updated: 15/Aug/23 06:33
• Resolved: 02/Feb/23 17:46

Description

array_join(array, delimiter, replaceNull) - concatenate the elements of an array with a specified delimiter
Example:

> SELECT array_join(array(1, 2, 3,4), ',') FROM src LIMIT 1;
1,2,3,4
> SELECT array_join(array(1, 2, NULL, 4), ',',':') FROM src LIMIT 1;
1,2,:,4

Returns NULL if array is null/empty

Issue Links

• links to: GitHub Pull Request #3896