hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2633) Implement a Join_Array Functions within Hive. Join Elements of the Array with a delimiter and return a string.
Date Sat, 26 May 2012 01:55:23 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13283876#comment-13283876
] 

Edward Capriolo commented on HIVE-2633:
---------------------------------------

concat_ws sorry.
                
> 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

        

Mime
View raw message