hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (HIVE-937) CONCAT UDF for GROUP BY
Date Tue, 17 Nov 2009 19:20:40 GMT

     [ https://issues.apache.org/jira/browse/HIVE-937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Adam Kramer resolved HIVE-937.

    Resolution: Duplicate

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

View raw message