[
https://issues.apache.org/jira/browse/TAJO-2160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15364202#comment-15364202
]
ASF GitHub Bot commented on TAJO-2160:
--------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/tajo/pull/1029
> Implement string_agg function.
> ------------------------------
>
> Key: TAJO-2160
> URL: https://issues.apache.org/jira/browse/TAJO-2160
> Project: Tajo
> Issue Type: New Feature
> Components: Function/UDF
> Affects Versions: 0.11.3
> Reporter: Byunghwa Yun
> Priority: Minor
> Fix For: 0.12.0, 0.11.3
>
>
> I'll implement to concatenate the strings of a field within a group by query.
> I have a table:
> ID COMPANY_ID EMPLOYEE
> 1 1 Anna
> 2 1 Bill
> 3 2 Carol
> 4 2 Dave
> and I wanted to group by company_id to get something like:
> SELECT company_id, string_agg(employee, ', ')
> FROM mytable
> GROUP BY company_id;
> COMPANY_ID EMPLOYEE
> 1 Anna, Bill
> 2 Carol, Dave
> PostgreSQL supports string_agg function.
> http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
> Thank you.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
