[
https://issues.apache.org/jira/browse/TAJO-2160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15364204#comment-15364204
]
Hudson commented on TAJO-2160:
------------------------------
FAILURE: Integrated in Tajo-master-CODEGEN-build #747 (See
[https://builds.apache.org/job/Tajo-master-CODEGEN-build/747/])
TAJO-2160: Implement string_agg function. (jhkim: rev
9cf9f7516c41e9724c425c309c800c065a4d9002)
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/function/TestBuiltinFunctions.java
* tajo-core/src/main/proto/InternalTypes.proto
* tajo-core/src/main/java/org/apache/tajo/engine/function/builtin/StringAgg.java
* CHANGES
> 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)
