Translate SQL GROUP BY and aggregate functions sum / min / max into Elastic Terms and Metric aggregations.
select col1, sum(col2), max(col3) from elastic group by col1
select count(*) from elastic
Enable aggregate functions in Elasticsearch adapter
Add support for aggregates in Calcite Elasticsearch adapter
ConcurrentModificationException may be triggered in ElasticsearchProject