[ https://issues.apache.org/jira/browse/HIVE-26889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17683508#comment-17683508 ]
Sai Hemanth Gantasala commented on HIVE-26889: ---------------------------------------------- Fix has been merged to the master. Thanks for your contribution [~tarak271] > Implement array_join udf to concatenate the elements of an array with a > specified delimiter > ------------------------------------------------------------------------------------------- > > Key: HIVE-26889 > URL: https://issues.apache.org/jira/browse/HIVE-26889 > Project: Hive > Issue Type: Sub-task > Components: Hive > Reporter: Taraka Rama Rao Lethavadla > Assignee: Taraka Rama Rao Lethavadla > Priority: Minor > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 2h 10m > Remaining Estimate: 0h > > *array_join(array, delimiter, replaceNull)* - concatenate the elements of an > array with a specified delimiter > Example: > {noformat} > > 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{noformat} > Returns NULL if array is null/empty -- This message was sent by Atlassian Jira (v8.20.10#820010)