Show more than 10 buckets


(Maiko Kuipers) #1

I created a query which groups transactions and returns them as buckets. The problem that I'm currently facing is that elasticsearch only returns 10 buckets. How can I make my query return more than 10 buckets?

I posted my code below. I tried to place a size attribute in my groupby but that just gave me an error.
Thanks in advance

GET /ido-laad/_search
{   "query" : {
            "bool" : {
              "must" : [
                 { "term" : {"IsValid" : "true"}},
                 { "range" : {
                  "TimeStamp" : {
                "gte": "2016/12/01",
                "lte": "2016/12/02",
                "format": "yyyy/MM/dd"
            }
         }}
              ],"must_not": [
                
              ]
      }
   },
  "size": 0,
  
  "aggs": {
    "group_by_transaction_id": {
      "terms": {
        "field": "Transaction_ID"
      },
      "aggs": {
        "tot_min": {
          "sum": {
            "field": "DeltaMinutesPreviousRowWithinTransaction"
          }
      }
  
}
},
      "avg_total_minutest": {
           "avg_bucket": {
                "buckets_path": "group_by_transaction_id>tot_min" 
            }
}
}
}

(Heinmci) #2

Hi, did you try :

 "aggs": {
    "group_by_transaction_id": {
      "terms": {
        "field": "Transaction_ID",
         "size" : 500
      }

(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.