[jira] Commented: (HIVE-937) CONCAT UDF for GROUP BY

["Namit Jain (JIRA)" <ji...@apache.org>]

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

Namit Jain commented on HIVE-937:
---------------------------------

@Adam,

this is already supported, look at concat_ws which takes in a separator as the first argument.
Let us know if it does not suffice for you.

> CONCAT UDF for GROUP BY
> -----------------------
>
>                 Key: HIVE-937
>                 URL: https://issues.apache.org/jira/browse/HIVE-937
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Adam Kramer
>
> It would be nice to have a UDF like CONCAT for GROUP BY.
> For example,
> SELECT user, CONCAT(post) AS posts
> FROM tablename
> GROUP BY user
> ...which would return all of the posts concatenated together, separated by a single whitespace. So if the table was like this:
> user\tpost
> 1\tHi there this is my first post
> 1\tpost number two
> 2\tI'm a different user!
> then the above code would return
> user\tposts
> 1\tHi there this is my first post post number two
> 2\tI'm a different user!
> Alternate form:
> CONCAT(string text, string separator) which would put the separator between each block of text.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.