Elastic search document count passing array

Question

i am new in ElasticSearch i want count document based on id but i want to pass array in id like "myId":[1,2,3,4,5]

for every id i want count number

Current input

GET /probedb_v1/probe/_count
{
 "query": {
    "match_phrase": {
       "myId": 1
     }
  }
}

Current output

{ "count": 6929,
 "_shards":{ "total": 1,
  "successful": 1,
  "failed": 0
}
}

What is input for my Required Output

{ "count": [6929,5222,65241,5241,6521],
 "_shards":{ "total": 1,
  "successful": 1,
  "failed": 0
}
}

also need code for elasticsearch java-api

The _id is unique per index and type combination. So counting _id doesn't make sense. — Andrei Stefan
– Andrei Stefan, Commented May 18, 2016 at 11:57
you will have to use aggregates. even that will not give the output in your desired format. — undefined_variable
– undefined_variable, Commented May 18, 2016 at 12:18

Andrei Stefan · Accepted Answer · 2016-05-18 12:35:07Z

1

You can do it like this:

GET /probedb_v1/probe/_search
{
  "size": 0,
  "query": {
    "terms": {
      "myId": [123, 44]
    }
  }, 
  "aggs": {
    "NAME": {
      "terms": {
        "field": "myId",
        "size": 50
      }
    }
  }
}

This will give you this output:

   "aggregations": {
      "NAME": {
         "doc_count_error_upper_bound": 0,
         "sum_other_doc_count": 0,
         "buckets": [
            {
               "key": 123,
               "doc_count": 3
            },
            {
               "key": 44,
               "doc_count": 2
            }
         ]
      }
   }

edited May 18, 2016 at 12:35

answered May 18, 2016 at 12:18

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Amar Gohil Over a year ago

Thanks, but it works but not as expected. I need separate outputs(count) for each input. I received this output. ** "hits": {"total": 2,} **

Andrei Stefan Over a year ago

Your English is not that good and I don't understand what you mean. The output as "count": [6929,5222,65241,5241,6521] is not possible in Elasticsearch. The best approach is with aggregations and the output I provided in my answer.

Collectives™ on Stack Overflow

Elastic search document count passing array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related