Jacky Yin created CALCITE-4599:
----------------------------------

             Summary: Is there any plan to support "date histogram aggregation"?
                 Key: CALCITE-4599
                 URL: https://issues.apache.org/jira/browse/CALCITE-4599
             Project: Calcite
          Issue Type: Improvement
          Components: elasticsearch-adapter
            Reporter: Jacky Yin


"date histogram aggregation" is one of the 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)

Reply via email to