[ https://issues.apache.org/jira/browse/CALCITE-4335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17219354#comment-17219354 ]
Julian Hyde commented on CALCITE-4335: -------------------------------------- STRING_AGG, ARRAY_AGG and ARRAY_CONCAT_AGG are fixed in [3038fb7e|https://github.com/apache/calcite/commit/3038fb7e87c51740ef733fd4f9bde41b0c25e5b0]. Only {{COUNTIF}} remains, and should be done shortly; will leave this case open until then. > 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)