Skip to main content

All Questions

0 votes
1 answer
67 views

How to filter buckets based on the comparison of two sub-aggregation metrics in ElasticSearch (python)?

My index has documents with the following fields: user_id, user_name, post_text, post_sentiment where post_sentiment is of type double, and represents the sentiment of the post. A post_sentiment ...
Ashar Ahmad's user avatar
0 votes
1 answer
74 views

How to filter the buckets that have more than N documents using ElasticSearch DSL in python?

I have an index in ElasticSearch that contains information of a user in each document, along with the facebook posts they have made (in a denormalized manner). Each document contains: User_ID | ...
Ashar Ahmad's user avatar
0 votes
1 answer
55 views

searching for space separated words in Elasticsearch

my data is, POST index_name/_doc/1 { "created_date" : "2023-02-09T13:21:41.632492", "created_by" : "hats", "data" : [ ...
Harshin Ramesh's user avatar
1 vote
0 answers
39 views

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. {&...
Robin Rawat's user avatar
0 votes
1 answer
265 views

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": {'...
sakshatsurve's user avatar
0 votes
1 answer
855 views

Python Elasticsearch aggregated query

I am struggling to get an aggregated response based on a query... for example, in Kibana visualization, after creating a table with the aggregations and query I need, I can view the request by going ...
Sederfo's user avatar
  • 197
1 vote
1 answer
476 views

Elasticsearch DSL. Build bounding box filter inside aggregation

I need build geotitle_grid aggregation with geo_bounding_box Here is my code: search_query: DslSearch = DslSearch() enriched_value = { "aggregations": { "...
MrOldSir's user avatar
  • 736
3 votes
1 answer
703 views

django-elasticsearch-dsl: how to add script to filter?

I have a 'MovieDoc' document and inside it a ListField called 'actors' that contains a list of ObjectFields with properties such as 'last_name', 'first_name', 'country,' etc. When running a query with ...
Edmond's user avatar
  • 79
1 vote
1 answer
271 views

Unable to replicate post_filter query in elasticsearch-dsl

The query I would like to replicate in DSL is as below: GET /_search { "query":{ "bool":{ "must":[ { "term":{ ...
Akshay Bhonde's user avatar
0 votes
1 answer
707 views

How to merge two DSL query for aggregation and filter

I need to search BusinessArea which is Research or Accounting this is array of fields(OR) statement I need to search Role is Developer or Tester condition this is array of fields(OR) statement I want ...
user avatar
1 vote
1 answer
2k views

Elastic Search Sampling Aggregation UNKNOWN KEY

Currently working with Kibana with 6 Billion + documents and trying to get a sampling based on the 'index' which is the particular day the sample was collected. from elasticsearch import ...
SDG's user avatar
  • 2,342
0 votes
2 answers
62 views

Beautify the Python Nested Dictionary Code

Output : { "aggs": { "overall": { "date_histogram": { "field": "created", "calendar_interval": "day", "time_zone": 3 }, "aggs": { "...
etotientz's user avatar
  • 414
0 votes
1 answer
48 views

Filtered Aggregation returns no results

I'm trying to replicate filtered aggregation on an example below: Here, I'm trying to filter documents that match the name of a pipeline and find the maximum duration to execute among those pipelines. ...
gatech-kid's user avatar
0 votes
3 answers
317 views

Why 'from' keyword goes unrecognizable while achieving pagination in aggregation in Elastic Search

I am trying to paginate 50 data at once in aggregation, so i gave it a try with below code. "aggs": { "source_list": { "terms": { "field": "source....
TrickOrTreat's user avatar
4 votes
1 answer
366 views

Custom Histogram aggregation in Elasticsearch

I have a index of following structure item_id: unique item id sale_date: date of the date price: price of the sale wrt the date I want to create a histogram of the latest sale prices per item. ...
Jugraj Singh's user avatar

15 30 50 per page