[
https://issues.apache.org/jira/browse/CALCITE-683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chunwei Lei resolved CALCITE-683.
---------------------------------
Resolution: Duplicate
> String aggregates
> -----------------
>
> Key: CALCITE-683
> URL: https://issues.apache.org/jira/browse/CALCITE-683
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Priority: Major
>
> Per http://www.sql-workbench.net/comparison/string_aggregates.html, aggregate
> multiple string values to a single value, optionally delimited.
> {code}select d.department_id,
> d.department_name,
> string_agg(e.first_name, ',' order by first_name) as all_employees
> from departments d
> join employees e on d.department_id = e.department_id
> group by d.department_id
> order by d.department_id;
> department_id | department_name | all_employees
>
> --------------+------------------+-------------------------
> 10 | Road consruction | Prostetnic Vogon Jeltz
>
> 20 | Hiking | Arthur, Ford
> 30 | Shipping | Zaphod
> 40 | Engineering | Marvin, Tricia{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
