[ 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)