[
https://issues.apache.org/jira/browse/CALCITE-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17342126#comment-17342126
]
Julian Hyde commented on CALCITE-4599:
--------------------------------------
In Calcite, we use JIRA to plan. This is the first JIRA case that mentions
"date_histogram", ergo, there is no plan.
[~jackyyin], Can you please change the title so that it reads like a feature
request, not a question.
> Is there any plan to support "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.
> "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?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
