[CALCITE-683] String aggregates

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.20.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 16/Apr/15 01:11
• Updated: 22/Oct/20 21:50
• Resolved: 02/Apr/19 02:09

Description

Per http://www.sql-workbench.net/comparison/string_aggregates.html, aggregate multiple string values to a single value, optionally delimited.

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

Issue Links

• is duplicated by: CALCITE-2754 LISTAGG support
• is related to: CALCITE-4335 Aggregate functions for BigQuery