[
https://issues.apache.org/jira/browse/CALCITE-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacky Yin updated CALCITE-4599:
-------------------------------
Description:
"date histogram aggregation" is one of the most popular analysis function of
elastic search. It is not pushed down to elastic search in current calcite es
adapter. Is there any plan to support it? Given the below example, if it can be
pushed down to es, the query should be very efficient.
{code:java}
select count as cc from t group by date_histogram(`@timestamp`, interval '5'
minute){code}
Another question is currently there seems no proper sql function/keyword for
date_histogram. One possible option is TUMBLE function. Is it right?
was:
"date histogram aggregation" is one of the most popular analysis function of
elastic search. It is not pushed down to elastic search in current calcite es
adapter. Is there any plan to support it? Given the below example, if it can be
pushed down to es, the query should be very efficient.
"select count(*) as cc from t group by date_histogram(`@timestamp`, interval
'5' minute)"
Another question is currently there seems no proper sql function/keyword for
date_histogram. One possible option is TUMBLE function. Is it right?
> Support push-down of "date histogram aggregation" in elastic search adapter
> ---------------------------------------------------------------------------
>
> Key: CALCITE-4599
> URL: https://issues.apache.org/jira/browse/CALCITE-4599
> Project: Calcite
> Issue Type: Improvement
> Components: elasticsearch-adapter
> Reporter: Jacky Yin
> Priority: Critical
>
> "date histogram aggregation" is one of the most popular analysis function of
> elastic search. It is not pushed down to elastic search in current calcite es
> adapter. Is there any plan to support it? Given the below example, if it can
> be pushed down to es, the query should be very efficient.
> {code:java}
> select count as cc from t group by date_histogram(`@timestamp`, interval '5'
> minute){code}
> Another question is currently there seems no proper sql function/keyword for
> date_histogram. One possible option is TUMBLE function. Is it right?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
