CODEWITHSUNDEEP
elasticsearch
Anant Pathak
Anant Pathak

Reputation: 207

Getting empty buckets array in elasticsearch aggregation

I'm using version 5.4.1 of ElasticSearch.

When I try to perform a groupBy aggregate/bucket aggregate, I'm not getting any values in the bucket array.

This is my index:

   curl -X PUT localhost:9200/urldata -d '{
    "mappings" : {
        "components" : {
            "properties" : {
                "name" : {
                    "type" : "keyword",
                    "index" : "not_analyzed"
                },
                "status" : {
                    "type" : "keyword",
                    "index" : "not_analyzed"
                },
                "timestamp":{
                    "type":"date",
                    "index":"not_analyzed"
                }
            }
        }
    }
}'

And this the aggregate query:

curl -XGET 'localhost:9200/urldata/_search?pretty' -H 'Content-Type: application/json' -d'
    {
      "size": 0,
      "aggs": {
        "components": {
          "terms": {
            "field": "name.keyword"
          }
        }
      }
    }
    '

Output:

{  
"took":2,
   "timed_out":false,
   "_shards":{  
      "total":5,
      "successful":5,
      "failed":0
   },
   "hits":{  
      "total":3,
      "max_score":0.0,
      "hits":[  

      ]
   },
   "aggregations":{  
      "components":{  
         "doc_count_error_upper_bound":0,
         "sum_other_doc_count":0,
         "buckets":[  

         ]
      }
   }
}

Where am I going wrong??

Upvotes: 1

Views: 5924

Answers (1)

mel
mel

Reputation: 2790

Try this, it should do it:

{
  "size": 0,
  "aggs": {
    "components": {
      "terms": {
        "field": "name"
      }
    }
  }
}

EDIT:

Here is all the steps to replicate your use case:

PUT test
{
    "settings" : {
        "index" : {
            "number_of_shards" : 1, 
            "number_of_replicas" : 0
        }
    }
}

PUT test/_mapping/people_name
{  
  "properties":{  
      "name":{  
        "type":"keyword",
        "index":"not_analyzed"
      },
      "status":{  
        "type":"keyword",
        "index":"not_analyzed"
      },
      "timestamp":{  
         "type":"date",
         "index":"not_analyzed"
      }
  }
}

POST test/people_name
{
  "name": "A", 
  "status": "success", 
  "created_at": "2017-08-17"
}

POST test/people_name
{
  "name": "A", 
  "status": "success_2", 
  "created_at": "2017-06-15"
}

POST test/people_name
{
  "name": "B", 
  "status": "success", 
  "created_at": "2017-09-15"
}

GET test/people_name/_search
{
  "size": 0,
  "aggs": {
    "components": {
      "terms": {
        "field": "name"
      }
    }
  }
}

The result of the aggregation is:

{
  "took": 3,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "failed": 0
  },
  "hits": {
    "total": 3,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "components": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "A",
          "doc_count": 2
        },
        {
          "key": "B",
          "doc_count": 1
        }
      ]
    }
  }
}

Upvotes: 2

Related Questions