You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/04/16 03:11:58 UTC

[jira] [Created] (CALCITE-683) String aggregates

Julian Hyde created CALCITE-683:
-----------------------------------

             Summary: String aggregates
                 Key: CALCITE-683
                 URL: https://issues.apache.org/jira/browse/CALCITE-683
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


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
(v6.3.4#6332)