All Questions
12 questions
0
votes
1
answer
44
views
Elastic Search Query to filter records where value in 2 columns of the record are equal
I am working with Elastic Search Version 6.8.22 and have an index where I have 2 columns: Column A and Column B. I want to filter out all records where values for Column A is equal to Column B. How ...
1
vote
0
answers
161
views
Elasticsearch search by substring in array
I have the following object in the elastic search and I am trying to find any tags.name that contains a substring. I've tried getting all the tags first and then putting in an aggregate and filter, ...
0
votes
0
answers
113
views
ElasticSearch exclude with if condition
I am trying to write a query that gives me results with the following condition:
get all user data with multiple statues but on certain status, only get it if another filed equals some value.
user ...
0
votes
1
answer
420
views
Elasticsearch: Filter the records based on nested field with nested field containing only the filtered object
I am trying to filter the records based on nested field and want only the matching object in that array to be shown as part of the record.
Below is the detailed explanation of my requirement.
So, I ...
0
votes
1
answer
120
views
How to get total records with pagination in Elasticsearch
In my product index I have 60K records, I'm running a match query with from, size params. by default, ES support a 10k record search so I have increased it to 60k.
My issue is I'm already passing size ...
- 1,626
0
votes
0
answers
267
views
Approximate aggregation results in elasticsearch
I have an index with 10M documents with nearly 1M unique names and 20 shards, when I use terms aggregation it produces an approximate aggregation result as an CURL request, but when I try to replicate ...
- 13
1
vote
1
answer
4k
views
Elasticsearch: QueueResizingEsThreadPoolExecutor exception
At some point during 35k endurance load test of my java web app which fetches static data from Elasticsearch, I am start getting following elasticsearch exception:
Caused by: org.elasticsearch.common....
- 1,701
0
votes
0
answers
50
views
Elasticsearch : _tasks is not giving msearch taskid everytime
I want to cancel msearch running query. I am running this query to get task id of msearch query:
curl -XGET "localhost:9200/_tasks?actions=*search&detailed&pretty"
When I run this query, ...
1
vote
1
answer
2k
views
Elasticsearch entity centric indexing
does anyone have any experience with entity centric indexing with elasticsearch by using python and groovy scripts for reindex the event centric index into entity centric indexes where every log ...
- 325
-1
votes
2
answers
197
views
ElasticSearch Convert Rest Query TO Transport Client Java Code
Thanks in Advance for Help,
I have created a elastic search _search query as below :
{
"size" : 0,
"aggs": {
"attrs_root": {
"nested": {
"path": "tags"
},
"aggs": ...
- 2,572
0
votes
0
answers
883
views
phrase prefix query does not work
I have a simple documents that get inserted by mongodb directly, it look like this:
PUT /office_db/employee/1
{
"employeeId": "5b5fc605357d0c6",
"formalName": "mark rose",
"socialNumber": ...
- 95
0
votes
1
answer
703
views
How to calculate the total number of buckets that have "value" greater than 0?
I have this query that calculates the number of events per bucket. How can I calculate the total number of buckets that have value greater than 0?
GET myindex/_search?
{
"size": 0,
"query": {
...
- 8,648