[
https://issues.apache.org/jira/browse/CALCITE-4335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765835#comment-17765835
]
Julian Hyde commented on CALCITE-4335:
--------------------------------------
[~jiabao.sun], Thanks for raising this. Having read the BQ and Postgres doc I
agree; the return type should not be "NOT NULL". Please log a bug and submit a
PR. Please also test that Calcite returns the right result (add a query to
{{agg.iq}}). Does this issue also apply to {{ARRAY_CONCAT_AGG}},
{{STRING_AGG}}, {{LISTAGG}}, {{GROUP_CONCAT}}?
> 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
> Fix For: 1.27.0
>
>
> 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.20.10#820010)
