Questions tagged [elasticsearch-aggregation]

0votes
0answers
23views

How to get sum using filter aggregation in elasticsearch

I wanted to calculate the sum of total_stake which status does not Cancelled as per below mentioned table using elasticsearch. Please let me know whether my approach is correct or not. Please let me ...
1vote
1answer
27views

Get members in aggregation bucket ElasticSearch

I'm pretty new to elasticsearch I have a class called SubRequest Mapping: { "sub-request" : { "aliases" : { }, "mappings" : { "properties" : { ...
1vote
0answers
27views

Is there a way to efficiently get three layer aggrigations result in elasticsearch, where each layer is conditioned by above one

I am trying to get composite aggregation for certain feilds which are present in each document. These documents are stored in elastic. Format of each document is a json with below mentioned keys. {&...
0votes
1answer
25views

Elastic search : get count of few fields data

[ {"Exam" : "mid-term 1", "Name": "abc", "Roll no" : "1" , "English" :"Pass", "Hindi" :"Pass" , &...
0votes
1answer
24views

why did the elasticsearch MSI installer disappear?

Why did the elasticsearch MSI installer disappear? They only offer the zip file now. Is there any reason why they remove it?
0votes
0answers
14views

Is it possible to query Elasticsearch against the maximum value of two dates on an index?

I want to create a query where we are given two dates, and I look for values that are less than or equal to (≤) the maximum value of the two dates of the indexed values. e.g. item #1 has a two ...
0votes
0answers
23views

Nest Sum aggregation with sub terms aggregation

I created aggregations includes a terms aggregate with a sum aggregate for each term bucket and will sort on the sum value. This works fine. However if I add a nested terms aggregation which is the ...
0votes
1answer
30views

How to retrieve data from Elasticsearch sub-aggregate search queries

I am trying a multiple sub aggregation query to retrieve a query result on my Elasticsearch index. The query looks somewhat like this. { "query": SEARCH_BODY, "aggs": {'...
0votes
1answer
21views

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 ...
0votes
0answers
19views

Elasticsearch Error get aggregation top_hits source

So I'm trying to achieve the top_hits value to be aggregated in bucket_script but I got the errors like this { "error": { "root_cause": [ { &...
0votes
1answer
24views

Elasticsearch to SQL equivalent, get the first and last documents with filter

I have an issue with elasticsearch documents. So the goal is I need to get the latest data close from index stocks and also the last data close from stocks within a specified date. Here's the example ...
0votes
0answers
13views

Elasticsearch date locale not working consistently

I have an index with a date field with the definition of "locale" in it. However, when I perform a simple query that includes the date histogram aggregation, the date format I specified as &...
0votes
0answers
25views

Get Aggregate results grouped by nested field value(s)

Sample input json: Email1 - Paragraph1: { “ParagraphId”: “Para1", “EmailId”: “Email1", “Content”: “The city is Chennai”, “Tags”: [ { “TagId”: “Tag1”, ...
0votes
0answers
16views

Clarifications on ElasticSearch architecture

ES = Elastic Search Can ES be used for persistent data storage ? Is ES used only for search or for normal data storage as well, like a normal JSON/Document datastore for an application dealing with ...
0votes
0answers
17views

Bucket aggregation that doesn't depend on the time range in Elasticsearch

I'm using Elasticsearch 7.9.3 to query time series data metrics which are stored in a form of: { "timestamp": <long>, "name" : <string - metric name>, "...

153050per page