You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by Jacky Yin 殷传旺 <ja...@eoitek.com> on 2021/05/07 14:26:10 UTC

Is there any plan to support 'date histogram' push down in elastic search adapter?

Hello All,


"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 in calcite.  One possible option is TUMBLE function. Is it right?