I use this Elasticsearch SQL Query from Kibana's Canvas and I hit a hard limit of 1000 results returned every time. SELECT Severity FROM "fwlogs-zayofw*" WHERE Severity LIKE '%medium%' AND ThreatName.keyword IS NOT NULL I even tried adding "limit ALL" at the end of it, and it will still return 100…

Hard Limit on Kibana Elasticsearch SQL?

cufflinks (John Dorlus) March 14, 2019, 10:50pm 6

I think you are correct. Seem seems like 10000 is the hard limit.

Topic		Replies	Views
Kibana CanvasにおけるElasticsearch SQLの検索件数上限について日本語による質問・議論はこちら	3	1882	May 20, 2019
Canvas Charts Limiting Results Kibana	5	309	July 22, 2022
User Limits on queries Elasticsearch	7	1738	July 5, 2017
Elasticsearch SQL aggregation query always return 1,000 results Elasticsearch elastic-stack-sql	4	2247	June 9, 2020
Maximum results pulled in Kibana Kibana	9	1959	July 6, 2017

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.

Hard Limit on Kibana Elasticsearch SQL?

Related topics