Looks like SQL query is not cached, and equivalent dsl qeury is cached. Every single time this SQL query is executed, it takes over 3 seconds. (The number of documents is about 6,000,000) POST /_sql?format=json { "query": "SELECT HISTOGRAM(\"batchDate\", INTERVAL 1 DAY) AS \"h_date…

@c81b4c93b1f70af5398f no, you cannot control the name of the generated aggregation in a query, everything is transparent and ES SQL should behave just like any other SQL facing tool. I've created a github issue and we'll discuss internally if this is feasible to implement: https://github.com/elasti…

Discuss the Elastic Stack

Elasticsearch 7.0 SQL ACCESS request cache

Elastic Stack Elasticsearch

nuwan (Nuwan Vithanage) June 24, 2019, 12:15pm 10

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.