elasticsearch-aggregation Questions
6
How can I add a new key called 'agency_name' in my output bucket.
I am running an aggregation code as shown below
{
"aggs": {
"name": {
"terms": {
"field": "agency_code"
}
}
}
}
I will ...
Vaulted asked 30/7, 2015 at 10:50
1
Solved
I have created a file ie., testfile.painless
ctx._source.b_id=params.b_id;
and just placed the testfile.painless file in the config/scripts folder on cluster node and then tried with _update_by_qu...
Deese asked 23/8, 2023 at 18:59
2
Solved
I am using elastic search version 6.0.0
for group by month, I am using date histogram aggregation.
example which I've tried :
{
"from":0,
"size":2000,
"_source":{
"includes":[
"cost",
"da...
Bleacher asked 16/8, 2018 at 8:8
1
Elasticsearch supports fuzzy search queries: https://www.elastic.co/guide/en/elasticsearch/guide/2.x/fuzzy-match-query.html
And Bucket Aggregation by Term: https://www.elastic.co/guide/en/elastics...
Deme asked 21/7, 2016 at 5:51
1
Solved
I'm trying to use ElasticSearch v. 7.11.1 on Windows 10. I don't know how to make multi_terms aggregation work. This query:
{
"aggs": {
"test_agg": {
"multi_terms":...
Guarneri asked 6/5, 2021 at 18:8
1
Solved
I have an index of SendGrid event data:
"_source": {
"externalId": "9283cc1d-b003-xxxx-a5af-84fcf31c4181",
"email": "[email protected]",
&q...
Urba asked 26/3, 2021 at 12:47
1
Solved
I tried two different approaches for creating index and both are returning anything if I search for part o the word. Basically, if I search for first letters or letters in the middle of the word I ...
Enstatite asked 8/5, 2020 at 23:28
1
Solved
I would like to aggregate a list of documents (each of them has two fields - timestamp and amount) by "amount" field until a certain value is reached. For example I would like to get list of docume...
Annadiana asked 16/5, 2019 at 9:17
3
There is way to get the top n terms result. For example:
{
"aggs": {
"apiSalesRepUser": {
"terms": {
"field": "userName",
"size": 5
}
}
}
}
Is there any way to set the ...
Stonemason asked 2/4, 2015 at 12:11
2
Solved
There is a list of conversations and every conversation has a list of messages. Every message has different fields and an action field. We need to consider that in the first messages of the convers...
Satellite asked 12/3, 2020 at 9:13
3
Solved
I am working on ES recently and I found that I could achieve the almost same result but I have no clear idea as to the DIFFERENCE between these two.
"Filter then Aggregation"
POST kibana_sample_...
Mastoid asked 27/8, 2019 at 2:52
1
Solved
In Elasticsearch there's a limit on how many buckets you can create in an aggregation. If it creates more buckets than the specified limit, you will get a warning message In ES 6.x and an error wil...
Synthiasyntonic asked 7/8, 2019 at 11:36
1
Solved
I have a collection of documents, where each document indicates the available rooms for a given hotel and day, and their cost for that day:
{
"hotel_id": 2016021519381313,
"day": "20200530",
"...
Beautiful asked 24/7, 2019 at 17:13
1
Return only matched source instead of returning the whole document of elastic search that contain that text
Suppose I have a data in this format,
POST /bookdb_index/book/_bulk
{ "index": { "_id":...
Cohn asked 18/7, 2019 at 16:28
0
I'm trying to use total hit count with the bucket_script aggregation as sub aggregation of terms aggregation. Any suggestions are welcome.
I also tried value_count and terms aggregation on the pac...
Evie asked 29/5, 2019 at 7:54
0
The task is to calculate user retention in elastic search. I have documents which contain user id and inside that an array where each element shows some interaction with the system. Each element in...
Telephotography asked 14/5, 2019 at 5:34
1
Solved
I am exploring ElasticSearch, to be used in an application, which will handle large volumes of data and generate some statistical results over them. My requirement is to retrieve certain statistics...
Shannashannah asked 12/2, 2019 at 11:44
1
Solved
I am working on an ElasticSearch (6.2) project where the index has many keyword fields and they are normalized with lowercase filter for performing case-insensitive searches. The search working gre...
Insert asked 3/8, 2018 at 1:44
1
Solved
I need to compute a pipeline aggregation in ElasticSearch and I can't figure out how to express it.
Each document has an email address and an amount. I need to output range buckets of amount count...
Guv asked 19/6, 2018 at 21:57
1
Solved
On my Elasticsearch server I have three indices: Person, Archive and Document.
Each document has a archive field which is the _id of the Archive it is in.
Each archive has a owner which is the _i...
Homan asked 12/1, 2018 at 14:45
2
Solved
I have a bunch of company data in an ES database. I am looking to pull counts of how many documents each company occurs in, but I'm having some problems with the aggregation query. I am looking to ...
Ridgway asked 1/4, 2014 at 20:24
1
Solved
I have terms query as follow in elastic search.
GET http://localhost:9200/adapters/request/_search
{
"query": {
"bool" : {
"must" : {
"match" : { "adapterName" : "EnginePushableAdapter" }
},
...
Retrospective asked 13/4, 2017 at 11:57
1
The goal is to build an Elasticsearch index with only the most recent documents in groups of related documents to track the current state of some monitoring counters and states.
I have crafted a s...
Dare asked 8/4, 2016 at 17:10
1
Solved
Say I have this bool query:
"bool" : {
"should" : [
{ "term" : { "FirstName" : "Sandra" } },
{ "term" : { "LastName" : "Jones" } }
],
"minimum_should_match" : 1
}
meaning I want to match al...
Filagree asked 8/1, 2017 at 17:35
1
Solved
I'm using Elasticsearch 2.3 and I'm trying to perform a two-step computation using a pipeline aggregation.
I'm only interested in the final result of my pipeline aggregation but Elasticsearch retur...
Goodall asked 28/6, 2016 at 16:36
1 Next >
© 2022 - 2024 — McMap. All rights reserved.