[
https://issues.apache.org/jira/browse/CALCITE-3568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16997145#comment-16997145
]
Divyanshu Srivastava edited comment on CALCITE-3568 at 12/16/19 10:32 AM:
--------------------------------------------------------------------------
Executed on Hive,
{code:sql}
hive> select sum(count(1));
FAILED: SemanticException [Error 10128]: Line 1:11 Not yet supported place for
UDAF 'count'
{code}
was (Author: divyanshu.s95):
Executed on Hive,
{panel
{code:sql}
hive> select sum(count(1));
FAILED: SemanticException [Error 10128]: Line 1:11 Not yet supported place for
UDAF 'count'
{code}
}
> 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: 3h 20m
> 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)
