[CALCITE-879] COLLECT aggregate function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 07/Sep/15 18:38
• Updated: 27/Feb/24 22:24
• Resolved: 07/Oct/15 19:18

Description

Implement the SQL standard COLLECT aggregate function, including with the DISTINCT keyword. COLLECT creates a multiset of its arguments, for example:

SELECT deptno, COLLECT(ename) AS enames
FROM emp
GROUP BY deptno