How to do an ElasticSearch Select Distinct

Question

I just want to do the following request with elasticsearch.

In SQL :

Select distinct(id) from my_table where userid = '20' or activity = '9'; 

I just have :

{    "query" : {         "bool" : {                "should" : [                    { "term" : { "userid" : "20" } },                    { "term" : { "activity" : "9" } }                ]          }     } } 

Thanks in advance :)

Answer 1

You're almost there, you simply need to add a terms aggregation to your query

{    "query" : {         "bool" : {                "should" : [                    { "term" : { "userid" : "20" } },                    { "term" : { "activity" : "9" } }                ]          }     },     "aggs":{         "unique_ids": {             "terms": {                 "field": "id"             }         }     } }