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] Created: (HIVE-937) CONCAT UDF for GROUP BY
Date Tue, 17 Nov 2009 11:12:39 GMT
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.


Mime
View raw message