How to aggregate query result in elasticsearch

Question

I am new in elasticsearch. I want elasticsearch result be like following sql query,

select distinct(car_name) from car_master where car_name like '%SUV%'

I am getting result by doing:

{ "query": {
    "query_string": {
    "fields" : ["car_name"],
    "query": "*SUV*"
    }
  }
}

but I want distinct records.

Val · Accepted Answer · 2017-07-25 12:51:56Z

3

You are almost there, you simply need to add a terms aggregation on the car_name field:

{ 
  "query": {
    "query_string": {
    "fields" : ["car_name"],
    "query": "*SUV*"
    }
  },
  "aggs": {
    "cars": {
      "terms": {
        "field": "car_name"
      }
    }
  }
}

answered Jul 25, 2017 at 12:51

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

How to aggregate query result in elasticsearch

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related