[
https://issues.apache.org/jira/browse/CALCITE-4335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17218482#comment-17218482
]
Julian Hyde commented on CALCITE-4335:
--------------------------------------
Almost there with {{STRING_AGG}}, {{ARRAY_AGG}}, {{ARRAY_CONCAT_AGG}}.
I'm cursing BigQuery for putting {{ORDER BY}} and {{RESPECT NULLS}} before the
parentheses. It means that their aggregate functions have a different syntax to
ordinary functions. Previously we were able to parse built-in aggregate
functions (e.g. {{SUM}}) and user-defined aggregate functions alike as just
regular functions.
We're not going to do {{LIMIT}} in this iteration. (We can do {{ORDER BY}}
because it maps to the existing {{WITHIN GROUP}} clause, but that clause does
not support {{LIMIT}}.)
> Aggregate functions for BigQuery
> --------------------------------
>
> Key: CALCITE-4335
> URL: https://issues.apache.org/jira/browse/CALCITE-4335
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Priority: Major
>
> Add aggregate functions for BigQuery
> ([spec|https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions]):
> {{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}}.)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
