You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Byunghwa Yun (JIRA)" <ji...@apache.org> on 2016/05/20 07:00:20 UTC
[jira] [Updated] (TAJO-2160) Implement string_agg function.
[ https://issues.apache.org/jira/browse/TAJO-2160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Byunghwa Yun updated TAJO-2160:
-------------------------------
Description:
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.
was:
http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
> 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)