Hi, I'm trying to fetch more than 10000 number of values in my kibana data table visualization.
I get the error above, I edited index.max_result_window in all my elasticSearch indexes. But I get the same error
I can use the same query changing the size value in json format, it works, but in Kibana not.
{
"aggs": {
"0": {
"terms": {
"field": "XXXXXXXX",
"order": {
"_count": "desc"
},
"size": 100000
}
}
},
"size": 0,
"fields": [
{
"field": "Date",
"format": "date_time"
},
{
"field": "insertion_time",
"format": "date_time"
}
],
"script_fields": {},
"stored_fields": [
"*"
],
"runtime_mappings": {},
"_source": {
"excludes": []
},
"query": {
"bool": {
"must": [],
"filter": [
{
"bool": {
"must_not": {
"bool": {
"should": [
{
"match": {
"Progressive": "1"
}
}
],
"minimum_should_match": 1
}
}
}
},
{
"range": {
"Date": {
"format": "strict_date_optional_time",
"gte": "2025-02-25T09:28:56.413Z",
"lte": "2025-03-12T09:28:56.413Z"
}
}
}
],
"should": [],
"must_not": []
}
}
}
What can I do to get it work?
Kibana version: 8.9.0
Elastic version: 8.9.0