[
https://issues.apache.org/jira/browse/CALCITE-3568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16989073#comment-16989073
]
Rui Wang commented on CALCITE-3568:
-----------------------------------
Replied in the PR but also add one note there.
I am more familiar with BigQuery and have access to BigQuery resources. I
verified BigQuery by running a query and it does not support nested
aggregation. BigQuery doc also does not mention the support of this feature
([https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions])
> BigQuery, Hive, Spark SQL dialect don't support nested aggregates
> -----------------------------------------------------------------
>
> Key: CALCITE-3568
> URL: https://issues.apache.org/jira/browse/CALCITE-3568
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Divyanshu Srivastava
> Assignee: Divyanshu Srivastava
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.22.0
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> The BigQuerySqlDialect, HiveSqlDialect, SparkSqlDialect do not support nested
> aggregates, hence overriding the supportsNestedAggregations() method in them.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
