In our application, our primary use case is to create dynamic queries based on a user's input. Because of the complexity of standard elasticsearch queries, creating a dynamic SQL query is a much better approach. However, when executing SQL queries, the result that's returned lacks some basic meta d…

Just a reply to my own thread here, I am thinking of just creating the SQL query in my code, then just call the _xpack/sql/translate endpoint to just translate the query, then execute that query which gives me my record count (hits) yeah it's two calls to ES, but that first one is really not doing …

@David_Palmer If we would have returned the hits count then you'd have: something that's not really SQL how would have this response looked like? There is support for COUNT(*) but it's not really the same thing.

@Andrei_Stefan - so, i was thinking if the response JSON had the same meta data that the standard queries returns (like the hits) then everything you'd need would be there. So you have your section of the response JSON that contains the rows as it does now, and in the metadata section of the respon…

If we would have hits in there, then this wouldn't be SQL anymore, it would be a differently formatted JSON response from a REST endpoint served by Elasticsearch. In SQL, there is the notion of a cursor, and this is what we are using as well, in the form of cursor field inside the response to be us…

Xpack SQL queries and returning record count

Elastic Stack Elasticsearch

Andrei_Stefan (Andrei Stefan) September 24, 2018, 4:40am 3

@David_Palmer If we would have returned the hits count then you'd have:

something that's not really SQL
how would have this response looked like?

There is support for COUNT(*) but it's not really the same thing.

Topic		Replies	Views
Elastic Search via python gives wrong count Elasticsearch language-clients	3	1140	January 8, 2020
How to fetch the count of the documents from the sql query translate Elasticsearch	1	336	August 5, 2020
SQL interface to Elasticsearch & Aggregation functions Elasticsearch	3	1262	July 6, 2017
Get all results at once in Elasticsearch SQL syntax Elasticsearch	12	5434	December 3, 2018
Get the hit count in EQL Elasticsearch	3	373	July 28, 2023

Xpack SQL queries and returning record count

Related topics