[
https://issues.apache.org/jira/browse/HIVE-2633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13283873#comment-13283873
]
Edward Capriolo commented on HIVE-2633:
---------------------------------------
We have this. It is called concat_wc.
> Implement a Join_Array Functions within Hive. Join Elements of the Array with
> a delimiter and return a string.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-2633
> URL: https://issues.apache.org/jira/browse/HIVE-2633
> Project: Hive
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 0.7.1
> Environment: New feature for Hive QL
> Reporter: John Omernik
> Labels: SQL
>
> When working with arrays, there are times where it would be very beneficial
> to take the results of an array generating functions such as collect_set and
> convert that to a delimited string for text processing. In Perlish Pseudo
> code, the function would work as follows:
> sub array_join($delimiter (string), @input_array(array)){
> my $outputvar = '';
> foreach my $array_item(@input_array){
> $outputvar = $outputvar.$array_item.$delimeter;
> }
> $outputvar =~ s/$delimeter$//;
> return $outputvar;
> }
> Basically, pass the function a string to delimit items, and the array, and
> return the results. Perhaps there can be a limit of sum sort imposted on the
> return string to alleviate memory concerns, maybe that limit could be
> defaulted, and then overridden.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
