[CALCITE-4335] Aggregate functions for BigQuery

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 13/Oct/20 01:30
• Updated: 16/Sep/23 10:28
• Resolved: 01/Nov/20 23:11

Description

Add aggregate functions for BigQuery (spec): ARRAY_AGG, ARRAY_CONCAT_AGG, COUNTIF, LOGICAL_AND, LOGICAL_OR, STRING_AGG.

Calcite already has ANY_VALUE, BIT_AND, BIT_OR, BIT_XOR, MAX, MIN, SUM aggregate functions.

(Edit, 2020/10/15: And, since CALCITE-2935 is fixed, it now has LOGICAL_AND, LOGICAL_OR.)

Issue Links

• depends upon: CALCITE-2935 Add BOOL_OR, BOOL_AND, LOGICAL_OR, LOGICAL_AND aggregate functions
• is related to: CALCITE-4349 Support GROUP_CONCAT aggregate function for MySQL
• relates to: CALCITE-683 String aggregates