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.
