20 questions
0
votes
1
answer
448
views
Handle response from SQL query in Elastic.Clients.Elasticsearch 8.1.0 for .NET
I have an Elasticsearch cluster, which e.g. contains an index called persons. I want to query the documents of the index using the SQL API of Elasticsearch. When using the REST API of Elasticsearch ...
- 399
0
votes
1
answer
635
views
elasticsearch SQL query in python
elasticsearch == 7.16.1
Trying to run a very simple query just to try out the SQL implementation w/python.
es.sql.query(body={'query':'select * from index_name-* limit 100'})
Getting this error:
...
- 1,715
0
votes
0
answers
141
views
Cannot get cardinality count in elasticsearch
I am not able to get cardinality of a field from an elasticsearch index.
The mapping is as follows:
And the query which I am trying to fire is as follows:
--header 'Content-Type: application/json' \
-...
- 280
2
votes
1
answer
6k
views
Use SQL Access in Elasticsearch python client
I am trying to use the python client for elastic search to query an index using SQL access for elastic search. I want to query an index using sql syntax. How do i specify to elasticsearch that it has ...
1
vote
0
answers
174
views
How to do an Elasticsearch SQL query for geo_point data
I have an ES index which contains a mapping of type geo_point. I want to use the Elasticsearch SQL API to do a bounding box query.
I know how to do this using ES DSL as per the ES docs.
How would ...
- 438
0
votes
1
answer
489
views
Elasticsearch 7 SQL CLI : ./x-pack-env: No such file or directory error
I have started working on Elasticsearch 7 and trying to start the elasticsearch-sql-cli using the following command:
~/Documents/backups/es7/bin$ ./elasticsearch-sql-cli
But it is not started and ...
- 14k
0
votes
4
answers
259
views
SQL like GROUP BY AND HAVING example
I am new to ES and i would need to make a query
Select value
from table
group by value
having count(distinct(id)) > 1
I do not even have areas to start. referencing this SQL like GROUP BY AND ...
- 4,365
5
votes
2
answers
3k
views
Elasticsearch SQL-Query not possible
I got a ElasticSearch Instance running locally which works fine. Now I want to query an index using SQL. I tried it with the NodeJS-Client (v7) and normally via the REST-Api.
Rest call:
POST http://...
- 405
0
votes
1
answer
1k
views
Unable to perform SQL search on logstash index in kibana
I have below indexes in the kibana when searched with below query.
GET /_xpack/sql?format=txt
{
"query": "SHOW tables"
}
Output:
name | type
----------------...
2
votes
3
answers
7k
views
Return all rows in a Elasticsearch SQL query
I have a simple SQL query in Elasticsearch which I know returns less than 100 rows of results. How can I get all these results at once (i.e., without using scroll)? I tried the limit n clause but it ...
- 2,001