[
https://issues.apache.org/jira/browse/CALCITE-2528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrei Sereda updated CALCITE-2528:
-----------------------------------
Description:
Translate SQL {{GROUP BY}} and aggregate functions {{sum / min / max}} into
Elastic
[Terms|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html]
and [Metric
aggregations|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics.html].
h3. Examples
{code:sql}
select col1, sum(col2) from elastic group by col1
select count(*) from elastic
{code}
was:
Translate SQL to
[Terms|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html]
and [Metric
aggregations|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics.html].
h3. Examples
{code:sql}
select col1, sum(col2) from elastic group by col1
select count(*) from elastic
{code}
> Support Aggregates in ElasticSearch adapter
> -------------------------------------------
>
> Key: CALCITE-2528
> URL: https://issues.apache.org/jira/browse/CALCITE-2528
> Project: Calcite
> Issue Type: Bug
> Components: elasticsearch-adapter
> Reporter: Andrei Sereda
> Assignee: Julian Hyde
> Priority: Major
>
> Translate SQL {{GROUP BY}} and aggregate functions {{sum / min / max}} into
> Elastic
> [Terms|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html]
> and [Metric
> aggregations|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics.html].
> h3. Examples
> {code:sql}
> select col1, sum(col2) from elastic group by col1
> select count(*) from elastic
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
