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:14pm 9

yes I did still I'm unable to get the answer for that appreciate if any one help me regarding my concerns Any one setup 3 node cluster with elasticsearch v 7

Thank you

Topic		Replies	Views
SQL Vs. Query DSL Elasticsearch	2	694	March 28, 2022
Query execution time Elasticsearch	4	3935	January 15, 2019
Queries cached Elasticsearch	2	245	July 6, 2017
Search time consistency Elasticsearch	3	307	July 6, 2017
Date histogram cache? Elasticsearch	2	449	July 12, 2019

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.

Elasticsearch 7.0 SQL ACCESS request cache

Related topics